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
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]

Current Div​

[/td][td]

3.59​

[/td][/tr]


[tr][td]

2​

[/td][td]

Expected Div​

[/td][td]

7.1​

[/td][/tr]


[tr][td]

3​

[/td][td]

Years​

[/td][td]

7​

[/td][/tr]


[tr][td]

4​

[/td][td]

CAGR​

[/td][td]

10.232%​

[/td][/tr]
[/table]

Formulas

Data Range
[Table="class: grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][/tr]
[tr][td]

1​

[/td][td]

Current Div​

[/td][td]

3.59​

[/td][/tr]


[tr][td]

2​

[/td][td]

Expected Div​

[/td][td]

7.1​

[/td][/tr]


[tr][td]

3​

[/td][td]

Years​

[/td][td]

7​

[/td][/tr]


[tr][td]

4​

[/td][td]

CAGR​

[/td][td]

=RATE(B3,,-B1,B2)​

[/td][/tr]


[tr][td]

5​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table]

 

[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....