answer using excel formulas please

wendys 10k forms

mcdonalds 10k forms

4. Total Asset Turnover Evaluating the ability to pay long term debt 5. Debt ratio 6. Number of times interest charges earned THE WENDY'S COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS da Therads Except Par Valur January 3, 2021 December 29 2019 ASSETS Current Chachoquivalen Restricted cash Accounts and notes receivable, Ini quid pemesand other current met Advertising is restricted Total Properties Finnoce lone Operating net Goodwill Otherwiec laveste Net leven in de type of direct fininger Otherwis Tools LIABILITIES AND STOCKHOLDERS' EQUITY Ce biti Corticoterm det Crow portion of financemebities Current porties of operating loneliabilities Accapable Acered expense oother creates Atvertising and restricted liabilities Total current istilities Latest | Leten finne lewe bibites Le tem operating sites 3069895 31.973 109.891 4732 9.732 143.306 687623 915.689 206.199 1480 751019 1.224.60 45 264.221 120.057 5.080.00 300.195 14.519 117461 19 ISSSS 82.176 550019 977.000 200144 $$7.199 754911 1.247.212 15.99 24606 100.461 39 38.633 12.105 45.366 31.053 155321 140 SIT 413.BOR 2.212.163 S06.076 MS335 22.750 11.00 0.775 22.701 165.272 4195 2257561 30.549 197.737 36.221 120.057 5.040.0053 256.606 100.461 994539 32.750 11.00 11.775 22.01 165.272 54.195 Net investment in ale-type and direct finncing los Otherwis Total LIABILITIES AND STOCKHOLDERS' EQUITY Cerco liblities Carent portion of term dete Current portice office leme bites Current portion of operating Senelisbilities Accounts payable Accredepeesother reabilities Advertising funds restricted liabilities Taalara titans | Long term dete Latem fcelemele Looptem operating lonelines Defence Deferred franchise fees Other listes Totalbes Commitment Stockholdersity Com ock. 50 10 prva: 1.500.000 wes wat 470,03 we niet 220 d 239 directing, respectively Aditional paid in capital Retinoling Como tockich i wy, ut cost: 246.156 and 205.535 des respectively Accumulated other comprehmive low Total stockholders uity Total liabilities and stockholders alty See accompanying notes to colidated ficial sites 12.105 15346 31.063 155021 140511 13:08 2.216.163 S06.06 365325 280.755 $9.09 11769 2257.561 1049 897.737 270.799 91.90 170 4700 2.899.276 23674 2.585.755) 47.000 2874001 185.725 225581) (1135 516159 4.994539 509596 5.080.0063 Consolidated Statement of income role Years ended December 31, 2020 2019 2018 REVENUES Sales by Company-operated restaurants $ 8,132 $ 9.4208 $10,0127 Revenues from franchised restaurants 10.7261 116557 11.0125 Other revenues 3425 2879 232.7 Total revenues 21.3644 21.2579 OPERATING COSTS AND EXPENSES Company-operated restaurant expenses Food & paper 25642 2.5803 1538 Payroll & employee benefits 2.116.4 27044 2.9379 Occupancy & other operating expenses 2.000 6 20759 2.1742 Franchised restaurants occupancy expenses 2.2015 2.2006 1.9733 Other restaurant expenses 2670 Selling general & administrative expenses Depreciation and amortization 3006 2525 2148 Other 1.966.9 1985.4 Other operating income) expense, net (1198) (1902) Total operating costs and expenses 12.2946 12.4353 Operating income 7240 9.0993 8.2226 Interest expense-net of capitalized interest of $6.0.37 A and $5.6 1.2161 1.1219 1812 Nonoperating income) expense.net 545 702 253 Income before provision for income taxes 1407 8.018.1 7.816.1 Provision for income taxes 1.4102 19927 1.8913 Net Income 5 70 556.0254 $5.8243 Earnings per common share-basic $ 5.355 7.85 $ 761 Earnings per common share-diluted 5 631 $ 7385 754 Dividends declared per common share 5 5.04 5 4.73 $ 4.19 Weighted average shares outstanding-basic TS 7581 7782 Weighted-average shares outstanding-diluted 2501 7549 7856 58 Michel wat Consolidated Statement of Income mos e per here te Years ended December 31, 2020 2019 2018 REVENUES Sales by Company operated restaurants $ 8.1392 $9.4208 $ 10,012.7 Revenues from franchised restaurants 10.7261 11.6557 11.0125 Other revenues 3425 2879 2327 Total revenues 19. 2073 21.3644 21.2579 OPERATING COSTS AND EXPENSES Company operated restaurant expenses Food & paper 2.5642 2.5803 3.153.8 Payroll & employee benefits 2.416.4 2.7044 2.9379 Occupancy & other operating expenses 2.000 6 2.0759 2.1742 Franchised restaurants occupancy expenses 2.2075 2.2006 1.9733 Other restaurant expenses 2570 2238 185.1 Selling general & administrative expenses Depreciation and amortization 300.5 2525 2148 Other 2.245.0 1.966.9 1.985.4 Other operating income) expense.net (1175 (1198) (1902) Total operating costs and expenses 11 382 12.2946 124353 Operating income 7.1240 9.060,8 8.822.6 Interest expensent of capitated interest of $6.0 $7A and 55-6 1.2181 1.1219 9012 Nonoperating income) expense.net 345 (702) 253 Income before provision for income taxes 6.1407 8.018.1 7.816.1 Provision for income taxes 1.4102 1.9927 1.8918 Net Income 54.7305 $ 6.025.4 S59243 Earnings per common share-basic 5 6355 $ 761 Earnings per common share-diluted $ 6.31 $ 780 $ 7.54 Dividends declared per common share s 5.045 473 5 419 Weighted average shares outstanding-basic 744 7581 7782 Weighted average shares outstanding-diluted 7501 754 7856 See Neendede francais 795 > Meer