Question: pls explain the formulas: 103 An Equity Analyst (a Financial Analyst that focuses on valuing stocks) needs to value the stock of a company. 104

 pls explain the formulas: 103 An Equity Analyst (a Financial Analystthat focuses on valuing stocks) needs to value the stock of a

pls explain the formulas:

company. 104 The company has recently gone through a period of nancialstress and does not plan to pay a dividend this or next

103 An Equity Analyst (a Financial Analyst that focuses on valuing stocks) needs to value the stock of a company. 104 The company has recently gone through a period of nancial stress and does not plan to pay a dividend this or next year. 105 The company has stated its intent of reintroducing a dividend of $2.00 in 2022 and increasing the dividend by 5% every year thereafter. 106 In the yellow cells below write formulas to calculate the expected dividend in each year. 107 108 2020 2021 2022 2023 2024 Terminal 109 Dividend/Share s - s -l:|:|:l:| 110 111 The Equity Analyst has selected to apply a 10% discount rate in today's market conditions. 112 In Cell 6109 write a formula that calculates the terminal value using the discount rate selected. 1 13 114 In the yellow cell below write a formula that calculates the Net Present Value (NPV) of the dividend stream modeled in Row 109. 115 l .I 11'? 373 374 Property, Plant & Equipment Derivation 375 Calculate the values of the yellow cells below. 37g 371 37g 372 382 381 383 325 384 383 3875 387 38?; 325 396

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!