Create a Pro Forma Balance Sheet that forecast for the upcoming period. The chosen method for the pro forma analysis will employ the percentage of sales method.

Fiscal Year End for The Home Depot, Inc falls in the month of January. All items in Millions except Per Share data. \begin{tabular}{lrrrrr} \hline Mortgages & 0 & 0 & 0 & 0 & 0 \\ \hline Deferred Taxes/lncome & 1,019 & 909 & 1,131 & 706 & 491 \\ \hline Convertible Debt & 0 & 0 & 0 & 0 & 0 \\ \hline Long-Term Debt & 41,962 & 36,604 & 35,822 & 28,670 & 26,807 \\ \hline Non-Current Capital Leases & 0 & 0 & 0 & 0 & 0 \\ \hline Other Non-Current Liabilities & 2,566 & 2,013 & 1,807 & 1,535 & 1,867 \\ \hline Minority Interest (Liabilities) & 0 & 0 & 0 & 0 & 0 \\ \hline Total Liabilities & 74,883 & 73,572 & 67,282 & 54,352 & 45,881 \\ \hline Shareholders Equity & 1/31/2023 & 1/31/2022 & 1/31/2021 & 1/31/2020 & 1/31/2019 \\ \hline Preferred Stock & 0 & 0 & 0 & 0 & 0 \\ \hline Common Stock (Par) & 90 & 90 & 89 & 89 & 89 \\ \hline Capital Surplus & 12,592 & 12,132 & 11,540 & 11,001 & 10,578 \\ \hline Retained Earnings & 76,896 & 67,580 & 58,134 & 51,729 & 46,423 \\ \hline Other Equity & -718 & -704 & -671 & -739 & -772 \\ \hline Treasury Stock & 87,298 & 80,794 & 65,793 & 65,196 & 58,196 \\ \hline Total Shareholder's Equity & 1,562 & 1,696 & 3,299 & 3,116 & 1,878 \\ \hline Total Liabilities \& Shareholder's Equity & 76,445 & 71,876 & 70,581 & 51,236 & 44,003 \\ \hline Total Common Equity & 1,562 & 1,696 & 3,299 & 3,116 & 1,878 \\ \hline Shares Outstanding & 1,023.70 & 1,044.20 & 1,076.60 & 1,090.80 & 1,129.50 \\ \hline Book Value Per Share & 1.53 & -1.62 & 3.06 & -2.86 & -1.66 \\ \hline \end{tabular} Fiscal Year End for The Home Depot, Inc falls in the month of January. All items in Millions except Per Share data. \begin{tabular}{lrrrrr} \hline Mortgages & 0 & 0 & 0 & 0 & 0 \\ \hline Deferred Taxes/lncome & 1,019 & 909 & 1,131 & 706 & 491 \\ \hline Convertible Debt & 0 & 0 & 0 & 0 & 0 \\ \hline Long-Term Debt & 41,962 & 36,604 & 35,822 & 28,670 & 26,807 \\ \hline Non-Current Capital Leases & 0 & 0 & 0 & 0 & 0 \\ \hline Other Non-Current Liabilities & 2,566 & 2,013 & 1,807 & 1,535 & 1,867 \\ \hline Minority Interest (Liabilities) & 0 & 0 & 0 & 0 & 0 \\ \hline Total Liabilities & 74,883 & 73,572 & 67,282 & 54,352 & 45,881 \\ \hline Shareholders Equity & 1/31/2023 & 1/31/2022 & 1/31/2021 & 1/31/2020 & 1/31/2019 \\ \hline Preferred Stock & 0 & 0 & 0 & 0 & 0 \\ \hline Common Stock (Par) & 90 & 90 & 89 & 89 & 89 \\ \hline Capital Surplus & 12,592 & 12,132 & 11,540 & 11,001 & 10,578 \\ \hline Retained Earnings & 76,896 & 67,580 & 58,134 & 51,729 & 46,423 \\ \hline Other Equity & -718 & -704 & -671 & -739 & -772 \\ \hline Treasury Stock & 87,298 & 80,794 & 65,793 & 65,196 & 58,196 \\ \hline Total Shareholder's Equity & 1,562 & 1,696 & 3,299 & 3,116 & 1,878 \\ \hline Total Liabilities \& Shareholder's Equity & 76,445 & 71,876 & 70,581 & 51,236 & 44,003 \\ \hline Total Common Equity & 1,562 & 1,696 & 3,299 & 3,116 & 1,878 \\ \hline Shares Outstanding & 1,023.70 & 1,044.20 & 1,076.60 & 1,090.80 & 1,129.50 \\ \hline Book Value Per Share & 1.53 & -1.62 & 3.06 & -2.86 & -1.66 \\ \hline \end{tabular}