Home Insert Draw Paste & Cut Copy Format 162 Page Layout Formulas Data Review View Automate Tell me Calibri (Body) 12 A A ab v Wrap Text v General B I U v Av Merge & Center $ % 9 fx 1 K Cell Formatting as Table Styles Conditional Format Share Comments AutoSum v v v Fill v Clear v Sort & Filter Find & Select Analyze Datal Insert Delete Format M N 0 Q S V w x Y AB AD AL AG AM Consolidated Statement of tamings (amounts le milions, except per share data) Fiscal Year Ended -do not make any changes to columns ABCDE all your linking & formulas are within this worksheet only (no linking to Company worksheets) FOR PROFORMA Profoma Forecast Feb. 02, 2020 Jan. 31, 2021 7 Net sales Cost of sales 9Gross profit 10 Operating expenses: Depreciation 13 Total operating expenses 14 Total income from operations 110,225 $ 72,653 Jan. 30, 2022 132,110 5 2023 2024 ASSUMPTIONS 151,157 growth 5% increase y hat you Nahere for king % FY:cal year 2021 us growth vs pre-pandemic year- 1.35% WOW! 87,257 use 2022 this item % of sales ratio added 37,572 44,853 50,832 19,740 24,447 25,406 use 2022 this % of ratio 1,989 2,128 2,386 4.00% of sum of Buildings + Fumbure 21,729 26,575 27,792 15,843 18,278 23,040 15 Non-operating income (expense]: 16 Interest expense, net (1.128) (1,300) (1,303) 17 famings before provision for income taxes 14,715 16,978 21,737 18 Provision for income tax 3,473 4.112 5,304 5% of each year T debt, excluding cument portion mated tax rate 25% next three years pretax eanings each years tax rate 15 Net income 11,242 S 12,866 5 16,433 21 22 23 24 The Home Depot, Inc. Consolidated Balance Sheets (amounts in millions, except per share data) 26 27 Assets 28 Cash and cash equivalents 29 Accounts receivable, net 30 Inventories Other cument assets 32 Total cument assets As of Proforma Forecast Jan. 31, 2021 Jan. 30, 2022 2023 2024 2025 7,895 $ 2,343 2,992 3,426 16,627 22,068 963 28,477 29,055 33 Property and equipment, cost 8,543 8,617 35 Buildings and Other 25,139 26,271 36 Fumiture, Fixtures and Equipment 15,119 16,441 37 Less accumulated depreciation (24,096) (26,130) 38 Property and equipment, net 24,705 25,199 39 Intangibles and other assets 17.399 17,622 Total assets 70,581 5 71,876 41 42 Cument liabilities: 43 Accounts payable s 11,606 $ 13,462 44 Other current payables & accrued expenses 8.737 11,635 45 Defend revenue 2,823 3,596 Totalcument liabilities 23,166 28,693 47 LT debt, excluding cument portion 35,822 36,604 48 Other long-term be 8.294 8,275 49 Total liabilities So Stockholders' equity 51 Common stock 67,282 73,572 89 90 52 Paid-in capital 11,540 12,132 53 Retained eamings ADCL 57,463 66,876 54 Treasury stock 65,793) (80,794) 55 Total stockholders' equity 3,299 56 Total abilities and stockholders' equity 70.581 5 (1,696) 71,876 57 59 60 19 62 63 64 66 67 68 69 70 71 72 Ready ASSUMPTIONS your Na here for Inking Plug Cash&C (mm) use 2022 this term % of sales ration use 2022 inventory as % of COGS ratio discuss w/classmates or earleader if do not understand; tutorial if available determining inventory den, of COGS notades other Asume no change Aume no change 1.00% invested annually (growth each yr) PY accum depr'n+CY forecasted den expense u2022 AP % of COGS Assume no change use 2022 the tem% of sales ration 6% decrease per year Assume no change Assume no change Asume no change 30% dividend payout rate on cument year N Assume no change determining accounts payable to invermay - formula roforward of thedeaming Check that A-LE aunting equation doesn't banor, find & your error before being A "fade" only ok Ex A vs LSE variance calculated here; there will be a valance, until you plug the cash using this dance copied $ valance from above row to here using "paste value" to then link Cash to this line be careful of negative, postivell Special Checklist Student Template Company BS Company IS Property and Leases (linking) Cover Page + Accessibility: Investigate 62%