Thus, fill the same for all the loans you want to compare. If multiple prepayments are made the foreclosure charges are applicable to the total amount. EMI/Installment amount is calculated for each loan at the top and displayed in green boxes. In such cases, the foreclosure charges will be applicable on the prepayment amount. When you make any prepayment the foreclosure charges will be applicable as it decreases the number of installments or tenure.įor example, you opt for a personal loan and during the third year you manage to have a large amount or you think of early settlement. If you make any payments higher than your EMI then you need to enter them here. The prepayment table can be used later on during loan repayment. You need to enter the following details for each loan: This template consists of 3 sheets Loan Details Sheet, Amortization Schedule, and Loan Comparison Calculator. Contents of Loan Comparison Calculator Excel Template Let us understand the contents of the template and how to use this template.

In addition to the above, you can also download other personal finance templates like Savings Goal Tracker, Household Budget, Credit Card Payoff Calculator and Personal Income Expense Tracker from our website. The template compares the loans on the basis of interest to be paid, total repayment amount, repayment duration and installment amount.Ĭlick here to download Loan Comparison Calculator Excel Template Click here to Download All Personal Finance Excel Templates for ₹299. Just enter a few details for each loan scenario and it automatically compares all loans for you.įurthermore, the template also provides a loan amortization schedule for all scenarios. We have created a simple and easy Loan Comparison Calculator Excel Template with predefined formulas.

Loan Comparison Calculator Excel Template Contents of Loan Comparison Calculator Excel Template.Loan Comparison Calculator Excel Template.

Excel student loan repayment calculator