Loan Amortization & Covenant Template
A full 60-month reducing-balance schedule plus a multi-year DSCR covenant Pass/Fail check built directly from it.
No sign-up or email required. Real Excel formulas, not a screenshot.
What this template does
- ✓Builds a complete monthly reducing-balance amortization schedule from a standard EMI formula.
- ✓Rolls the schedule up into loan years and checks a real DSCR covenant against a threshold you set.
What’s inside
Loan Schedule
A full monthly reducing-balance schedule (up to 60 months / 5 years) from a standard EMI formula.
Covenant Check
Rolls the monthly schedule into loan years, compares EBITDA against total debt service, and flags Pass/Fail against a minimum DSCR you set (1.25x used here as an illustrative default, not a universal rule).
Read Me
The workbook's own documentation and a link to the browser-based calculator.
How to use it
Change the loan amount, rate or tenure and the whole schedule and covenant table recalculate.
Requirements: Tenures beyond 60 months (5 years) are not supported by this template.
Want the full walkthrough?
Try the interactive version in your browser, no download needed.
Go deeper
Advanced Finance & Accounts Operations
This template is one piece of a bigger workflow. The course builds the whole thing with real datasets, step by step, with a graded assessment and a verifiable certificate.