Growth Function

[DavidHum]

Hi, which Function should I use to calculate the Total of 5 Years Growth when the Total for Each Year is 2% Greater that the Previous Year

Thanks - DavidHum

 

[SanjayGMusafir]

If the YOY growth is fixed 5Y Growth shall also be fixed.

Check this and revert -

Book1
	A	B	C	D	E	F
1	Y1	Y2	Y3	Y4	Y5	G5Y
2	100.00	102.00	104.04	106.12	108.24	8.24%
Sheet1

Cell Formulas
Range	Formula
B2:E2	B2	=A2*1.02
F2	F2	=(E2-A2)/A2

 

[DavidHum]

Hi 1st Thankyou but I had already tried that, my Variables are term x (10), increase each year total by y% (100*102"=102, Z= total all 10 years.

 

[SanjayGMusafir]

There is FV function that gives Final Value with Compound Interest or in your case Year on Year Growth. You can use that.

 

[DavidHum]

Great Great & Thanks, Works 1st Time using Microsoft Excel Coach

DavidHum