Mortgage payment calculator spreadsheet download

Loan Amount : This is the amount that you have borrowed. 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. Annual Interest Rate : This is the rate that is usually quoted by the lender.

This calculator assumes a fixed annual interest rate. See the note under "Compound Period". Term of Loan in Years : The total number of years it will take to pay off the mortgage. Mortgages usually have 15 or year terms. If you enter your current mortgage balance in the Loan Amount, then enter the number of years you have left on your mortgage. You can enter a formula to a specify the number of months. For Canadian mortgages, the definition of "Term" is different, so for Canadian mortgages you may want to change this label to "Amortization Period.

Monthly Interest Rate : The monthly interest rate is calculated from the annual interest rate and the compound period. 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. Derived from the amount borrowed, the term of the loan, and the mortgage interest rate.

Extra Monthly Payment : The extra amount you want to pay towards the principal each month a regularly scheduled prepayment. This assumes no penalties for making prepayments. 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.

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.

The NPER formula is used to calculate the number of payments required to pay off the mortgage, taking into account extra payments. Total Payments : The total amount paid both principal and interest over the life of the loan. Property Value : The value of real estate property changes based on the market. Therefore, you would need to estimate the future value of the home to calculate the estimated owner's equity at that time.

It is equal to the value of the home minus the amount owed. Mortgage Payment Calculator. Total Interest : The total amount of interest paid over the life of the loan.

Loan Balance Due : The amount of principal that you still have to pay. Disclaimer : This calculator is only for educational purposes. The results are only estimates. Please consult a qualified professional regarding financial decisions. Follow Us On Sponsored Listings. Amortization Schedule Amortization Chart. Sitemap Privacy Policy Terms of Use. Luckily, Microsoft Excel offers cross-platform functionality.

We offer an Excel mortgage calculator spreadsheet to a software program? You're in luck, as we also offer that option, as well as a basic Excel loan calculator. Download the free desktop mortgage calculator for Microsoft Windows today. We offer 2 convenient options:.

Mortgage Calculator. This is the best option if you plan on using the calculator many times over the coming days, weeks, and months. This is typically the home price less your downpayment. In some cases homebuyers pay for closing costs upfront while in other cases they may roll them into the loan.

For your convenience, we publish local Los Angeles mortgage rates below to help you see currently available rates. Simply fill in whatever data you know, and then click the find button next to the last open field. This makes the calculator flexible, fitting many different needs.