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.

This calculator also gives you visibility over all loans periods combined. That way you should see exactly how much your repayments will be every single month.

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

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

Download Free Version: click here

Buy Premium Version: click here

Benefits and things you can do with it:

Calculate amortization schedule for multiple loans at once

Breakdown of Total Repayment amount into Principal and Interest

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

Know exactly how much principal you owe in total 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)

Entry screen and graphs

(click to enlarge)

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.

2 Responses to Multiple-Loan or Mortgage Payment Schedule Calculator in Excel
  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.

Leave a Reply

Your email address will not be published. Required fields are marked *