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.
With Our FREE 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 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)
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
3. Repayment calendar
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.
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.
I would recommend this loan calculator: https://www.unclefinance.com/ultimate-loan-mortgage-amortization-calculator-in-excel/
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”.