- #1

moonman239

- 282

- 0

So far, I have a spreadsheet with columns "Years," "Shares," "Share Cost - Dividends," and "Dividends."

The "Shares" column has the formula shares=1+ROUNDDOWN(((0.8*A4)*B3)/30.5,0.1), the first part of the equation (.8*A4)*B3 representing the dividends paid out to me the previous year.

The "Share Cost - Dividends" column has the formula = (30.5)*# of Shares - Amount in Dividends Paid Out The Last Year.

The "Dividends" column has the formula = (.8*Shares)*Years.

Does this look good or do I need to change anything in the spreadsheet?