Compare 2 Loans with Varying Compounding Periods

You can do a lot with this financial model. It compares two separate loans with the option of having different compounding periods with the click of a drop-down menu, different interest rates, a given starting day that default interest begins to accrue, and more.

Compounding Periods: Simple, Daily, Monthly, Quarterly, Yearly

The idea here is to clearly show the debt of a loan and the impact to each entity. Visuals have been included to show principal balances and total interest accrued over time.

You can go out to a max of 5 years, but simply dragging the bottom row formulas lower extends the amortization schedules.

User also has the ability to enter a date and see the current principal + interest balance.

User can enter a given payment or increase in the loan at any date and the principal / interest basis will adjust accordingly.

The primary use of of this tool is going to be to compare facilities where regular payments are not made, but rather interest accrues and payments may be made throughout the life of the facility.

 

Users who purchased Compare 2 Loans with Varying Compounding Periods, also purchased:
Start Up Hydro Dam Excel Model and Valuation
Add to wish list
Purchase Excluding 7.7% tax
Excel Calculator: Invest Now or Pay Off Debt
Add to wish list
Purchase Excluding 7.7% tax
Private Equity – Leveraged Buyout Model
Add to wish list
Purchase Excluding 7.7% tax
Industry , ,
Summary Compare two loans with varying criteria and compounding periods.
Screenshots / Pictures

Use Cases , , , ,

Write a Review

Get these templates too for a discount!

Price: $225.00

This is a combined collection of Excel and Google Sheets financial model templates for Accounting and related uses, such as: tracking, inventory management, budget vs. actual, break-even analysis, payment schedule, P&L tracker, etc. The bundle…

Add to wish list
Add to cart Excluding 7.7% tax

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

Starting at: $99.00

I have added all the industry specific financial models all into one bundled package. Included Models: 1. Mining Operation 2. Apple Orchard 3. Hospital 4. E-Commerce (Amazon specific) 5. Real Estate (with Join Venture capability)

Add to wish list
Add to cart Excluding 7.7% tax