The question are on the picture provided. 1. Prepare a financial statement analysis for Maple Inc. The analysis should include a review of all four categories of ratios (Liquidity, Activity, Solvency and Profitability). The analysis should be both quantitative and qualitative. (20 marks). 2. From your analysis, what are two areas of significant concern to Maple Inc?
Maple Inc. Statement of Finanu'al Position As at December 31* m m M Assets Cash 580,000 $125,000 $90,000 Accounts receivable (net) 450,000 316,000 285,000 Inventory 430,000 280,000 275,000 Prepaid expenses 1&5!!! 1810152 1mm Total current assets 1,028,000 739,000 668,000 Property, plant 8. equipment (net) 2 750 000 2 600 000 2,450,000 Total assets $1118.00: $1313.11\"! 53.113311! Liabilities Accounts payable $625,000 $431,000 $386,000 Income taxes payable 10 000 15,000 24,000 Total current liabilities 635,000 446,000 410,000 Long-term debt 1 070 000 1 100 000 1 294 000 Total liabilities M m M Shareholders' Equity Common shares $650,000 $650,000 $650,000 Retained eamings 1 423 000 1 143 000 764,000 Total shareholder equity 2 073 000 1 793 000 1 414 000 Total liabilities and shareholders' equity M w W Maple Inc. Income Statement For the years ended December 315:, 2019, and 2020 2020 2019 Revenue $4,000,000 $3,400,000 Cost of goods sold 2 240 000 1 700 000 Gross margin 1,760,000 1,700,000 Operating expenses 1 260 000 1 149 000 Operating income 500,000 551,000 Interest expense 75 000 77,000 Income before tax expense 425,000 474,000 Income tax expense 85 000 95,000 Net income 340 000 $79,000 Other information: o Depreciation expense for the three years (included in operating expenses) was as follows: 0 2018: $305,000 0 2019: $289,000 0 2020: $272,000 0 n The following ratios are averages forthe companies that Maple competes against: 0 Current ratio: 2.10 Quick ratio: 1.10 Accounts receivable turnover: 9.50 Inventory turnover: 80 Debt to equity ratio: 6096 Gross margin: 52%% Return on equity: 20% Return on assets: 14%% 0000000 Management is concerned by the nancial results for the current year. Net income for 2020, as a percentage of sales revenue, was not as high as in 2019, even though sales increased by $600,000. Management has asked you to review the financial statements and provide an assessment of the company's performance against the industry standards provided. Management is interested in knowing what expense items have changed signicantly, as a percentage of sales revenue and have asked you to \"common size\" the income statement. Required: 1. Prepare a nancial statement analysis for Maple Inc. The analysis should include a review of all four categories of ratios (Liquidity, Activity, Solvency and Profitability). The analysis should be both quantitative and qualitative. (20 marks) 2. From your analysis, what are two areas of significant concern to Maple Inc
