Debt Schedule Model

When to use

Use whenever a business carries term debt that needs a real amortization schedule, or when debt service coverage needs checking against a covenant threshold — especially replacing a model that treats debt as a flat annual interest expense with no actual principal paydown mechanics or DSCR test.

What it does

Builds a standard level-payment amortization schedule for each debt tranche via a bundled calculator (computing the interest and principal split of each year's payment as the balance pays down), sums total debt service across all tranches per year, and computes debt service coverage ratio (EBITDA divided by total debt service) against a stated minimum, flagging the specific year DSCR would breach if the projected EBITDA path doesn't keep pace with scheduled debt service.

Method

1. Build a separate amortization schedule per tranche, not one blended debt number — different tranches (a term loan, a revolver) often carry different rates and amortization periods, and blending them hides which specific tranche is driving the total debt service burden.
2. Run the bundled calculator (scripts/debt_schedule.py) to get the year-by-year interest, principal, total payment, and ending balance for each tranche using standard level-payment amortization mechanics.
3. Sum total debt service across tranches per year and compute DSCR as EBITDA divided by that total — using the projected EBITDA path, not a static current-year number, since debt service coverage needs to hold up across the life of the debt, not just today.
4. Set the minimum DSCR threshold to the actual covenant level, not a generic default, so the check reflects the real constraint the business has agreed to.
5. Read the breach-year flag as an early warning, the same discipline as covenant-headroom-monitor — a DSCR breach projected in year 3 is a problem to solve well before year 3 arrives, through refinancing, extending amortization, or improving EBITDA, not something to discover when the covenant is actually tested.
6. Check DSCR against the downside scenario, not just the base-case EBITDA path — a schedule that holds comfortably under base-case assumptions but breaches under a plausible downside is a real risk worth planning for now.
7. Revisit the schedule whenever the capital structure changes — a refinancing, a new tranche, or a prepayment all change the amortization mechanics and need to flow through a rebuilt schedule, not a patched version of the old one.