Multiple Loan Repayment Planning with Extra Principal Applied

Video Tutorial (shows how to build from scratch):

If you have multiple principal and interest loans (not interest only debt) and you know you will have some extra cash flow to try and pay that debt back faster, you may want to know where to allocate this extra principal so that it saves you the most interest over time.

What this model does is rank your loans in two different ways (you can toggle the ranking style to see how they effect your total repayment). The first way you can define the extra payment allocation is by having the model apply it according to the total lifetime interest of each loan. That means it starts at the loan with the greatest interest and once that loan gets paid back, the allocation automatically starts effecting the next highest loan and so on.

If a loan ends up already getting paid back by the time the loan ahead of it is paid back, the allocation knows to skip to the next available loan. This goes on until everything is paid back.

The other ranking style is by highest interest rate. Because the loans can have different terms, the highest interest rate doesn’t always mean the most effective to payoff first. This is what makes the optimization so difficult to automate.

Finally, you will see a monthly summary of debt service with no extra payment vs. debt service with extra payment, the amount of days ahead of time you pay back all the loans, and the total savings when you do apply extra principal in this optimized way.

 

Loan schedule
Savings in loan repayments
Monthly loan payment summary

Users who purchased Multiple Loan Repayment Planning with Extra Principal Applied, also purchased:
Golf Course Financial Model – Startup
Add to wish list
Purchase Excluding 7.7% tax
Sales Pipeline Planning for Enterprise Client Base
Add to wish list
Purchase Excluding 7.7% tax
IRR (Internal Rate of Return) Modeling with Multiple Projects
Add to wish list
Purchase Excluding 7.7% tax
Industry , ,
Summary Optimize where an extra principal payment should go and see the total cash flow savings when you have multiple loans.
Screenshots / Pictures


Use Cases , , , , , , , , , , , , , , , , , ,

Write a Review

Get these templates too for a discount!

Price: $200.00

This is a collection of financial model templates for Real Estate businesses and its related sectors. The models included in this bundle are the following (all Excel models): Joint Venture / WaterFall Real Estate Financial…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $140.00

This is a bundle of financial model templates related to the Fitness and Sports Industry. To help you save money from having to buy the models separately, we collected some of our existing models that…

Add to wish list
Add to cart Excluding 7.7% tax

Price: $170.00

  This is a bundle of financial model templates for financial plan templates related to Retail Shops. The following are the financial model templates included in this product bundle: Jewelry Store Startup Financial Model Robotic…

Add to wish list
Add to cart Excluding 7.7% tax