Excel wizrds - financial formulae

Excel wizrds - financial formulae

1. dkmcWell-Known Member

Joined:
24th Aug, 2005
Posts:
165
dkmc submitted a new resource:

Excel wizrds - financial formulae - Excel wizrds - financial formulae

Last edited by a moderator: 15th Sep, 2016
2. DaveAWell-Known Member

Joined:
19th Feb, 2007
Posts:
617
Location:
Sydney, NSW
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...

File size:
26 KB
Views:
114
3. myarhidiaMember

Joined:
12th Oct, 2006
Posts:
21
Location:
Kingsgrove
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.

4. dkmcWell-Known Member

Joined:
24th Aug, 2005
Posts:
165
thanks
the FV formula was exactly what I was looking for