Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / The following graph shows the value of a stock's dividends over time
The following graph shows the value of a stock's dividends over time. The stock's current dividend is $1.00 per share, and dividends are expected to grow at a constant rate of 3.50% per year. The intrinsic value of a stock should equal the sum of the present value (PV) of all of the dividends that a stock is supposed to pay in the future, but many people find it difficult to imagine adding up an infinite number of dividends. Calculate the present value (PV) of the dividend paid today (Do) and the discounted value of the dividends expected to be paid 10 and 20 years from now (D10 and D20). Assume that the stock's required return (rs) is 10.40%. Note: Carry and round the calculations to four decimal places Time Period Dividend's Expected Expected Dividend's Future Value Present Value NOW End of Year 10 End of Year 20 End of Year 50 Using the orange curve (square symbols), plot the present value of each of the expected future dividends for years 10, 20, and 50. The resulting curve will illustrate how the PV of a particular dividend payment will decrease depending on how far from today the dividend is expected to be received. Note: Round each of the discounted values of the of dividends to the nearest tenth decimal place before plotting it on the graph. You can mouse over the points in the graph to see their coordinates.
Now:
Expected dividend's present value = 1 (Given)
End of 10 years
Dividend's expected future value:
R = 0.035
N = 10
PV = 1
Using excel function, FV = FV(0.035,10,,-1,0) = 1.4106
Expected dividend's present value:
R = 0.104
FV = -1.4106 (calculated above)
Using excel funtion: PV(0.104,10,,-1.4106,0) = 0.5245
Similarly for :
End of 20 years:
Dividend's expected future value:
FV(0.035,20,,-1,0) = 1.9898
Expected dividend's present value:
PV(0.104,20,,-1.9898,0) = 0.2751
End of 50 years:
Dividend's expected future value:
FV(0.035,50,,-1,0) = 5.5849
Expected dividend's present value:
PV(0.104,50,,-5.5849,0) = 0.0397
please see the attached file for complete solution
