Formula required for compound interest: forecasted performance on lump sum

[simplyharoon]

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

 

[stapel]

What have you tried? How far have you gotten? Where are you stuck?

Please be complete. Thank you!

 

[Denis]

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.