Open calculator ↗

Loan covenant headroom by reporting period · Calculation guide

Select minimum or maximum covenant direction for the entire series.

Calculation guide

Negative headroom flags a breach; the lowest value is the tightest period.

worst = min(direction × (actual − threshold)) · period = argmin(headroom)

Inputs

Minimum covenant (1 = minimum, 0 = maximum)

Example entry 1.0. Use whole numbers.

Reported ratio

Example entry 1.4.

Required threshold

Example entry 1.2.

Worked example

InputValue
Minimum covenant (1 = minimum, 0 = maximum)1

Reporting periods in order

Reported ratioRequired threshold
1.41.2
1.11.2
ResultValue
Tightest signed headroom-0.1
First period at tightest headroom2

Interpreting the result

The most negative headroom identifies the largest covenant breach in the reporting series.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Minimum covenant (1 = minimum, 0 = maximum)10Tightest signed headroom-0.1-0.2
Reported ratio (row 1)1.40.4Tightest signed headroom-0.1-0.8
Required threshold (row 1)1.22.2Tightest signed headroom-0.1-0.8
Loan covenant headroom by reporting period →

Sources