y Instructions Rubric Financial Stateme DATA: Groot Tree Company Comparative Financial Statements 2018 2017 Income Statement Sales revenue Cost of goods sold 940,930.75 653,424.132 287.506.618 171,458.492 36,591.751 79.456.374 19.602.724 59,853.65 880,930.75 603,018.073 277,912.677 167.796.333 20,974.542 89,141.802 20,974.54 68,167.26 nterest ex ncome tax expense et income Balance Sheet Cash 100,157.057 120,188.469 163,414.146 411,171.078 794,930.75 90,369.003 116,948.121 157.348.381 324,265.245 688,930.75 ccounts receivable (net) nvento Pr perty and equipment (net) 197,151.26 200,314.115 210,856.963 186,608.412 794,930.75 Current liabilities (no interest) Long-term liabilities (6% interest) Share Capital Retained earnings 193.495.982 159.474.711 212,632.948 | 123.32 688,930.75 Other information Number of common shares outstanding throughout 2017-2018 Accounts receivable (net), end of 2016 21,085.696 108,000 212,000 59,000 300,000 630,000 30 21 ventory, end of 2016 Shareholders' equity, end of 2016 and equipment (net), end of 206 Total assets, end of 2016 Share Share price, end of 2017 end of 2018 l Home 12:35 PM X ACC2310 Excel Finan... Instructions Rubric Financial Statements Part 1 Horizontal Part 2 Vert PART 3: RATIO ANALYSIS Prefitability Raties Net Prefn Margi Liquidity Raties Operating Cyd Leverage Ratios Debt Ratio Instructions Rubric Financial Statements Part 1 Horizontal Part 2 Vertical Part, R y Instructions Rubric Financial Stateme DATA: Groot Tree Company Comparative Financial Statements 2018 2017 Income Statement Sales revenue Cost of goods sold 940,930.75 653,424.132 287.506.618 171,458.492 36,591.751 79.456.374 19.602.724 59,853.65 880,930.75 603,018.073 277,912.677 167.796.333 20,974.542 89,141.802 20,974.54 68,167.26 nterest ex ncome tax expense et income Balance Sheet Cash 100,157.057 120,188.469 163,414.146 411,171.078 794,930.75 90,369.003 116,948.121 157.348.381 324,265.245 688,930.75 ccounts receivable (net) nvento Pr perty and equipment (net) 197,151.26 200,314.115 210,856.963 186,608.412 794,930.75 Current liabilities (no interest) Long-term liabilities (6% interest) Share Capital Retained earnings 193.495.982 159.474.711 212,632.948 | 123.32 688,930.75 Other information Number of common shares outstanding throughout 2017-2018 Accounts receivable (net), end of 2016 21,085.696 108,000 212,000 59,000 300,000 630,000 30 21 ventory, end of 2016 Shareholders' equity, end of 2016 and equipment (net), end of 206 Total assets, end of 2016 Share Share price, end of 2017 end of 2018 l Home 12:35 PM X ACC2310 Excel Finan... Instructions Rubric Financial Statements Part 1 Horizontal Part 2 Vert PART 3: RATIO ANALYSIS Prefitability Raties Net Prefn Margi Liquidity Raties Operating Cyd Leverage Ratios Debt Ratio Instructions Rubric Financial Statements Part 1 Horizontal Part 2 Vertical Part, R