This advanced Excel calculator is designed to simultaneously manage Amortization Schedules for Multiple Loans. As you know, in most cases people as well as businesses don’t have just one loan.

However, if you are looking for a great calculator for only one loan (or mortgage) then instead of this one we recommend using this: Excel Amortization Schedule Calculator for Loan Repayments.

It has some additional  features (like extra repayments or interest compounding options) which are not included in the Multiple Loan Calculator.

Managing Multiple Loans in One Excel Spreadsheet

An average consumer usually maintains multiple loans in parallel. When the number of loans gets bigger than 2 or 3, managing all repayments can be quite challenging.

Our new calculator should help you get on top of your loans.

It will enable you to generate clear and easy to read repayments calendar. That way you will never ever overlook or miss a single loan payment. Off course, assuming that you have enough money available in your bank account.

Our Excel calculator has a form of amortization schedule which splits the repayment amount into two main parts – interest and principal.

This calculator also gives you visibility over all loans periods separately and combined as well. That way you should see exactly how much will be your repayment, interest and principal amounts.

It will greatly help you with your advance cash flow planning. Next, you should be able to identify periods when total repayments get higher than usual and prepare you for such event accordingly.

Free Multiple Loans CalculatorWith Our Excel Calculator for Multiple Loans you will be able to do all the things above and much more!

Download Demo Version: click here

Buy Full Version: click here

Benefits and things you can do with it:

Calculate amortization schedule for multiple loans at once

Breakdown of Repayment amount into Principal and Interest

Know exactly how much principal you owe for each loan at any time

Know exact date when you become debt free

Easy planning and modeling your loans

Project your cash flow years in advance

Supported loan types – car loans, personal loans or hire purchases

Can be used for mortgages as well

Repayment frequency: weekly, fortnightly and monthly

Calculate schedules for up to 30 parallel loans (easily add even more)

Number of combined repayment periods available: 8000

Enough for 10 loans x 15 years x 52 weeks/year = 7800 (or 30 loans x 20 years x 12 months = 7200 repayment periods)

Set individual interest rate (p.a.) for every loan

Set any start date for each loan, even in the past

Recreate amortisation schedules for already running loans

Find out if your bank charges you correct interest rates

After keying in all the entry data, you can see the result immediately.

Calculation Results:

Graph with combined monthly repayments throughout the whole term

Graph with individual loan balances owed through loan life cycle

Graph with combined loans balance owed through entire period

Detailed amortization schedule for each individual loan

Monthly repayments calendar (extendable to any length)

With this excel calculator you will know exactly how much you owe (loans principals) at any given time. You will also know exact amounts of your combined monthly commitments throughout the entire loans term.

Before you decide to take out any new loan, just enter its details into your existing loan portfolio. You will immediately see how it affects your future cash flow.

Our Excel calculator for Multiple Loans will give you answers to following questions:

1. Can you really afford any extra loan? If so, how big?

2. How long before some of your existing loans expires and releases available cash flow for a new loan?

3. Will there be any months when loans with different repayment frequencies combine and put an extra demand on your outgoing cash flow?

4. When will you become debt free?

5. How any new loan will impact your ability to meet repayments?

6. How will any additional loan extend the period before becoming debt free?

7. How much interest on top of principal will each loan cost you?

User Manual

There are three spreadsheets within the Excel workbook:

1. Entry data (and Graphs)

Note 1: Once you enter all loans parameters, click on Data -> Refresh button to recalculate the results.

Note 2: Please follow the default layout for entry parametrs. Also, use loan numbering from 1 to 10 sequentially in ascenting order. For no loans leave all fields empty. Any deviation from default format may cause the calculator to not function properly.

2. Loan schedule

Loan Schedule

(click to enlarge)

3. Repayment calendar

Repayment Calendar

(click to enlarge)

We would love to hear your feedback about this calculator. If you have any comments, suggestions for improvements or if you find any error in the calculator, please do let us know. We truly appreciate your valued opinion.

Posted on: January 26, 2019
Categories: Articles
15 Responses to Multiple Loan Repayment Calculator: Excel Amortization Schedule
  1. Hello,
    I am holding a mortgage for a relative that misses a lot of payment and pays late and odd amounts. Do you have an amortization schedule that would help me fairly track his payments and interest? He doesn’t pay according to his schedule at all, and I don’t know how to manage it fairly.

  2. Hello,

    After inputting new data into the first worksheet, the data refresh option isn’t available, its grayed out. What should I do?

    • When you open a new Excel file on your PC, the Excel sometimes wants you to accept the file. It shows a bar under the Menu. You just need to click “OK” or “Accept”.

  3. I have 4 loans that I would like to apply a fixed amount continually until all are payed off, Example:

    Loan 1,2,3 are all lower interest and will take 2 year to pay off. Loan 4 is high interest and I am paying off fast at $400 per month and will be payed off in 9 month.

    I would like to reapply the now available $400 / month to one of the other 3 loans a 2 or 3 to speed up their repayment schedule.

    I would like to do this until all the loans are payed off with the fixed amount available every month.

    Is there a way to edit this spreadsheet to accomplish this?

    Dave

    • Hi Dave, thanks for your question.

      This calculator is not designed for changing repayments mid-term. All loans have to follow standard repayment schedule. You can try to modify the calculator if you wish, but you will be on your own. We are not offering custom modifications. We sell this calculator “as is”.

      Maybe this would be a better suited calculator for your purpose:

      https://www.unclefinance.com/ultimate-loan-mortgage-amortization-calculator-in-excel/

      However, the other calculator is just for one loan, so you would have to calculate 4 loans separately.

  4. I just purchased the sheet. How do I use it for credit cards?

  5. Hi

    I’m looking to do this for approximately 1000 loans, for business purposes.

    Do you have a sheet for that many loans?

    • This spreadsheet can theoretically handle even 1000 loans, but calculating so many loans in Excel can make the spreadsheet to work extremely slowly. I would suggest searching for a special loan program or application, not Excel.

      • Not quite looking for 1000 but I’d like to build beyond the 30 and want to confirm that the purchased edition can be added to and the workbook would have full access to all formulas and sheets. I’d like to potentially add to the entry sheet columns to add more details but maintain all that is existing. I may want to build addition tables or graphs off the data. This sheet is great and exactly what I was envisioning!

        • Yes, in the purchased version you have full access to all sheets and formulas. There is one hidden sheet containing calculations, but you can easily unhide it (by right clicking on any sheet and choosing “unhide”).

  6. Is it possible to take the features of the Ultimate loan calculator, where you can adjust the amortization schedule. Then incorporate that into the Multiple Loan calculator? That would be amazing if you could possible create such a calculator. I have multiple loans, and I have probably never made a payment on the actual due date. I typically pay well before it’s due, and I am ahead on most of my bills. I also pay extra. I would like to utilize the graphing capabilities of the multiple loan calculator to figure out which loan would be best to pay off early. Then with that loan paid off, I would like to add the money that I am not longer paying on that paid off loan every month, to one of my other loans to pay that one off early too. I hope to utilize that to minimize my interest and loan lengths efficiently.

    • Hi Terron, this would be too complex for an Excel streadsheet. This kind of functionality may be availabe in special credit/loan programs or applications. Try to look in this area.

Leave a Reply

Your email address will not be published.