Managerial Accounting 226 Financial Statement Analysis Project This project is to be completed with a partner. You are to pick from the following groups of companies and perform a financial statement analysis in Excel, comparing the performance between the two companies you choose. A written summary explaining your analysis is also required. Use years 2019 and 2020: Microsoft vs. Apple on o Requirements: 1. Prepare a Comparative Balance Sheet & Income statement comparing years '19 and '20. 2. Prepare a Common-size Balance Sheet & Income statement for years '19 and '20, using total assets as the base for the balance sheet and Sales as the base for the income statement. 3. Calculate the following ratios for '19 and '20 (clearly label and show calculations either as a formula or typed out): a. Current ratio b. Accounts Receivable turnover C. Average collection period d. Inventory turnover e. Average sale period f. Operating cycle g. Total asset turnover h. Times interest earned i. Debt-to-equity ratio j. Equity multiplier k. Gross Margin percentage 1. Net Profit Margin Percentage m. Return on total assets n. Return on equity 0. EPS p. Price-Earnings ratio q. Dividend payout ratio r. Dividend yield ratio s. Book value per share Managerial Accounting 226 Financial Statement Analysis Project This project is to be completed with a partner. You are to pick from the following groups of companies and perform a financial statement analysis in Excel, comparing the performance between the two companies you choose. A written summary explaining your analysis is also required. Use years 2019 and 2020: Microsoft vs. Apple on o Requirements: 1. Prepare a Comparative Balance Sheet & Income statement comparing years '19 and '20. 2. Prepare a Common-size Balance Sheet & Income statement for years '19 and '20, using total assets as the base for the balance sheet and Sales as the base for the income statement. 3. Calculate the following ratios for '19 and '20 (clearly label and show calculations either as a formula or typed out): a. Current ratio b. Accounts Receivable turnover C. Average collection period d. Inventory turnover e. Average sale period f. Operating cycle g. Total asset turnover h. Times interest earned i. Debt-to-equity ratio j. Equity multiplier k. Gross Margin percentage 1. Net Profit Margin Percentage m. Return on total assets n. Return on equity 0. EPS p. Price-Earnings ratio q. Dividend payout ratio r. Dividend yield ratio s. Book value per share