STEP $1$: Create Common Size Financial Statements Formating Guidelines Constants $/$ Value Entries $$100$ Blue Calculations $/$ Formulas $/$ Text Entry $$100$ Black Links from Other Tabs in Workbook $$100$ Green Consolidated Income Statement Consolidated Income Statement Year Ended January $31($in MM USD$)$ Year Ended January $31($in MM USD$)202320222021202320222021$ Revenues Revenues Sales by Company$-$operated restaurants $$9,741\mathrm{.}6$ $$8,748\mathrm{.}4$ $$9,787\mathrm{.}4$ Sales by Company$-$operated restaurants Revenues from franchised restaurants $15,436\mathrm{.}514,105\mathrm{.}813,085\mathrm{.}4$ Revenues from franchised restaurants Other revenues $315\mathrm{.}6328\mathrm{.}4350\mathrm{.}1$ Other revenues Total revenues $$25,493\mathrm{.}7$ $$23,182\mathrm{.}6$ $$23,222\mathrm{.}9$ Total revenues Company$-$operated restaurant expenses Company$-$operated restaurant expenses Food & paper $$3,039\mathrm{.}0$ $$2,737\mathrm{.}3$ $$3,096\mathrm{.}8$ Food & paper Payroll & employee benefits $2,885\mathrm{.}82,617\mathrm{.}42,677\mathrm{.}2$ Payroll & employee benefits Occupancy & other operating expenses $2,299\mathrm{.}32,026\mathrm{.}22,273\mathrm{.}3$ Occupancy & other operating expenses Franchised restaurants$-$occupancy expenses $2,474\mathrm{.}62,349\mathrm{.}72,335\mathrm{.}0$ Franchised restaurants$-$occupancy expenses Other restaurant expenses $232\mathrm{.}5244\mathrm{.}8260\mathrm{.}4$ Other restaurant expenses Selling, general & administrative expenses $---$ Selling, general & administrative expenses Depreciation and amortization $381\mathrm{.}7370\mathrm{.}4329\mathrm{.}7$ Depreciation and amortization Other $2,435\mathrm{.}22,492\mathrm{.}22,377\mathrm{.}8$ Other Total $$13,748\mathrm{.}1$ $$12,838\mathrm{.}0$ $$13,350\mathrm{.}2$ Total Other operating $($income$)$ expense, net $98\mathrm{.}9973\mathrm{.}6(483\mathrm{.}3)$ Other operating $($income$)$ expense, net Total operating costs and expenses $$13,847\mathrm{.}0$ $$13,811\mathrm{.}6$ $$12,866\mathrm{.}9$ Total operating costs and expenses Operating income $$11,646\mathrm{.}7$ $$9,371\mathrm{.}0$ $$10,356\mathrm{.}0$ Operating income Interest expense$-$net of capitalized interest $1,360\mathrm{.}81,207\mathrm{.}01,185\mathrm{.}8$ Interest expense$-$net of capitalized interest Nonoperating $($income$)$ expense, net $(236\mathrm{.}3)338\mathrm{.}642\mathrm{.}3$ Nonoperating $($income$)$ expense, net Income before provision for income taxes $$10,522\mathrm{.}2$ $$7,825\mathrm{.}4$ $$9,127\mathrm{.}9$ Income before provision for income taxes Provision for income taxes $2,053\mathrm{.}41,648\mathrm{.}01,582\mathrm{.}7$ Provision for income taxes Net income $$8,468\mathrm{.}8$ $$6,177\mathrm{.}4$ $$7,545\mathrm{.}2$ Net income Consolidated Balance Sheet Consolidated Balance Sheet Year Ended January $31($in MM USD$)$ Year Ended January $31($in MM USD$)$ ASSETS $202320222021$ ASSETS $202320222021$ Current assets Current assets Cash and equivalents $$4,579\mathrm{.}3$ $$2,583\mathrm{.}8$ $$4,709\mathrm{.}2$ Cash and equivalents Accounts and notes receivable $2,488\mathrm{.}02,115\mathrm{.}01,872\mathrm{.}4$ Accounts and notes receivable Inventories, at cost$,$ not in excess of market $52\mathrm{.}852\mathrm{.}055\mathrm{.}6$ Inventories, at cost$,$ not in excess of market Prepaid expenses and other current assets $866\mathrm{.}3673\mathrm{.}4511\mathrm{.}3$ Prepaid expenses and other current assets Total current assets $$7,986\mathrm{.}4$ $$5,424\mathrm{.}2$ $$7,148\mathrm{.}5$ Total current assets Investments in and advances to affiliates $$1,080\mathrm{.}2$ $$1,064\mathrm{.}5$ $$1,201\mathrm{.}2$ Investments in and advances to affiliates Goodwill $3,040\mathrm{.}42,900\mathrm{.}42,782\mathrm{.}5$ Goodwill Miscellaneous $5,617\mathrm{.}84,707\mathrm{.}24,449\mathrm{.}5$ Miscellaneous Total other assets $$9,738\mathrm{.}4$ $$8,672\mathrm{.}1$ $$8,433\mathrm{.}2$ Total other assets Lease right$-$of$-$use asset, net $$13,514\mathrm{.}4$ $$12,565\mathrm{.}7$ $$13,552\mathrm{.}0$ Lease right$-$of$-$use asset, net Property and equipment Property and equipment Property and equipment, at cost $$43,570\mathrm{.}0$ $$41,037\mathrm{.}6$ $$41,916\mathrm{.}6$ Property and equipment, at cost Accumulated depreciation and amortization $(18,662\mathrm{.}4)(17,264\mathrm{.}0)(17,196\mathrm{.}0)$ Accumulated depreciation and amortization Net property and equipment $$24,907\mathrm{.}6$ $$23,773\mathrm{.}6$ $$24,720\mathrm{.}6$ Net property and equipment Total assets $$56,146\mathrm{.}8$ $$50,435\mathrm{.}6$ $$53,854\mathrm{.}3$ Total assets