Hi, I really need some help in creating a formula for an investment calculator for the table image below. 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 Your help would be much appreciated