![]() The first is to enter the original loan amount and date and then make adjustments to the payment history within the Payment Schedule as needed. There are a couple of ways to analyze your existing home mortgage. Choose when to start the scheduled extra payments.Select a fixed-rate or variable rate mortage.Works for both US and Canadian mortgages (via the compounding option).Automatically calculates so-called "Accelerated Bi-Weekly" payments.Estimates Property Taxes and Insurance for calculation of the PITI payment.New Features of our Home Mortgage Calculator What will my loan balance be at the end of 3 or 5 years?.How soon could I pay off my home if I make extra payments?.How much might my monthly payment change over time if I have a variable-rate mortgage?.How does the tax deduction from paying interest change over time?.How much can I save by making extra payments?.This mortgage calculator can help you answer some of the following questions: So, if you have questions, you can hover the mouse cursor over any cell that has a little red triangle in the corner. Home Equity Loan Calculator - For second mortgages (hopefully you won't ever need this one).Information about how to use our free home mortgage calculator and definitions of some of the terms are included as cell comments in the spreadsheet.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.
0 Comments
Leave a Reply. |