1. Calculate the following risk ratios for 2018 and 2019: Receivable Turnove rat
ID: 2533462 • Letter: 1
Question
1. Calculate the following risk ratios for 2018 and 2019: Receivable Turnove ratio, Inventory Turnover Ratio, Current Ratio, Debt to Equity Ratio
2. Calculate the following profitability ratios for 2018 and 2019: Gross Profit, Return on Assets, Profit Margin, Asset Turnover
ncome Statements For the years ended December 31 2019 2018 Net sales Cost of goods sold $11,380,000 $9,850,000 6,100,000 7,430,000 Gross profit 3,950,000 3,750,000 Expenses: Operating expenses Depreciation expense Interest expense Income tax expense 1,670,000 200,000 47,000 484,000 1,620,000 200,000 47,000 420,000 Total expenses 2,401,000 2,287,000 Net income $1,549,000 $1,463,000Explanation / Answer
1.) Risk ratios
Receivables turnover ratio
2018.
Recivables turnover ratio= Net credit sales/ average accounts receivables
net credit sales=$9,850,000
average accounts receivables= (opening accounts receivables + closing accounts recivables )/2
opening accounts receivables of 2018= $767000(closing accounts receivables of 2017 will be opening accounts receivables for 2018)
closing accounts recievables of 2018= $747000
average accounts receivables =(767000+747000)/2=$757000
ratio= $9,850,000/757000=13.011889 or round to 13.01
2019.
Recivables turnover ratio= Net credit sales/ average accounts receivables
net credit sales=$11,380,000
average accounts receivables= (opening accounts receivables + closing accounts recivables )/2
opening accounts receivables of 2019= $747000(closing accounts receivables of 2018 will be opening accounts receivables for 2019)
closing accounts recievables of 2019= $997000
average accounts receivables =(747000+997000)/2=$872000
ratio= $11,380,000/872000=13.05045 or round to 13.05
Inventory turnover ratio
2018
cost of goods sold / average inventory of the period
cost of goods sold = $6,100,000
average inventory = (opening inventory +closing inventory)2
opening inventory of 2018= $1,032,000( closing inventory of 2017 will be opening inventory for 2018)
closing inventory of 2018= $13,62,000
average inventory = ($1,032,000+$1362000)/2= $1,197,000
ratio= $6,100,000/$1,197,000= 5.09607 or round to 5.10
2019
cost of goods sold / average inventory of the period
cost of goods sold = $7,430,000
average inventory = (opening inventory +closing inventory)2
opening inventory of 2019= $1,362,000( closing inventory of 2018 will be opening inventory for 2019)
closing inventory of 2019= $1,732,000
average inventory = ($1,362,000+$1,732,000)/2= $1,547,000
ratio= $7,430,000/$1,547,000= 4.8028 or round to 4.80
Current ratio
2018
current assets / currents liability
current assets =($161000+747000+1362000+107000)=$2,377,000
current liabilities=($126000+$42000)=$168000
ratio= $2377000/168000=14.1488 or round to 14.15
2019
current assets / currents liability
current assets =($232000+$997000+1732000+137000)=$3098000
current liabilities=($195300+4700+47000)=$247000
ratio= $3098000/247000= 12.5425 or round to 12.54
Debt to equity ratio
2018
total liability/ stock holders equity or debt / equity
debt = current liability + long term liability
(126000+42000+570000)=$738000
equity= (670000+1879000=$2549000
ratio = $738000/2549000= 0.2895 or 0.29:1
another approach of debt to equity ratio
there is another approach of debt to equity ratio in which debts include only long term debt . we can follow the both approach according to answer . Both approaches are correct
debt = $570000
equity= 2549000
ratio= $570000/$2549000=0.2236 or round to 0.22:1
2019
total liability/ stock holders equity or debt / equity
debt = current liability + long term liability
(195300+4700+47000+570000)=$817000
equity= (670000+2321000=$2991000
ratio = $817000/2991000= 0.27315 or 0.27:1
another approach of debt to equity ratio
there is another approach of debt to equity ratio in which debts include only long term debt . we can follow the both approach according to answer . Both approaches are correct
debt = $570000
equity= $2991000
ratio= $570000/$2991000=0.19057 or round to 0.19:1
2.)Profitiblity ratio
Gross profit ratio= (gross profit /net sales)*100
2018=($3750000/$9850000)*100=38.07%
2019=($3950000/$11380000)*100=34.71%
RETURN ON ASSETS
(NET INCOME / TOTAL ASSETS)*100
2018=($1463000/$3287000)*100=44.5086 OR 44.51 %
2019=($1549000/$3808000)*100=40.67752 OR 40.68%
PROFIT MARGIN RATIO
(net income / sales)*100
2018=($1463000/$9850000)*100=14.85279 or 14.85%
2019=($1549000/$11380000)*100=13.6115 or 13.61%
ASSETS TURNOVER RATIO
(net sales / average assets)*100
2018
net sales= $9850000
average assets= (opening assets+ closing assets)/2
closing assets of 2017 will be opening of 2018
($3209000+3287000)/2=$3248000
($9850000/3248000)*100= 303.2635 or 303.26%
2019
net sales= $11380000
average assets= (opening assets+ closing assets)/2
closing assets of 2018 will be opening of 2019
($3287000+$3808000)/2=$3547500
($11380000/3547500)*100= 320.7892 or 320.79%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.