Dividend Increase per year knowing the starting dividend and the ending dividend.

[mikeschn]

It's such a simple question, but I don't know how to write the formula... Here's the question:

If one knows that in 2018 that $3.59 was paid in dividends, and that in 2024 the expected dividend is $7.10, what is the percentage increase per year that will get you from $3.59 to $7.10?

Thanks,

Mike...

 

[alansidman]

Data Range

	A​	B​
1​	Current Div​	3.59​
2​	Expected Div​	7.1​
3​	Years​	7​
4​	CAGR​	10.232%​

Formulas

Data Range

	A​	B​
1​	Current Div​	3.59​
2​	Expected Div​	7.1​
3​	Years​	7​
4​	CAGR​	=RATE(B3,,-B1,B2)​
5​	​	​

 

[mikeschn]

Alan,

I need the Percent increase per year. For example, in this example it's somewhere between 14% and 15%. But I can not write the formula to give me the exact amount.

Thanks...

Mike...

 

[mikeschn]

Hey that works!!! I changed it to 5 years, and got 14.6%. Cool! Thanks...

Mike....