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, General Excel Financial Models |
| Amortization, Bonds, Debt Schedule, Debt Security, Excel, Loans |
Video Tutorial:
User can input all the various assumptions they want to 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 their own schedules where 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 ...
Accounting Financial Model Bundle
This is a combined collection of Excel and Google Sheets financial model templates for Accounting an... Read more
Preferred Equity Cash Distribution Model R...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
Inventory Valuation Using FIFO – Automa...
Any accountant that needs to comply with IFRS will have to use the FIFO valuation method for calcula... Read more
Sales Pipeline Financial Model Bundle
A collection of financial model templates in a bundle for the Sales Pipeline. Included in the bundle... Read more
Private Equity Fund Model (Investor Cashflows...
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Due Diligence P&L – Exhaustive Rev...
Model for in depth understanding of high level P&L and Revenue Analysis. Big-4 like book of due ... Read more
Fintech Financial Model Excel Template
Try Fintech Financial Projection Template. Enhance your pitch decks and impress potential investors ... Read more
Advanced Financial Model with DCF & Valu...
New Version Updates: • Model is now dynamic. Users can select the desired forecast length for up ... Read more
3 Statement Financial Modeling with DCF &...
Financial Modeling Tutorial guides user via step by step approach on how to build financial models w... Read more
Mergers and Acquisition (M&A) Financial ...
Merger and Acquisition Model template consists of an excel model which assists the user to assess th... Read more