amortization mortgage calculator with extra payments excel

Amortization mortgage calculator with extra payments excel full#

The easy to use calculator requires you to input fields namely:īased on the values you input into the fields, you can view the new EMI to the right of the calculator post prepayment. Home loan calculator with prepayment helps you determine the amount you can save using prepayment. It can not only reduce your debt but can also save you from paying excessive money in the form of interest.

Amortization mortgage calculator with extra payments excel full#

Home Equity Loan Calculator - For second mortgages (hopefully you won't ever need this one).Prepayment is one of the few ways in which you can either reduce or consolidate your debt by repaying the loan in part (or full) before the completion of full tenor of the loan.

Home Mortgage Calculator - Our feature-rich mortgage payment calculator that includes an amortization table, flexible prepayment options, and optional adjustable rates.

It is equal to the value of the home minus the amount owed. OWNER'S EQUITY: This tells you how much equity you may have in your home after the specified number of years based on the estimate of the property value. Therefore, you would need to estimate the future value of the home to calculate the estimated owner's equity at that time. Property Value: The value of real estate property changes based on the market. Loan Balance Due: The amount of principal that you still have to pay. Total Interest: The total amount of interest paid over the life of the loan.īALANCE at Year N: Enter a year to determine the amount due on your mortgage and how much equity you will have in your house at that time. Total Payments: The total amount paid (both principal and interest) over the life of the loan. The NPER formula is used to calculate the number of payments required to pay off the mortgage, taking into account extra payments. Number of Payments: This would normally just be 12 months times the Term of the loan, except that making extra payments can result in paying off the mortgage early. Normally, accelerated bi-weekly payments are set up such that each year the total amount of extra payments is equal to one normal monthly payment. To estimate Accelerated Bi-Weekly payments, enter an Extra Payment that is equal to the normal Monthly Mortgage Payment divided by 12. This assumes no penalties for making prepayments. Derived from the amount borrowed, the term of the loan, and the mortgage interest rate.Įxtra Monthly Payment: The extra amount you want to pay towards the principal each month (a regularly scheduled prepayment). Monthly Mortgage Payment (PI): Consists of both principal (P) and interest (I). Initial Monthly Interest: The monthly interest payment will go down each month, but for purposes of comparing the interest to the principal payment, the initial monthly interest payment (and the initial monthly principal) is shown. Monthly Interest Rate: The monthly interest rate is calculated from the annual interest rate and the compound period. For example, to enter '10 years + 3 months', enter the following formula: =10+3/12įor Canadian mortgages, the definition of 'Term' is different, so for Canadian mortgages you may want to change this label to 'Amortization Period.' You can enter a formula to a specify the number of months. If you enter your current mortgage balance in the Loan Amount, then enter the number of years you have left on your mortgage. Mortgages usually have 15 or 30-year terms. Term of Loan (in Years): The total number of years it will take to pay off the mortgage. This calculator assumes a fixed annual interest rate. You can also enter your current balance, if you also adjust the Term of Loan to be the number of years left to pay off the mortgage.Īnnual Interest Rate: This is the rate that is usually quoted by the lender. Loan Amount: This is the amount that you have borrowed. Canadian mortgage rates are quoted based on a semi-annual compound period (enter 2 for Canadian mortgages).

US mortgage rates are quoted based on a monthly compound period (enter 12 for US mortgages). Compound Period: The number of times per year that the quoted annual interest rate is compounded.