PLEASE WRITE THE FORMULAS. THANK YOU

1 2 3 4 5 66 67 In Equity Valuation (Workbook 11), we will introduce the concept of valuing a stock as the Net Present Value (NPV) of future cash flows (Discunted Cash Flows or DCF). 68 An Equity Analyst (a Financial Analyst that focuses on valuing stocks) needs to value the stock of a company. 69 The company has recently gone through a period of financial stress and does not plan to pay a dividend this or next year. 70 The company has stated its intent of reintroducing a dividend of $2.00 in 2024 and increasing the dividend by 5% every year thereafter. 71 In the yellow cells below write formulas to calculate the expected dividend in each year. 72 73 0 (Current) 74 2022 2025 2026 Terminal Value 75 Dividend/Share $ $ 76 77 The Equity Analyst has selected to apply a 10% discount rate in today's market conditions. 78 In Cell 175 write a formula that calculates the terminal value using the discount rate selected. 79 80 In the yellow cell below write a formula that calculates the Net Present Value (NPV) of the dividend stream modeled in Row 75. 81 2023 2024 82