Search
Generic filters

Loan Comparison Calculator Excel Template

Loan Comparison Calculator is a ready excel template to compare multiple scenarios. Comparison is based on 4 different criteria; interest rate, installments, repayment duration and total repayment.

In addition to above, the template represents the comparison in graphical format. Moreover, it also consists of an EMI calculator and loan amortization schedule with loan foreclosure/prepayment provision.

Choosing between multiple loans is very confusing at times and if you are new, then it just becomes more confusing. Many times, lender makes it more complicated by using difficult terminology instead of simple terms.

The best part about this template is an individual can compare multiple scenarios for a personal loan, mortgage loans, auto loans, and even private lenders.

Mortgage Calculator Comparison Excel Template

We have create a simple and easy Loan Comparison Calculator Excel Template with predefine formulas. Just enter  few details for each loan scenario and it automatically compares all loans for you.

Furthermore, this template also provides a loan amortization schedule for all scenarios. The template compares the loans of interest to be paid, total repayment amount, repayment duration and installment amount.

Contents of Loan Comparison Calculator Excel Template

This template consists of 3 sheets; Loan Detailed Sheet, Amortization Schedule, and Loan Comparison Calculator.

Loan Details Sheet

You need to enter following details for each loan:

  1. Loan Start Month
  2. Loan Amount
  3. Period (Years)
  4. Interest Rate
  5. Processing Fees
  6. Foreclosure Charges

The prepayment table is later used during loan repayment. If you make any payments higher than your EMI then you need to enter here.

When you make any prepayment foreclosure charges will be applicable as it decreases number of installments or tenure.

Thus, fill same for all the loans you want to compare. You can compare up to 3 loans in this sheet. If you want to compare more, then you need to insert more column accordingly.

Amortization Schedule

You don’t have to make any entry in this sheet. Amortization Sheet displays EMI serial numbers and dates on the right hand side. Additionally, it consists of complete month-wise repayment schedule until loan amount is 0.

It displays schedule for all three loans according to their tenure. The table consists of following columns:

Interest Amount
Prepayment Amount
Principle Amount
Balance Loan Amount

This sheet can calculate your loan installments for up to 30 years. It displays amortization schedule for all 3 loan scenarios with comparison rate.

Loan Comparison Calculator

This sheet consists of a table that displays the summary of all the three loans. It consists of the following details:

Processing Fees
EMI-Monthly Installments
Interest Paid
Foreclosure Charges
Total Amount Paid
Number of Installments
Last Date of EMI

This sheet fetches the processing fees, EMI-Monthly Installment Amount, the number of installments, Interest paid, and last date of payment from the previous sheet.

Moreover, Total interest paid is the amount paid including the processing fees, principal amount, interest amount, and foreclosure charges if applicable.

Compare the Market Mortgages

Above all, The last sheet consists of a graphical representation of the loan comparison. It compares on the following 4 criteria: Number of Installments, Installment Amount, Interest Amount and Total Payment Amount.

Download Loan Comparison Calculator Excel Template
Share on facebook
Share on linkedin
Share on email
Share on whatsapp

Download Guide

Compatible with : Microsoft Office Excel, Libra Office, WPS Office, Google WorkSheet
  • Download The Template XLSX File Format
  • Use the Template

Download Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Recently Uploaded Excel Templates: