Assum company $xYZ$ just paid a dividend of $$3\mathrm{.}00$ per share and is expected to continue paying the same amount each year for the next $5$ years. If you have a required rate of return of $12\%,$ plan to hold the stock for $5$ years, and are confident that it will sell for $$35$ at the end of $5$ years. How much should you offer to buy it today?

Please click here to solve the question in Spreadsheet.

a$)$ $$30\mathrm{.}67$

b$)$ $$24\mathrm{.}35$

c$)$ $$28\mathrm{.}41$

d$)$ $$35\mathrm{.}33$