YoY Increase over n Years - Sum all Years in a single formula

[ldoodle]

Hi,

Is this possible. What I am looking for is a formula to sum up the starting price (e.g. today's price) plus a 10% increase on that price every year for n number of years. n is selectable from a drop-down.

Sample sheet is here: YoY Increase Sum Total.xlsx

H4 should match B15.

I need to do this with a lots of different values so having helper tables for each of them would get super messy!

Thanks

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[ldoodle]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

M365.

 

[Fluff]

Thanks for that
How about

YoY Increase Sum Total.xlsx
	A	B	C	D	E	F	G	H
1		% Increase YoY			No Increase YoY			Single Formula
2		£47,384.42			£47,384.42			£47,384.42
3
4	0	£47,384.42		0	£473,844.20		10	£755,185.62
5	1	£52,122.86
6	2	£57,335.15
7	3	£63,068.66
8	4	£69,375.53
9	5	£76,313.08
10	6	£83,944.39
11	7	£92,338.83
12	8	£101,572.71
13	9	£111,729.98
14
15		£755,185.62			£473,844.20			£755,185.62
16		£189,528.80			£189,528.80			£189,528.80
17		£944,714.42			£663,373.00			£944,714.42
Sheet1

Cell Formulas
Range	Formula
E4	E4	=$B$2*10
H4	H4	=SUM(B2*1.1^SEQUENCE(G4,,0))
B4:B13	B4	=$B$2*(1.1^A4)
B15,H15,E15	B15	=SUM(B4:B13)
B17,H17,E17	B17	=B15+B16

 

[ldoodle]

Nice, thanks. Not come across SEQUENCE before.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Cubist]

You can also try the FV function.

Book1
	C
7	($755,185.62)
Sheet4

Cell Formulas
Range	Formula
C7	C7	=FV(10%,9,47384.42,47384.42,0)