Question

QUESTION 3 From following financial statements, calculate following ratios and analyse the current year and previous year performance a) Current ratio. b) Days sales outstanding (DSO). (Sales 2017 RM500m & Sales 2018 RM600m) c) Inventory turnover ratio d) Total debt to assets e) Return on assets (ROA) (Net income 2017 RM42m &Net income 2018 RM58m)
Moon Inc. Balance Sheet (RM millions) as at December 31, 2015 and 2016 2015 21 51 2016 20 84 Cash Accounts receivable Inventory Prepaid expenses Total current assets Gross plant and equipment Less: Accumulated depreciation 85 Net piant and equipment Total Assets 106410 371 (115) 286 295 Liabilities & Equities Accounts payable Accrued expenses 41 10 14 42 12 64 Short-term notes Total current liabilities Long-term debt Total liabilities 225 235 Common stockholders equity 82 85 16 392 Common stock Retained earnings 82 121 Total common stockholders equity Total liabilities and equity FORMULA: Current ratio = Current assets/current liabilities Days sales outstanding (DSO) Account Receivable(Sales+365) Inventory turnover ratio Sales/Inventories Total debt to assets- Total debt/Total assets Return on assets (ROA) Net income/Total assets Return on equity (ROE) Net income/Total equity
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you.
Year 2015 Year 2016
a. Current Ratio: Current assets $       106 $       143
Current Liabilities $         65 $         64
Current Ratio Current assets/Current Liabilities          1.63          2.23 Times
Current ratio has improved in Year 2016 compared to Year 2015. Low ratio indicates cash problems.
Though high ratio is also indiative of too much of working capital, however comparative to 2015, 2016 is good.
To have better idea, we should also check industry norms.
b. Days Sales Outstanding Accounts Receivable $         31 $         36
Sales $       500 $       600
Days Sales Outstanding Accounts Receivable/(Sales/365)        22.63        21.90 Days
Days sales outstanding has improved in Year 2016. Earlier days sales outstnading was almost 23 days
which now has reduced to 22 days
c. Inventory Turnover Ratio Inventory $         51 $         84
Sales $       500 $       600
Inventory Turnover Ratio Sales/Inventories          9.80          7.14
This ratio shows how effectively inventory is being managed. Higher ratio is sign of ineffective management.
Hence, there is improvement in Turn ratio in 2016
d. Total debt to Assets Total Debt $       225 $       235
Total Assets $       392 $       438
Total Debt to Assets Total Debt/Total Assets          0.57          0.54
There is improvement in the ratio since increase in debt is lesser than increase in assets.
e. Return on Assets Net Income $         42 $         58
Total Assets $       392 $       438
Return on Assets Net Income/Total Assets 10.71% 13.24%
Return on assets has imprved in Year 2016 meaning deplyoment of assets is generating more income in 2016
f. Return on Equity Net Income $         42 $         58
Total Equity $       167 $       203
Return on Equity Net Income/Total Equity 25.15% 28.57%
Return on Equity has imprved in Year 2016 meaning there is more income being generated against capital invested.
Add a comment
Know the answer?
Add Answer to:
QUESTION 3 From following financial statements, calculate following ratios and analyse the current year and previous...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit;...

    need help ? Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $52.900; total assets, $229,400; common stock, $88,000; and retained earnings. $32,712.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 450, 600 Cost of goods sold 297,650 Gross profit 152,950 Operating expenses 99, 100 Interest expense 3,800 Income before taxes 50,050 Income taxes 20. 162 Net Income $ 29,888 $ 16,500...

  • Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...

    Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $50,900; total assets, $249,400; common stock, $90,000; and retained earnings, $43,304.) CABOT CORPORATION Income Statement Por Year Ended December 31, 2017 Sales $ 451,600 Cost of goods sold 298,050 Gross profit 153,550 Operating expenses 99,000 Interest expense 3,900 Income before taxes 50,650 Income taxes 20,404 Net income $...

  • Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation...

    Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $50,900; total assets, $169,400; common stock, $84,000; and retained earnings, $31,305.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 455,600 Cost of goods sold 297,350 Gross profit 158,250 Operating expenses 98,800 Interest expense 4,700 Income before taxes 54,750 Income tax expense...

  • urrent Attempt in Progress The condensed financial statements of Crane Company for the years 2016 and...

    urrent Attempt in Progress The condensed financial statements of Crane Company for the years 2016 and 2017 are presented below. CRANE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 530 460 Inventory 640 570 Prepaid expenses 130 160 Total current assets 1,630 1,550 Property, plant, and equipment (net) 410 380 Investments 70 70 Intangibles and other assets 530 510 Total assets $2,640 $2,510 Current liabilities $880 $850 Long-term...

  • The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below....

    The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below. IVANHOE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 580 510    Inventory 550 480    Prepaid expenses 130 160      Total current assets 1,590 1,510 Property, plant, and equipment (net) 410 380 Investments 120 120 Intangibles and other assets 530 510      Total assets $2,650 $2,520 Current liabilities $930 $900 Long-term liabilities 570 470 Stockholders’...

  • Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation...

    Problem 13-4A Calculation of financial statement ratios LO P3 Selected year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31, 2016, were inventory, $47,900; total assets, $209,400, common stock, $90,000; and retained earnings, $37,678.) CABOT CORPORATION Income Statement For Year Ended December 31, 2017 Sales $ 453,600 Cost of goods sold 298,450 Gross profit 155, 150 Operating expenses 99,200 Interest expense 4,000 Incone before taxes 51,950 Income taxes 20,928 Net Income...

  • [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company...

    [The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. 2815 $ 229,500 141, 120 79,388 29,106 18, 382 X KORDIN COMPANY Comparative Income statements For Years Ended December 31, 2017, 2016, and 2015 2017 2016 Sales $ 414,761 $ 317,741 Cost of goods sold 249,686 199,859 Gross profit 165, 075 117,882 Selling expenses 58,896 43.848 Administrative expenses 37,328 27,961 Total expenses 96,224 71, 809 Income before taxes 63,851 46,073 Income taxes 12,886...

  • Q-2 FINANCIAL RATIO FORMULAS Match each of the following financial ratios with its formula: Accounts Payable...

    Q-2 FINANCIAL RATIO FORMULAS Match each of the following financial ratios with its formula: Accounts Payable Tunover Ratio Fixed Asset Turnover Ratio Asset Turnover Ratio Cash Coverage Ratio Cash Ratio Current Ratio Average Age of Receivables Average Days Supply in Inventory Receivable Turnover Ratio Debt-to-Equity Ratio Earnings per Share (EPS) Financial Leverage Percentage Times Interest Earned Ratio Inventory Turnover Ratico Price/ Earnings (P/E) Ratio Profit Margin Quality of Income Quick Ratio Return on Equity (ROE) Return on Assets (ROA) A....

  • The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below....

    The condensed financial statements of Ivanhoe Company for the years 2016 and 2017 are presented below. IVANHOE COMPANY Balance Sheets December 31 (in thousands) 2017 2016 Current assets    Cash and cash equivalents $330 $360    Accounts receivable (net) 630 560    Inventory 600 530    Prepaid expenses 130 160      Total current assets 1,690 1,610 Property, plant, and equipment (net) 410 380 Investments 170 170 Intangibles and other assets 530 510      Total assets $2,800 $2,670 Current liabilities $980 $950 Long-term liabilities 620 520 Stockholders’...

  • Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation...

    Problem 13-4A Calculating financial statement ratios LO P3 Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selo at December 31 of the prior year were inventory, $50,900; total assets, $209,400; common stock, $83,00 $54,315.) CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales $ 452,600 Cost of goods sold 297,550 Gross profit 155,050 Operating expenses 99,500 Interest expense 4,500 Income before taxes 51,050 Income tax expense 20,565 Net income $ 30,485 $...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT