Forum Discussion
Solved
Series on excel
I have a value, 100 for example and a rate (5%) with a period on 3 years and use 90% of the result. I need to recreate this formula (100/3*((1+5%)³-1)+100/3*((1+5%)²-1)+100/3*((1+5%)-1)*90% So if i ...
HvgoCA As a variant, and if you are on a recent version of Excel, please find a formula in the attached workbook, using the SEQUENCE function. No VBA required.
Edit: updated file!
You could either follow Riny_van_Eekelen solution of
= (base*factor/n) * SUM((1+perc)^k - 1)
where k is
=SEQUENCE(n)or you could bite the bullet and sum the geometric series algebraically
= (base*factor/n) * (((1+perc)^n - 1)*(1+perc)/perc - n)