0 ITEMS
Compare 2 Loans with Varying Compounding Periods
Compare two loans with varying criteria and compounding periods.
|
|
| Financial Model, Financial Services, Loans |
| Debt Amortization, Debt Schedule, Debt Security, Excel, Financial Debt |
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.
Similar Products
Our customers were also interested in...
Lending Platform Financial Model (LaaS)
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (... Read more
Commercial Bank Financial Model
Commercial Banking Financial Model presents the case of a commercial bank with regulatory thresholds... Read more
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
SaaS Financial Model Bundle
A package of financial models for Software as a Service (SaaS) businesses and its related sectors in... Read more
Pawn Shop / Broker 5 Year Financial Model
Video Tutorial: https://www.youtube.com/watch?v=3mZFMB4z0Qc The model have revenue assumptions... Read more
Lending Model Startup Forecast: 10-Year Scali...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Due Diligence Tools and Methods
A suite of best practices to perform financial and commercial due diligence. Use it if you are consi... Read more
Online Bank Financial Model Excel Template
Get Online Bank Financial Model. Based on years of experience at an affordable price. The online... Read more
Bookkeeping Agency Financial Model Excel Temp...
Try Bookkeeping Agency Financial Plan. Allows you to start planning with no fuss and maximum of ... Read more
Banking Model with 3 Statements – Divid...
This is a very detailed and user-friendly Dividend Discount (DDM) and Net Asset Value (NAV) based va... Read more