This is Home Depot's Balance sheet with $ change and % change over thenpast 3 years. I need a projected balance sheet for the years 2024-2026. I will also need an assumption of why you think the projection will be what it is. Please I really need help.

Transcribed Image Text:

Home Depot Corporation Horizontal Analysis of Balance As of January 31, 2021, January 30, 2022, and January 29, 2023 $s in millions Jan. 29, 2023 $ change % change Jan. 30, 2022 $ change % change Jan. 31, 2021 Assets Current assets: 3 Cash and cash equivalents $ 9 Receivables, net 0 Merchandise inventories 2,757 $ 414 3,317 $ (109) 24,886 $ 2,818 17.67% $ 2,343 $ (5,552) -70.32% $ 7,895 -3.18% 3,426 $ 434 14.51% 2,992 12.77% 22,068 $ 5,441 32.72% 16,627 1 Other current assets 2 Total current assets 1,511 $ 32,471 $ 3,416 293 24.06% 1,218 $ 255 26.48% 963 11.76% 29,055 $ 578 2.03% 28,477 3 Net property and equipme 4 Operating lease right-of-us 25,631 $ 432 1.71% 25,199 $ 494 2.00% 24,705 6,941 $ 973 16.30% 5,968 $ 6 0.10% 5,962 5 Goodwill 7,444 $ (5) -0.07% 7,449 $ 323 4.53% 7,126 6 Other assets 3,958 $ (247) -5.87% 4,205 $ (106) -2.46% 4,311 7 Total assets $ 76,445 $ 4,569 6.36% $ 71,876 $ 1,295 1.83% $ 70,581 18 ilities and Stockholders' Eq 19 20 Current liabilities: Short-term debt $ 21 Accounts payable 11,443 $ (1,035.00) $(2,019.00) -100.00% $ 1,035 $ 1,035 -15.00% 13,462 $ 1,856 15.99% 11,606 22 ed salaries and related expi 1,991 $ (435.00) -17.93% 2,426 $ (37) -1.50% 2,463 23 Sales taxs payable 528 $ (320.00) -37.74% 848 $ 74 9.56% 774 24 Deferred revenue 3,064 $ (532.00) -14.79% 3,596 $ 773 27.38% 2,823 25 Income taxes payable 26 Current installments of lon 27 rrent operating lease liabilit 28 Other accrued expenses 29 Total current liabilities 30 debt, excluding current in 31 g-term operating lease liabi 32 Deferred income taxes 33 Other long-term liabilities 50 $ (108.00) -68.35% 158 $ (35) -18.13% 193 1,231 $(1,216.00) -49.69% 2,447 $ 1,031 72.81% 1,416 945 $ 115.00 3,858 $ (33.00) 23,110 $(5,583.00) 41,962 $5,358.00 6,226 $ 13.86% 830 $ 2 0.24% 828 -0.85% 3,891 $ 828 27.03% 3,063 -19.46% 28,693 $ 5,527 23.86% 23,166 14.64% 36,604 $ 782 2.18% 35,822 873.00 16.31% 5,353 $ (3) -0.06% 5,356 1,019 $ 110.00 12.10% 909 $ (222) -19.63% 1,131 2,566 $ 553.00 27.47% 2,013 $ 34 Total liabilities 35 36 Common stock 37 Paid-in capital 38 Retained earnings 74,883 $1,311.00 1.78% 73,572 $ 206 6,290 11.40% 1,807 9.35% 67,282 90 $ 0.00% 12,592 $460.00 3.79% 90 $ 12,132 $ 1 1.12% 89 592 5.13% 11,540 76,896 $9,316.00 13.79% 67,580 $ 9,446 16.25% 58,134 39 hulated other comprehensiv $ 40 Treasury Stock 41 al stockholders' (deficit) eq $ 42 iabilities and stockholders' $ 43 $ (718) $ (14.00) (87,298) $(6,504.00). 1,562 $3,258.00 76,445 $4,569.00 1.99% $ 8.05% $ -192.10% $ 6.36% $ (704) $ (80,794) $ (15,001) (33) 4.92% $ (671) 22.80% $ (65,793) (1,696) $ 71,876 $ (4,995) 1,295 -151.41% 3,299 1.83% $ 70,581 Home Depot Corporation Horizontal Analysis of Balance As of January 31, 2021, January 30, 2022, and January 29, 2023 $s in millions Jan. 29, 2023 $ change % change Jan. 30, 2022 $ change % change Jan. 31, 2021 Assets Current assets: 3 Cash and cash equivalents $ 9 Receivables, net 0 Merchandise inventories 2,757 $ 414 3,317 $ (109) 24,886 $ 2,818 17.67% $ 2,343 $ (5,552) -70.32% $ 7,895 -3.18% 3,426 $ 434 14.51% 2,992 12.77% 22,068 $ 5,441 32.72% 16,627 1 Other current assets 2 Total current assets 1,511 $ 32,471 $ 3,416 293 24.06% 1,218 $ 255 26.48% 963 11.76% 29,055 $ 578 2.03% 28,477 3 Net property and equipme 4 Operating lease right-of-us 25,631 $ 432 1.71% 25,199 $ 494 2.00% 24,705 6,941 $ 973 16.30% 5,968 $ 6 0.10% 5,962 5 Goodwill 7,444 $ (5) -0.07% 7,449 $ 323 4.53% 7,126 6 Other assets 3,958 $ (247) -5.87% 4,205 $ (106) -2.46% 4,311 7 Total assets $ 76,445 $ 4,569 6.36% $ 71,876 $ 1,295 1.83% $ 70,581 18 ilities and Stockholders' Eq 19 20 Current liabilities: Short-term debt $ 21 Accounts payable 11,443 $ (1,035.00) $(2,019.00) -100.00% $ 1,035 $ 1,035 -15.00% 13,462 $ 1,856 15.99% 11,606 22 ed salaries and related expi 1,991 $ (435.00) -17.93% 2,426 $ (37) -1.50% 2,463 23 Sales taxs payable 528 $ (320.00) -37.74% 848 $ 74 9.56% 774 24 Deferred revenue 3,064 $ (532.00) -14.79% 3,596 $ 773 27.38% 2,823 25 Income taxes payable 26 Current installments of lon 27 rrent operating lease liabilit 28 Other accrued expenses 29 Total current liabilities 30 debt, excluding current in 31 g-term operating lease liabi 32 Deferred income taxes 33 Other long-term liabilities 50 $ (108.00) -68.35% 158 $ (35) -18.13% 193 1,231 $(1,216.00) -49.69% 2,447 $ 1,031 72.81% 1,416 945 $ 115.00 3,858 $ (33.00) 23,110 $(5,583.00) 41,962 $5,358.00 6,226 $ 13.86% 830 $ 2 0.24% 828 -0.85% 3,891 $ 828 27.03% 3,063 -19.46% 28,693 $ 5,527 23.86% 23,166 14.64% 36,604 $ 782 2.18% 35,822 873.00 16.31% 5,353 $ (3) -0.06% 5,356 1,019 $ 110.00 12.10% 909 $ (222) -19.63% 1,131 2,566 $ 553.00 27.47% 2,013 $ 34 Total liabilities 35 36 Common stock 37 Paid-in capital 38 Retained earnings 74,883 $1,311.00 1.78% 73,572 $ 206 6,290 11.40% 1,807 9.35% 67,282 90 $ 0.00% 12,592 $460.00 3.79% 90 $ 12,132 $ 1 1.12% 89 592 5.13% 11,540 76,896 $9,316.00 13.79% 67,580 $ 9,446 16.25% 58,134 39 hulated other comprehensiv $ 40 Treasury Stock 41 al stockholders' (deficit) eq $ 42 iabilities and stockholders' $ 43 $ (718) $ (14.00) (87,298) $(6,504.00). 1,562 $3,258.00 76,445 $4,569.00 1.99% $ 8.05% $ -192.10% $ 6.36% $ (704) $ (80,794) $ (15,001) (33) 4.92% $ (671) 22.80% $ (65,793) (1,696) $ 71,876 $ (4,995) 1,295 -151.41% 3,299 1.83% $ 70,581