Question: I have done this problem several times and I keep getting a different answer when I put it in excel I got 33.33%. When I

I have done this problem several times and I keep getting a different answer when I put it in excel I got 33.33%. When I did it on the calculator I got 6.23% and the answer in the back of the book is 6.4%

Please show and explain in excel. I am totally confused.

A stock costs $90 and pays a $4 annual dividend. If you expect to sell the stock after five years for $100, what is your anticipated return on the investment?

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!