Please show all Excel calculations and explanations as required. Thank you.

Maple Inc. Statement of Financial Position As at December 31" M M M Assets Cash $80,000 $125,000 $90,000 Accounts receivable (net) 450,000 316,000 285,000 Inventory 480,000 280,000 275,000 Prepaid expenses mm mm mm Total current assets 1,028,000 739,000 668,000 Property, plant & equipment (net) 2,750,000 2,600,000 2 450 000 Total assets mum 53.112913! 53.10.9519 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 gm 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 m W Maple Inc. Income Statement For the years ended December alst, 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 m m 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 - 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: 8.0 Debt to equity ratio: 60% 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 nancial 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