Interest Compounding Frequency: Monthly.Regular Payment Frequency: It means you pay your regular payments every month.Remaining Years: 28.50, It means you have already paid the regular payments for the period 30-28.50 = 1.5 years.Suppose you have loan details like the following: Let me show you the use of this template with an example. You can choose a different payment frequency for your extra recurring payments.In some countries, for example, Canada, payment frequency and interest compounding frequency can be different. You can choose your Interest Compounding Frequency.Time saved (if you made recurring extra payments or irregular/lump sum extra payments).Estimated interest savings (if you made recurring extra payments or irregular/lump sum extra payments).The total amount paid over the lifetime of the loan.The template will show you the following outputs: Depositing irregular / lump-sum payments when you are able.Calculating your regular payments (PMT).You can use this calculator in three ways: We can assure you that this is the most versatile Excel calculator for a mortgage loan. Let me explain the terminology and usage of this template. We have developed an Excel template that will be the best tool in your journey to becoming debt-free. From Warren Buffet to Ray Dalio, all big investors emphasize living beyond your means and saving the rest. From big countries to small businesses, all are sunk in debt. Different terms, fees or other loan amounts might result in a different comparison rate.Related Articles Using Mortgage/Loan Calculator with Extra Payments & Lump Sum in Excelīecoming a debt-free person is the best blessing in this age of the debt. WARNING: This comparison rate is true only for the example given and may not include all fees and charges. The comparison rate is based on a loan amount of $150,000 over a loan term of 25 years. To view these documents you may need Adobe Acrobat. Before making any decision in relation to our home loan products you should read the relevant Terms and Conditions booklet. Any advice on this website does not take into account your objectives, financial situation or needs and you should consider whether it is appropriate for you. The offset facility is only available on the Orange Advantage home loan account when linked to an Orange Everyday account.
There is no offset facility available on a fixed rate loan. Any additional payments or advanced funds are not available for redraw during the fixed interest period.
You should refer to the Home Loan terms and conditions for details and contact us on 133 464 for an estimate of the break costs that may be payable by you in the above circumstances. WARNING: If you select a fixed rate loan, break costs may be payable if, at any time before the fixed rate expires, you (1) pay out your loan, make an additional payment of $10,000 or more, or you make additional payments totalling $10,000 or more in any one-year period (with the first one-year period starting on the first day of the fixed interest period), or (2) you ask us to make certain changes to your loan including but not limited to your loan type, your repayment type, your loan purpose, your fixed interest period, the security on your property, your approved loan amount, your loan term, the borrowers on your loan or any other change that requires your loan to be re-documented. All features are not available for every type of loan. Details of these and the terms and conditions are available at or by calling 133 464. All applications for credit are subject to ING's credit approval criteria. All rates and information are correct at time of publication and are subject to change.