Annual escalation formula based on remaining months

[Pizzio]

I need to add a formula in column D (expected value) that takes the monthly amount and escalate it X% annually (every 12 months) through the remaining term.
Example below:
Amount Escalation Months remaining Expected Value
$389.50 3% 77 32,558.76
$389.50 3% 11 4,284.50

​

 

[Eric W]

Try:

Book2
	A	B	C	D
1	Amount	Escalation	Months remaining	Expected Value
2	389.5	3%	77	32558.76
3	389.5	3%	11	4284.5
Sheet4

Cell Formulas
Range	Formula
D2:D3	D2	=SUM(A2*(1+B2)^INT(SEQUENCE(C2,,0,1/12)))

 

[Pizzio]

Try:

Book2
	A	B	C	D
1	Amount	Escalation	Months remaining	Expected Value
2	389.5	3%	77	32558.76
3	389.5	3%	11	4284.5
Sheet4

Cell Formulas
Range	Formula
D2:D3	D2	=SUM(A2*(1+B2)^INT(SEQUENCE(C2,,0,1/12)))

You are BRILLIANT!! It worked. thank you, you saved me so much time

 

[Eric W]

Happy to help! Thanks for the feedback.