Assume you pay the reduced amount of $4,665 for a corporate stock that has a market value of $5000. The stock pays an annual dividend of 4.9% 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.
Identify the spreadsheet function that displays the 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.)
