Calculation guide
Use contractual debt and positive qualifying EBITDA. Cash paydown reduces gross debt dollar for dollar. Equity-cure accounting is outside this model.
Inputs
Outstanding debt
Example entry 500000 (in the selected currency).
Qualifying trailing EBITDA
Example entry 100000 (in the selected currency). Minimum 0.01.
Maximum debt/EBITDA multiple
Example entry 4. Allowed range 0.0001 to 1000.
Worked example
| Input | Value |
|---|---|
| Outstanding debt | 500,000 |
| Qualifying trailing EBITDA | 100,000 |
| Maximum debt/EBITDA multiple | 4 |
| Result | Value |
|---|---|
| Principal paydown required | 100,000 |
| Permitted debt | 400,000 |
| Current debt / EBITDA | 5 |
Calculation steps
Principal paydown required = max(0, (Outstanding debt − (Qualifying trailing EBITDA × Maximum debt/EBITDA multiple)))
max(0, (500,000 − (100,000 × 4))) = 100,000
Permitted debt = (Qualifying trailing EBITDA × Maximum debt/EBITDA multiple)
(100,000 × 4) = 400,000
Current debt / EBITDA = (Outstanding debt ÷ Qualifying trailing EBITDA)
(500,000 ÷ 100,000) = 5
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Outstanding debt | 500,000 | 550,000 | Principal paydown required | 100,000 | 150,000 |
| Qualifying trailing EBITDA | 100,000 | 110,000 | Principal paydown required | 100,000 | 60,000 |
| Maximum debt/EBITDA multiple | 4 | 5 | Principal paydown required | 100,000 | 0 |
