Formula required for compound interest: forecasted performance on lump sum

simplyharoon

New member
Joined
Mar 8, 2019
Messages
1
Hi, I really need some help in creating a formula for an investment calculator for the table image attached. I would be very greatful if you could help.

I would like to work out a formula for a yearly lump sum over 10 years & 9% interest every year, but at year 1 there is a premium which is -total as you can see in the image

11288
 

stapel

Super Moderator
Staff member
Joined
Feb 4, 2004
Messages
15,945
What have you tried? How far have you gotten? Where are you stuck?

Please be complete. Thank you! :geek:
 

Denis

Senior Member
Joined
Feb 17, 2004
Messages
1,689
Annual interest of 9% is clearly stated in your attached table.
BUT 9% is NOT the resulting rate.
As example, the interest used to arrive at the year#2 balance
of 1858.08 is 27.37%: (1858.08 - 1200.0)/516.66 = 1.2737

Please explain.
 
Top