Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

The following graph shows the value of a stock's dividends over time

Finance Jan 09, 2021

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.

Expert Solution

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

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment