repeated investment...with costs...
 

hello to all the community...

I am trying to work out some statistics..

the excel help files I checked but cos I dont know what the function(s)
are called am lost.

heres what am trying to do:

if I was going to make an investment of £1,500 and there was a
time span/due date to make this payment but the payment was
late and I had to make a late payment fee of 2.50% of the
£1,500 plus 5% tax on top.

how do I add on to say that my next investment is £1500+2.50%+5%tax
on top for my second investment then for 3,4,5 and so on.

may I take this moment to thank all inadvance for your help and
time.

very much appreciated.

Paul.