Perform a financial statement analysis for Home Depot, starting with base year 2021, and forecast for 2022,2023,2024 and 2025(Horizon period). From Home depots 2021 10k shows sales of 151,157, what is the amount of operating income, income before taxes, taxes, tax rate, total assets, cash, investments, total operating assets, total liabilities, total non-operating liabilities, WACC (r(w), growth rate, terminal growth rate, shareholder equity, shares outstanding, current share price.

With all of this information stated above, calculate sales amount for 2022,2023,2024 and 2025(horizon period), calculate NOPAT and NOA for all years, increase in NOA, calculate FCF for all years in horizon period, and terminal period. What is the discount factor each year, what is the PV of Horizon forecast for each year.

Input the correct amounts in each of the items below.

Sales-

NOPAT-

NOA-

Increase in NOA-

FCF-

Discount Factor - r(w)-

PV of Horizon Forecast-

Cumulative PV of Horizon FCF

PV of Terminal FCF

Total Firm Value

Less (plus): NNO

Less: NCI

Firm Equity Value

Shares Outstanding

Stock Value Per Share

Current Price

Investment Conclusion