do them all using excel

Comparative Balance Sheets: 2018 and 2019 ACT202: Spring 2020 Financial Statement Analysis: Vertical Analysis: 2019 Horizontal Analysis Percentage Dollar Change Change At 12-31-19 At 12-31-18 7,450 45,900 86,620 20,120 160,090 7,840 58.410 79.0301 18.600 163,880 Assets Current Assets Cash & cash equivalents Accounts receivable Inventory Other current assets Total current assets Long-term assets (non-current) Property, Plant, & Equipment: Land Buildings Fixtures, computer equipment Construction-in-progress Accumulated depreciation Total P.P. & E Other non-current assets Total long-term assets Total assets 62,9201 317,560 84,470 11,230 (136,920) 339,260 16,020 355,280 515,370 62,050 286,530 79,290 11.760 (133. 1101 306,530 11,220 317,750 481,630 LS I$ $ Uabilities Current liabilities Accounts payable Salaries payable Interest payable Income tax payable Total current abilities Long-term liabilities Bonds payable Total liabilities 77.930 38,120 14,200 12.330 142.580 70.5601 39.810 14 900 15.000 140,270 174 490 175,740 316,010 317,070 580 Shareholders Equity Common Stock APIC Retained earnings Accum Other Comprehensive Loss Total shareholders equity Total liabilites and shareholders equity 540 54.200 150 990 17.9301 199 200 515 370 39,250 13155o (5.7601 165.620 481.630 6,600 6400 No. of outstanding shares: 12-31-19 No. of outstanding shares: 12-31-18 Price per share: Dec 31, 2019 Price per share: Dec 31, 2018 Comparative Income Statements: 2018 and 2019 Horizontal Analysis Percentage Dollar Change Change Vertical Analysis: 2019 2019 2018 Sales Cost of Sales Gross profit 765.900 531,600 234,300 732,980 505,680 227,300 $ Operating Expenses Selling, general, admin expenses Credit card expenses Depreciation expense Total operating expenses Operating income (EBIT) Interest expense Income before Income Taxes (EBT) Income tax expense Net Income 159,840 5.120 25 230 190,190 44,110 6.940 37.170 7.806 29,364 147,530 4,670 21,420 173,620 53,680 7,620 46,060 9,673 36,387 Ratio Analysis Profitability Ratios 2019 Gross Profit Ratio Gross profit/Net sales revenue Net Profit Margin Net income/Net sales revenue Return on Assets Net income/Ave total assets Return on Equity Net income/Ave shareholders' equity Earnings per Share Net income-PS Div/Ave Shares 0/5 Price Earnings Ratio Price/EPS Liquidity Ratios Current Ratio Current assets/Current liabilities Quick Ratio (Acid-Test) Quick assets/Current Liabilities 1000000 000 000) Receivables Turnover Net sales revenue/Ave AR Days Sales Outstanding 365/Receivables turnover Inventory Turnover COGS/Ave inventory Days Sales in Inventory 365/Inventory turnover Solvency Ratios Debt to Assets Total debt/Total assets Debt to Equity Total debt/Total shareholders' equity Times Interest Earned Operating income/Interest expense Operating Efficiency Total Asset Turnover Net sales/ Ave total assets