Please Show Formulas Does not have to be done in excel Thank

Please Show Formulas, Does not have to be done in excel! Thanks

BUSINESS FINANCIAL MODEL SALES ($) GROSS PROFIT ($) EBIT EBIT MARGIN (%) COST OF GDS SOLD ($) TOTAL COST VARIABLE SALES (S) O/H EXP ($) RETURN ON ASSETS (%) FIXED O/H EXPENSE (S) ASSET TURNS (%) SALES ($) INVENTORY CURRENT ASSETS ($) TOTAL NET ACCTS RECV ($) ASSETS ($) FIXED ASSETS ($) CASH ON HAND ($)

Solution

As per rules I will answer the first 4 subparts of the question.

1.EBIT= = (Sales- COGS- Overheads)

=500343-373396-106510

=20437

2:EBIT Margin=( EBIT/ Sales)*100

=(20437/ 500343)*100

=4.08%

3:Asset Turnover= Sales/ Total assets

= Sales/ (Inventory+ Cash + fixed assets +Receivables + Prepaid expenses)

= 500343/ (43783+6756+144858+5614+3511)

=2.45 times

4:Return on assets= Net Income/ Total assets

=EBIT in this case/ Total assets

= 20437/(43783+6756+144858+5614+3511)

=9.99%