6. 1.80 Assume you pay the reduced amount of $4750 for a corporate stock that has a market value of $5000. The stock pays an annual dividend of 4% of its market value. Since this is primarily a dividend-paying stock, you estimate that you will sell the stock 10 years from now at the current

$5000 market value. Develop spreadsheet functions that display the following results:

1. Total amount of the dividends paid to you.
2. Equivalent future worth after 10 years of the dividends at i = 6%
per year.
3. Present worth now (year 0) of the original purchase price, dividends and proceeds when the stock is sold after 10 years, if i = 6% per year. Observe the sign on the result and explain what it means to you financially.
4. Rate of return on this entire investment over a 10-year period.
(Note: The answer displayed here should confirm your response to the question in part c.)