student loan repayment calculator excel download for numerous loans

It displays the amortization schedule for all 3 loan scenarios. This sheet can calculate your loan installments up to 30 years. The table consists of the following columns: It displays the schedule for all three loans according to their tenure. Additionally, it consists of a complete month-wise repayment schedule until the loan amount is 0. Amortization Sheet displays EMI serial numbers and dates on the right. You don’t need to make any entry in this sheet. If you need any help we will be happy to help you. IF you want to compare more, then you need to insert the column accordingly. You can compare up to 3 loans on this sheet. 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.

Student loan repayment calculator excel download for numerous loans