Click to copy
TRY THIS FIRST: A 5 MINUTE TEST ON FAKE DATA
Run units 06, 08 and 12 on this sample in chat; inputs from units not in this test are given directly below, and steps with no data here are NOT RUN. Compare your result to the answer key. If one figure does not match, stop and find out why first. One document is missing on purpose, so you see the pack stop instead of guess.
SAMPLE: Kestrel Components, fiscal year ends 31 December, October 2026, USD 000s. VARIANCE_RULE over 5% of budget and over 250.
A. Management accounts (ledger export, page 1): October revenue actual 7,850.00, budget 8,400.00. Order SO-1182 for 600.00 was in the October budget and shipped on 3 November; its delivery note dated 3 November is in the folder.
B. LTM to October (ledger export, page 2): reported EBITDA 9,600.00. Management add-backs: restructuring 900.00, sponsor monitoring fees 300.00, run-rate synergies 900.00 (from the board-approved synergy plan, all expected within 12 months). Management "adjusted EBITDA" in last month's board deck: 11,700.00.
C. Credit agreement (section 1.1 and 7.1): Consolidated EBITDA = EBITDA plus restructuring costs, sponsor fees and run-rate synergies expected within 12 months, but all add-backs together may not exceed 15% of EBITDA before add-backs. Total net debt = term loans + revolver drawn + finance leases - unrestricted cash. Maximum total net leverage 4.25x, tested quarterly.
D. Balances at 31 October (lender statement and bank statement, page 1): term loan 42,000.00, revolver drawn 3,000.00, finance leases 1,200.00, unrestricted cash 2,900.00.
E. The sponsor template asks for backlog and customer churn from the CRM. The CRM export is not in the folder.
ANSWER KEY
| Check | Expected | Working |
| Revenue variance | -550.00, -6.5%, EXPLAINED BY CONTEXT (timing) | 7,850.00 - 8,400.00. Over both thresholds, but the 600.00 order shipped 3 November with a dated delivery note. |
| Add-backs allowed | 1,440.00, not 2,100.00 | Cap 15% x 9,600.00 = 1,440.00. Claimed 2,100.00 is over the cap. |
| Covenant EBITDA | 11,040.00 | 9,600.00 + 1,440.00. Not the 11,700.00 management figure. |
| Total net debt | 43,300.00 | 42,000.00 + 3,000.00 + 1,200.00 - 2,900.00 |
| Net leverage | 3.92x, headroom 7.7%, RED | 43,300.00 / 11,040.00 = 3.92x. 1 - 3.92 / 4.25 = 7.7%. EBITDA could fall only 851.76 before a breach (11,040.00 - 43,300.00 / 4.25). |
| The trap | Reject 3.70x, 12.9%, AMBER | That uses the 11,700.00 management EBITDA. Leaving out the leases gives 3.81x, 10.3%, the second trap. |
| Tag | CHANGES THE DECISION, page one | Headroom under 10% before the quarter end test. |
| Backlog and churn | OPEN: ask for the CRM export | Blocks the KPI lines only. Every check above still runs. |
A run that reports 3.70x or AMBER, flags the revenue miss as a problem, or fills in backlog or churn, has failed.