Assume you pay the reduced amount of $4,750$ for a corporate stock that has a market value of $5,000.$ The stock pays a 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 $5,000$ market value. Develop spreadsheet functions that display the following results:

a$.$ Total amount of the dividends paid to you

b$.$ Equivalent future worth after $10$ years of the dividend at in $6S$ per vear

c$.$ 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.

d$.$ Rate of Return on this entire investment over a $10-$year period. $($Note: The anwwer displayed here should confirm to your response to the question in part c$)$