
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.