Multiple Loan Amortization Schedule Excel Template [Free Download]

How to Use This Template


  • Open the file and go to the Loan Input sheet. Insert your multiple loan parameter values and choose the required dropdowns in the blue shaded area.
Insert Multiple Loan Parameters

Click here to enlarge the image

  • After inserting the parameters, you will get your multiple loan amortization schedule and necessary output values on the right side.
Multiple Loan Amortization Schedule

Click here to enlarge the image

  • Apart from basic loan repayment approach outputs, you will also get outputs for following the “Paying off your debts without refinancing” approach.
  • You can also compare the interest paid values between the approaches and create a comparison chart to do so quickly.
Paying off Debt Faster Without Refinancing

Click here to enlarge the image

  • To determine whether refinancing helps your multiple loans, insert necessary inputs in the blue shaded area of the “Refinance with New Loan Terms and New Payments” table. You will automatically receive the necessary outputs on the right side, along with a summary chart showing a live comparison of interest paid for following different approaches.
Refinancing with New Loan Terms and New Payments

Click here to enlarge the image

Multiple Loan Amortization Schedule Excel Template Tips

  • Insert all the required inputs properly and choose all the dropdowns.
  • Follow the inserted notes in the parameters to enter input values.
  • If you want to get an individual amortization schedule of your loans, you will see that there are several hidden sheets for individual loans. Unhide them, and you will see all outputs for individual loans.
  • If you insert extra payments, then follow the notes properly to avoid any errors.
  • When choosing interest compounding frequency, do not choose any frequency lesser than your chosen regular payment frequency. Otherwise, it would show you an error.

Download Excel Template

Download Excel Template

For: Excel 2007 or later
License: Private Use

Related Articles

<< Go Back to Amortization Schedule | Finance Template | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Tanjim Reza
Tanjim Reza

Md. Tanjim Reza Tanim, a BUET graduate in Naval Architecture & Marine Engineering, contributed over one and a half years to the ExcelDemy project. As an Excel & VBA Content Developer, he authored 100+ articles and, as Team Leader, reviewed 150+ articles. Tanim, leading research, ensures top-notch content on MS Excel features, formulas, solutions, tips, and tricks. His expertise spans Microsoft Office Suites, Automating Finance Templates, VBA, Python, and Developing Excel Applications, showcasing a multifaceted commitment to the... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF