0 ITEMS
Compare Loans to Bonds
In the simplest form, this financial model allows the user to measure 3 different debt facilities at once. 2 are setup for loans and 1 for bonds. This could be modified to measure more than 500 facilities at once, but that would take more time to do and require service hours of work by me.
| Financial Model, Financial Services, General Excel Financial Models, Loans & Lending Businesses |
| Amortization, Bonds, Debt Schedule, Debt Security, Excel, Financial Modeling, Financial Planning, Loans |
Video Tutorial:
Users can input all the various assumptions they want for the loans and bonds they are looking to compare. Inputs are all in one spot, and the summary is below that. Each loan/bond tab holds its own schedule, which the summary will pull from. The summary allows you to compare the differences between loan and bond interest over a given amount of time.
The loan tabs will allow you to account for late fees depending on a % or flat fee per day.
You can enter different payment amounts for a given period, and the rest of the schedule will update to stay within the terms of your inputs.
The interest rates have the ability to be variable per period, so you do have the flexibility to change that rate at any time.
The idea here is simple but clear and relevant outputs.
Similar Products
Other customers were also interested in...
Collateralized Mortgage Obligations Model
Collateralized Mortgage Obligations Model presents a simple model where mortgage backed securities a... Read more
Bundle – Business Financial Forecasting Mode...
The purpose of this Bundle of Business Forecasting and Financial Models is to assist Business Owners... Read more
Lending Platform Financial Model (LaaS)
Includes all the assumptions you need to project the gross revenues and profits of a LaaS platform (... Read more
Lending Model Startup Forecast: 10-Year Scaling &#...
This is a full 10-year startup lending business financial model, including a 3-statement model. Accu... Read more
Flat Fee Lending Business: Operating Model
10-year financial model directly built for a flat fee / fixed fee lender. Includes leverage for orig... Read more
Loan Tape Analysis / KPI Dashboard
A framework that makes it easy to drop in your loan data and automatically generate analytical insig... Read more
Investment Fund Preferred Return Tracker: Up to 30...
Track preferred returns for investors in a fund with this template. Premium joint venture tracking t... Read more
Investment Metrics to Compare Multiple Stocks / Cr...
A general set of models that come with explainers on how you derive various financial ratios from a ... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
You must log in to submit a review.