answer using fomulas in excel

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, Consolidated Statement of Income In millions, except per share data Years ended December 31, 2020 2019 2018 REVENUES Sales by Company-operated restaurants $ 8,139.2 $ 9.420.8 $ 10,012.7 Revenues from franchised restaurants 10,726.1 11,655.7 11.012,5 Other revenues 3425 2879 232.7 Total revenues 19,207.8 21,364.4 21.257,9 OPERATING COSTS AND EXPENSES Company-operated restaurant expenses Food & paper 2.564.2 2.980.3 3.153.8 Payroll & employee benefits 2,416.4 2,704.4 2,9379 Occupancy & other operating expenses 2,000.6 2.075.9 2,1742 Franchised restaurants-occupancy expenses 2,207.5 2,200.6 1.973.3 Other restaurant expenses 267.0 223.8 186.1 Selling general & administrative expenses Depreciation and amortization 300.6 2625 214.8 Other 2.245.0 1.966.9 1.985.4 Other operating (income) expense, net (117.5) (119.8) (1902) Total operating costs and expenses 11,883.8 12.294.6 12,435.3 Operating income 7.324.0 9,069.8 8.8226 Interest expense-net of capitalized interest of $6.0, $7 4 and 55.6 1.218 1.121.9 9812 Nonoperating (income) expense, net (34.6) (702) 25.3 Income before provision for income taxes 6.140.7 8,018.1 7.816.1 Provision for income taxes 1.410.2 1,9927 1.891.8 Net income $ 4.730.5 $ 6,025.4 $ 5,924.3 Earnings per common share-basic $ 6.35 $ 7.95 S 7.61 Earnings per common share-diluted $ 6.31 $ 7.88 $ 7.54 Dividends declared per common share $ 5.04 $ 4.73 $ 4.19 Weighted average shares outstanding-basic 744.6 758.1 7782 Weighted average shares outstanding-diluted 750.1 764.9 785.6 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 Tables Content THE WENDY'S COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (la Thousands Except Par Value) January 3 2021 December 29, 2019 ASSETS Current aviets Cash ad canh equivalents Restricted cash Accounts and notes receivable.net Inventories Prepaid expenses and other current acts Advertising funds restricted as Total currentes Properties Finance lease viet Operating lenses Goodwill Other integibles lavestments Net investment in sales-type and direct financing les Other its Total LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Crent portion of long-term dete Current portion of fine lease libilities Current portion of operating lease liabilities Accounts payable Accrued expenses and other current liabilities Advertising funds restricted liabilities Total current liabilities Long-term debe Long-term fince lease liabilities Long-tem operating lease liabilities 306.9895 33.973 109,891 4,732 89,732 143.306 687.623 915.889 206,153 821.450 751,019 1.224.960 44.574 268.221 120.057 5010,006 300,195 34.539 117.461 3891 15.885 82.376 S50017 977.000 200.144 857.199 755.911 1.247.212 45.919 256.606 100.461 4.994529 12.105 45,346 31,063 155.321 110.511 413.08 2218.163 506.076 865.325 22.750 11.005 0.775 22.701 165.272 84.195 349.698 2.257561 40.847 897.737 990 www 268.221 120.057 5.040,0065 256.606 100.461 1.991.529 Net iuvestment in sales-type and direct financing leases Other its Total acts LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Current portion of long-term det Current portion of finance leme liabilities Current portion of operating lone libilities Accounts payable Accred expenses and other current liabilities Advertising funds restricted liabilities Total curent liabilities Long-term debe Long-term firme le liabilities Long-term operating leme lisbilities Deferred income taxes Deferred franchise fees Other liabilities Total liabilities Commitments and contingencies Stockholders' cquity Common stock, 30. 10 per value. 1.500,000 Mures matbord 470.424 dhe sid. 224.268 1224589 shares outstanding, respectively Additional puid-in capital Retained ning Common stock held in treasury, at cost: 246.156 and 245.535 slawes, respectively Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity See accompanying notes to consolidated financial statements 28.923 12.105 45.346 31.063 155321 140.511 413308 2.218.163 506.076 865325 280.755 89,094 117.689 4.190.410 22.750 11.005 43.775 22.701 165 272 84.195 349.698 2.357.561 480 847 897.737 270.799 91.790 129,778 4.478.170 47012 2.899.276 $236.674 (2.383.755) (49.641) $19.596 5.080,006 47042 2.874001 185.725 (2.596.581) (53828 $16.359 4994529 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, Consolidated Statement of Income In millions, except per share data Years ended December 31, 2020 2019 2018 REVENUES Sales by Company-operated restaurants $ 8,139.2 $ 9.420.8 $ 10,012.7 Revenues from franchised restaurants 10,726.1 11,655.7 11.012,5 Other revenues 3425 2879 232.7 Total revenues 19,207.8 21,364.4 21.257,9 OPERATING COSTS AND EXPENSES Company-operated restaurant expenses Food & paper 2.564.2 2.980.3 3.153.8 Payroll & employee benefits 2,416.4 2,704.4 2,9379 Occupancy & other operating expenses 2,000.6 2.075.9 2,1742 Franchised restaurants-occupancy expenses 2,207.5 2,200.6 1.973.3 Other restaurant expenses 267.0 223.8 186.1 Selling general & administrative expenses Depreciation and amortization 300.6 2625 214.8 Other 2.245.0 1.966.9 1.985.4 Other operating (income) expense, net (117.5) (119.8) (1902) Total operating costs and expenses 11,883.8 12.294.6 12,435.3 Operating income 7.324.0 9,069.8 8.8226 Interest expense-net of capitalized interest of $6.0, $7 4 and 55.6 1.218 1.121.9 9812 Nonoperating (income) expense, net (34.6) (702) 25.3 Income before provision for income taxes 6.140.7 8,018.1 7.816.1 Provision for income taxes 1.410.2 1,9927 1.891.8 Net income $ 4.730.5 $ 6,025.4 $ 5,924.3 Earnings per common share-basic $ 6.35 $ 7.95 S 7.61 Earnings per common share-diluted $ 6.31 $ 7.88 $ 7.54 Dividends declared per common share $ 5.04 $ 4.73 $ 4.19 Weighted average shares outstanding-basic 744.6 758.1 7782 Weighted average shares outstanding-diluted 750.1 764.9 785.6 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 Tables Content THE WENDY'S COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (la Thousands Except Par Value) January 3 2021 December 29, 2019 ASSETS Current aviets Cash ad canh equivalents Restricted cash Accounts and notes receivable.net Inventories Prepaid expenses and other current acts Advertising funds restricted as Total currentes Properties Finance lease viet Operating lenses Goodwill Other integibles lavestments Net investment in sales-type and direct financing les Other its Total LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Crent portion of long-term dete Current portion of fine lease libilities Current portion of operating lease liabilities Accounts payable Accrued expenses and other current liabilities Advertising funds restricted liabilities Total current liabilities Long-term debe Long-term fince lease liabilities Long-tem operating lease liabilities 306.9895 33.973 109,891 4,732 89,732 143.306 687.623 915.889 206,153 821.450 751,019 1.224.960 44.574 268.221 120.057 5010,006 300,195 34.539 117.461 3891 15.885 82.376 S50017 977.000 200.144 857.199 755.911 1.247.212 45.919 256.606 100.461 4.994529 12.105 45,346 31,063 155.321 110.511 413.08 2218.163 506.076 865.325 22.750 11.005 0.775 22.701 165.272 84.195 349.698 2.257561 40.847 897.737 990 www 268.221 120.057 5.040,0065 256.606 100.461 1.991.529 Net iuvestment in sales-type and direct financing leases Other its Total acts LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Current portion of long-term det Current portion of finance leme liabilities Current portion of operating lone libilities Accounts payable Accred expenses and other current liabilities Advertising funds restricted liabilities Total curent liabilities Long-term debe Long-term firme le liabilities Long-term operating leme lisbilities Deferred income taxes Deferred franchise fees Other liabilities Total liabilities Commitments and contingencies Stockholders' cquity Common stock, 30. 10 per value. 1.500,000 Mures matbord 470.424 dhe sid. 224.268 1224589 shares outstanding, respectively Additional puid-in capital Retained ning Common stock held in treasury, at cost: 246.156 and 245.535 slawes, respectively Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity See accompanying notes to consolidated financial statements 28.923 12.105 45.346 31.063 155321 140.511 413308 2.218.163 506.076 865325 280.755 89,094 117.689 4.190.410 22.750 11.005 43.775 22.701 165 272 84.195 349.698 2.357.561 480 847 897.737 270.799 91.790 129,778 4.478.170 47012 2.899.276 $236.674 (2.383.755) (49.641) $19.596 5.080,006 47042 2.874001 185.725 (2.596.581) (53828 $16.359 4994529