Saturday, February 18, 2012

How do I calculate the quarterly percentage change in dividends using excel?

If the old quarterly dividend was 10垄 and the new quarterly dividend is 12垄, then enter the formula in a cell:





= .12/.10 - 1





and format the cell to show the result as a percentage.

No comments:

Post a Comment