Needs to be in Excel with the Formulas!

The year-end prices of Copard Co's shares are as shown below.

YEAR Price($s/share) End of Year Dividend ($s/share) Paid end of Year

0 $53.75 Investor D buys 100 shares at end of Year 0

1 $56.25 $2.75

2 $58.35 $3.00 Investor E buys 100 shares at the end of Year 2

3 $55.50 $3.25

4 $57.90 $3.50 Investor F buys 100 shares at the end of Year 4

5 $61.70 $3.75

None of the investors received dividends in the year they purchased Copard's stock.

All three investors sell their shares at the end of Year 5 immediately after receiving their dividends.