I want to use Excel to figure out how much money, in dividends, I could make if I bought a stock in Microsoft, whose stock has recently stayed at $30-$31. They pay $0.80 in dividends/share.(adsbygoogle = window.adsbygoogle || []).push({});

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?

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Using Excel to figure out how much money I could make if I traded my dividends?

Loading...

Similar Threads - Using Excel figure | Date |
---|---|

Plot compound parabolic concentrator in Excel | Mar 7, 2018 |

I Which x_0 to use in a Taylor series expansion? | Feb 19, 2018 |

I Find the height up a ladder where a dropped bottle will break, using only two bottles | Feb 6, 2018 |

B Using trig to find distance? | Jan 18, 2018 |

Using reference angles to evaluate trig function | Jan 12, 2018 |

**Physics Forums - The Fusion of Science and Community**