Mortgage calculator

Discussion in 'Loans & Mortgage Brokers' started by JesseT, 30th Sep, 2017.

Join Australia's most dynamic and respected property investment community
  1. JesseT

    JesseT Well-Known Member

    Joined:
    29th Jun, 2015
    Posts:
    204
    Location:
    Sydney
    I'm looking for a simple mortgage calculator, I used to have an app called 'tap mortgage' which was great, you select loan amount, interest rate P&I/IO and had an option to make extra payments and see the reduction in time it took from your loan.

    That app is no longer around and I can't find one as useful, what is everyone using?
     
  2. Invest_noob

    Invest_noob Well-Known Member

    Joined:
    21st Mar, 2017
    Posts:
    299
    Location:
    Sydney
  3. Eric Wu

    Eric Wu Well-Known Member

    Joined:
    8th Oct, 2016
    Posts:
    1,603
    Location:
    Australia
  4. LifesGood

    LifesGood Well-Known Member

    Joined:
    26th Jun, 2015
    Posts:
    911
    Location:
    Perth WA
    Vow Mortgage Kit is the best app I've used. Better than Tap in my opinion.
     
  5. JesseT

    JesseT Well-Known Member

    Joined:
    29th Jun, 2015
    Posts:
    204
    Location:
    Sydney
    Thanks Eric,
    I believe I listened to to you on SPI podcast on my way to work the other day.
    Great work, keep it up!
     
    Eric Wu likes this.
  6. JesseT

    JesseT Well-Known Member

    Joined:
    29th Jun, 2015
    Posts:
    204
    Location:
    Sydney
    Thanks, best one I have seen
     
  7. Eric Wu

    Eric Wu Well-Known Member

    Joined:
    8th Oct, 2016
    Posts:
    1,603
    Location:
    Australia
    Thanks @JesseT , I was on SPI a while ago. (I feel awkward listening to my own voice:()
     
  8. Peter_Tersteeg

    Peter_Tersteeg Mortgage Broker Business Member

    Joined:
    18th Jun, 2015
    Posts:
    8,171
    Location:
    03 9877 3000
    There's millions of mortgage calculators out there. They all work on the same equation. A Google search or a search of any app store will give you plenty of results.

    Personally I write them myself in Excel as I can make this do all sorts of things. The formula to generate a monthly repayment is:

    -PMT(Rate, Loan term, Amount)

    Rate is the annual interest rate, divided by 12 to give you the monthly interest rate.
    Loan term is the amatorisation period in months.
    Amount should be self explanatory.

    If you're after interest only repayments, it's the following:
    Repayment = Loan amount x Rate / 12.
    In this case the rate is the annual interest rate.
     
    thydzik likes this.