Assume you pay the reduced amount of $$4,580$ for a corporate stock that has a market value of $$5000.$ The stock pays an annual dividend of $3\mathrm{.}5\%$ 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$.)$

The spreadsheet function is $\_\_\_\_,$ and it displays $\_\_\_\_\_\_\_$Required information

Assume you pay the reduced amount of $$4,580$ for a corporate stock that has a market value of $$5000.$ The stock pays

an annual dividend of $3\mathrm{.}5\%$ 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$.)$

The spreadsheet function is

$,$ and it displays

$\%.$