We have offered a downloadable Windows application for calculating mortgages for many years, but we have recently had a number of people request an Excel spreadsheet which shows loan amortization tables.
Our Excel mortgage calculator spreadsheet offers the following features:
The calculator updates results automatically when you change any input.
TIP: When you download Excel spreadsheets they will download in PROTECTED VIEW.
You need to click on the [Enable Editing] button in the yellow banner at the top of the spreadsheet to change variable amounts.
Right click on the following image to save a copy of our Excel loan calculator spreadsheet, or click on it to directly open it.
By default this calculator is selected for monthly payments and a 30-year loan term. A person could use the same spreadsheet to calculate weekly, biweekly or monthly payments on a shorter duration personal or auto loan.
The following table shows locally available mortgage rates which you can use to help calculate your monthly home loan payments.
US 10-year Treasury rates have recently fallen to all-time record lows due to the spread of coronavirus driving a risk off sentiment, with other financial rates falling in tandem. Homeowners who buy or refinance at today's low rates may benefit from recent rate volatility.
Are you paying too much for your mortgage?
Check your refinance options with a trusted lender.
Answer a few questions below and connect with a lender who can help you refinance and save today!