How to calculate P&I repayment?

Discussion in 'Loans & Mortgage Brokers' started by kennyboi, 6th Sep, 2015.

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

    kennyboi Well-Known Member

    Joined:
    23rd Jun, 2015
    Posts:
    171
    Location:
    Sydney
    Hi,

    I am thinking to switch from IO to PI on my PPOR. I am having trouble trying to work out my monthly repayment.

    Say the loan is 1 Mil, and the bank's repayment calculator is showing a repayment of 4972/month, how do I work out how much is for P and how much is for I?

    As my offset account grows quicker than P repayment, would the repayment still be fixed at 4972/month, or is it going to a reduced figure? If reduced, how do I calculate this amount?

    Thanks
     
  2. Peter_Tersteeg

    Peter_Tersteeg Mortgage Broker Business Member

    Joined:
    18th Jun, 2015
    Posts:
    8,130
    Location:
    03 9877 3000
    The monthly interest component can be calculated to within a few dollars using the following formula:
    Amount owing x Interest rate / 12

    The balance would be the principal.

    With principal & interest loans, you enter into a contract to make a minimum monthly repayment (by your calculation $4972/month). Even if you have money in an offset account or have made extra repayments, you'll still need to make that minimum monthly repayment. The extra money simply means you owe less, so you'll pay less interest, and more principal in the subsequent payments.
     
  3. Waterboy

    Waterboy Well-Known Member

    Joined:
    29th Aug, 2015
    Posts:
    2,802
    Location:
    Denial is Not a River in Egypt
  4. kennyboi

    kennyboi Well-Known Member

    Joined:
    23rd Jun, 2015
    Posts:
    171
    Location:
    Sydney
    If there is a change in interest, how does this affect repayment amount, and how to calculate the difference?

    I use Excel to keep track of IO, but I don't know how to formulate my Excel to keep track of P&I.
     
  5. D.T.

    D.T. Specialist Property Manager Business Member

    Joined:
    3rd Jun, 2015
    Posts:
    9,189
    Location:
    Adelaide and Gold Coast
    Remember interest is calculated daily but charged monthly, so when the rate changes the remainder of the days in that month have that rate.

    Also remember your offset account balance will come off of the total amount owing when calculating interest.

    Hope this helps in formulating your spreadsheet :)
     

Not all tax advisers are property focussed specialists and DIY errors will always cost you. We know property taxes and will advise and get it right. Even a second opinion. Contact us for an obligation free initial consult (conditions apply).