Required information

Assume you pay the reduced amount of $$4,615$ 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.

Identify the spreadsheet function that displays the present worth now $($year $0)$ of the original

purchase price, dividends, and proceeds when the stock is sold after $10$ years, if $i=6\mathrm{.}1\%$ per

year.

The spreadsheet function is $=-PV(6\mathrm{.}1\%,10,200,5000)-4615vv,$ and it displays $