dkmc submitted a new resource: Excel wizrds - financial formulae - Excel wizrds - financial formulae Read more about this resource...

Here is a template that you can use year by year, it will tell you how much it grows by each month... mainly works for managed funds though, but if you take the MER and entry fee out, it can work for anything... Initially has 3 monthly distributions, the % can be randomly changed if you find it unreasonable...

I would think the easiest option is the FV formula. in a cell, type: =FV(.15/12, 60, 1000, 100000, 0) .15/12 = Interest rate per month assuming compounding monthly. 60 = number of periods, assuming 5 year term 1000 = monthly payment 100000 = present value 0 = payment at the end of the period.