Join our investing community

Excel wizrds - financial formulae

Excel wizrds - financial formulae

  1. dkmc

    dkmc Well-Known Member

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

    Excel wizrds - financial formulae - Excel wizrds - financial formulae

    Read more about this resource...
     
    Last edited by a moderator: 15th Sep, 2016
  2. DaveA

    DaveA Well-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...
     

    Attached Files:

  3. myarhidia

    myarhidia Member

    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. dkmc

    dkmc Well-Known Member

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