Get expert help now.

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. The Vertex42® Mortgage Payment Calculator is a very simple spreadsheet that lets you compare different mortgages side-by-side. In order to use the above Excel Mortgage Calculator, simply enter your mortgage details into the pink-shaded user-input fields (shown on the right above).The details required are the loan amount, the interest rate, the number of years over which the loan is taken out, and the number of payments per year.

It calculates your monthly payment and lets you include additional extra payment (prepayments) to see how soon you could pay off your home, or how much you could save by paying less interest. Contains 3 scenarios that can all be customized as required. Starting in month 67, the balance on the 11-7/8% mortgage is lower than that on the 12% mortgage.

The other two tabs contain the amortization schedules, one for each loan.

Download Edit in Browser Share. Three tabs are included.

Note, this spreadsheet does not take into account the tax consequences or lost interest (i.e., if you were to invest the money used to refinance). Loan comparison calculator. This calculator will help you compare the costs associated with up to four different loans.

Built-In Formula for Accurate Computations.

Excel.

I’ve got the spreadsheet available for free on Google Sheets. The last thing you want is to buy a home, only to find out you can’t make the payments, or worse, there was a house that had cheaper monthly payments.

After entering this data for each loan the results will appear instantly, enabling you to compare monthly payment amounts and total interest charges. An Inputs tab which requires only a few inputs for each loan, allowing instant comparison. Calculator Rates Microsoft Excel Mortgage Calculator with Amortization Schedule Want to Calculate Mortgage Payments Offline? 32 Free Excel Spreadsheet Templates Try Smartsheet for Free In this article, we’ve compiled a wide variety of Excel templates and spreadsheets to provide you with the best, most comprehensive listing, so you can create timelines, track inventory, and manage all the critical aspects of your business. You can take a more in-depth look at the breakdown of a loan … Highline Excel Class 49: Spreadsheet To Compare Loans ... Make a spreadsheet to compare two loans / mortgage .

Have our partners at Excelchat fix your formulas, 24/7. I'm CEO of TechSoft, a custom software/web design company.

Use Excel to get a handle on your mortgage through determining your monthly payment, your interest rate, and your loan schedule. The Mortgage Comparison Sheet is a helpful new way to compare mortgage prices for your future home opportunities.

NerdWallet's loan comparison calculator helps you compare the monthly and total cost of two mortgage, small business or personal loan offers.

This wikiHow teaches you how to calculate your mortgage-related expenses like interest, monthly payments, and total loan amount using a Microsoft Excel spreadsheet. Aburt's "Ultimate" Loan Comparison Tool [Free, not selling anything, not affiliated with any company, just a helpful tool I created] Hi, I'm Dr. Andrew Burt.

This accessible template helps you compare multiple loan scenarios to ascertain which one is best for you. You can also estimate the equity in your home after a specified number of years. 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.