answer using formulas in excel please

PART 1 (150 points): For each competitor company compute the following 10 ratios for the most recent year (2020) for each company. The 2019 balance sheet will be needed to compute average total assets and average stockholders' equity. Round your answers to 2 decimal places. For percentages, show the percentage carried to 2 decimal places. Ex: . 1286 = 12.86% For each ratio for each company, you need to show: 1) the formula 2) the calculation 3) the result For example: Working capital: Current assets - Current liabilities 100 = 21 Evaluating the ability to pay current liabilities 1. Working capital 2. Current ratio 3. Quick ratio (Acid-test ratio) - if the balance sheet does not show short term investments or receivables, use zero. 4. Total Asset Turnover 79 Evaluating the ability to pay long term debt 5. Debt ratio 6. Number of times interest charges earned Evaluating profitability (Show results as a percentage) 7. Profit margin percentage 8. Return on assets 9. Return on equity Evaluating stock as an investment 10. Price-Earnings (P/E) ratio: For P-E ratio, you will need the market price of the stock as of the last day of the fiscal year, which is December 31, 1. Working capital 2. Current ratio 3. Quick ratio (Acid-test ratio) - if the balance sheet does not show short term investments or receivables, use zero. 4. Total Asset Turnover Evaluating the ability to pay long term debt 5. Debt ratio 6. Number of times interest charges earned Evaluating profitability (Show results as a percentage) 7. Profit margin percentage 8. Return on assets 9. Return on equity Evaluating stock as an investment 10. Price-Earnings (P/E) ratio: For P-E ratio, you will need the market price of the stock as of the last day of the fiscal year, which is December 31, 2020 for McDonald's and January 3, 2021 (but use December 31, 2020 as explained above) for Wendy's. To get the market price of stock: go to https://finance.yahoo.com/. In the Search box, enter McDonald's stock symbol (MCD) and Wendy's stock symbol (WEN). On the next screen, click on Historical Data. Change the Time Period to Dec. 28, 2020 - Jan. 5. 2021. Use the the Adj. Close on December 31, 2020 as the market price at the end of the fiscal year for the P-E ratio calculation. See the video links below for a video demonstrating this. 2019 2018 $ 9,420 8 $ 10,012.7 11.6557 11,012.5 287.9 232.7 21,364.4 21.2579 2.880.3 2,7044 2,0759 2.2005 223.8 3,153.8 2,9379 2,1742 1.973.3 186.1 Consolidated Statement of Income in milions excepershare data Years ended December 31, 2020 REVENUES Sales by Company-operated restaurants $ 8,1392 Revenues from franchised restaurants 10,726.1 Other revenues 3425 Total revenues 19,207.8 OPERATING COSTS AND EXPENSES Company operated restaurant expenses Food & paper 2.5642 Payroll & employee benefits 2,416.4 Occupancy & other operating expenses 2.000 6 Franchised restaurants-occupancy expenses 2,207.5 Other restaurant expenses 267.0 Selling, general & administrative expenses Depreciation and amortization 300.6 Other 2.245.0 Other operating (income) expense, net (1175) Total operating costs and expenses 11,883.8 Operating income 7.224.0 Interest expense-net of capitalized interest of $6.0.37.4 and $5.6 1.218.1 Nonoperating income) expense.net (348) Income before provision for income taxes 6.140.7 Provision for income taxes 1.4102 Net income $ 4,730.5 Earnings per common share-basic $ 6.35 Earnings per common share-diluted $ 6.31 Dividends declared per common share $ 5.04 Weighted-average shares outstanding-basic 7446 Weighted average shares outstanding-diluted 7501 See Notes to consolidated Anancial statements 2625 1.966.9 (1198) 12.2946 9,069,8 1.1219 (702) 8,0181 1.9927 $ 6,025.4 5 7.95 $ 7.88 $ 4.73 7581 7649 214.8 1.985.4 (1902) 12.435.3 8.822.6 9812 25.3 7,816.1 1.8918 $ 5,924.3 $ 7.61 $ 7.54 $ 4.19 7782 785.6 38 McDonald's Corporation 20 Amal Report Zatile et THE WENDY'S COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (In Theesaads Except Par Value) January 3 2021 December 29, 2019 ASSETS Current wit Cash and chequivalent Restricted cash Accounts and notes receivable.net Inventories Prepaid expenses and other current acts Advertising funds restricted Total currenties Properties Finance lensesets Operating loncassets Goodwill Other intangibles Investments Net investment in sale-type and direct financing lones Otherwis Total LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Current portion of long-term dete Current portion of fincelemeliabilities Current portion of operating lease lisbilities Accounts payable Accrued expenses and other current liabilities Advertising funds restricted liabilities Total correo lisbilities Long-term dele Long-term fince lease liabilities Long-term operating lease liabilities 306.9895 33.973 109.891 4,732 89,732 142.306 687.623 915.689 206,153 821.450 751,019 1.224.960 46.574 268.221 120.057 5.010.006 300,195 34.539 117.461 3891 15.585 82.376 S52017 977.000 200.144 857.199 755.911 1.247.212 45.949 256.606 100.461 4.994.529 23.962 12.105 45.346 31.063 155.321 110.511 413.30 2.218.163 506.076 865.325 22.750 11.005 0.775 22.701 165.272 84.195 349,698 2257561 480.847 897.737 www 268.221 120.057 5.080,0065 256.606 100.461 4991529 Net investment in sales-type and direct financing louses Other awets Total acts LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Current portion of long-term debe Current portion of finance leme liabilities Current portion of operating losse liabilities Accounts payable Accrued expenses and other current liabilities Advertising funds restricted liabilities Total curent liabilities Long-term dett Long-term finne loneliabilities Long-tem operating lone liabilities Deferred income taxes Deferred franchise fees Other liabilities Total liabilities Commitments and contingencies Stockholders' cquity Common stock, So. 10 per value, 1.500,000 shares authod: 470.424 shares in ied. 224.268 1220589 shares outstanding, respectively Additional puid-in capital Retained earnings Common stock held in treasury, at cont. 246.156 med 285.535 shares, respectively Accumulated other comprehensive loss Total stockholders equity Total liabilities and stockholders' equity See accompanying notes to consolidated facial statements 28.42 12.105 45.346 31,063 155321 140.511 13.308 2.218.163 506.076 865325 280,755 89,094 117.689 4.190.410 11.005 43.775 22.701 165.272 84.195 349.698 2.357.561 480 847 897,737 270,759 91.790 129,778 4.478.170 47.042 2.899.276 L238.674 (2.385,755) (49.641) $19.596 5.010.006 47042 2.874001 185.723 (2.536.381) (53.825 $16.359 499529