Credit analysis
Five questions every file has to answer before a ratio earns its place.
The method below is what we teach. It is not a checklist to paste onto a live customer, and it is not advice about any real borrower. Calder Joinery Ltd is a fictional teaching company.
Teaching file CJ-04
Calder Joinery Ltd, year ended 31 March 2026
A fictional joinery shop in central Scotland. The director’s letter asks for a £350,000 term loan over five years “to buy a CNC machine”, and renewal of a £150,000 overdraft. The supplier quote in the file is £248,000 for the machine and £22,000 for installation. That is £270,000. The letter does not explain the other £80,000.
| Line | 2025 | 2026 |
|---|---|---|
| Turnover | 4,410,000 | 4,820,000 |
| Gross profit | 1,499,400 | 1,494,200 |
| Gross margin | 34% | 31% |
| Operating profit | 318,000 | 286,000 |
| Depreciation | 110,000 | 126,000 |
| EBITDA, course definition | 428,000 | 412,000 |
| Interest | 64,000 | 78,000 |
| Profit before tax | 254,000 | 208,000 |
EBITDA here is operating profit plus depreciation. We make learners write that sentence every time. It is not a cash figure, and it is not a covenant definition until someone defines it.
The balance sheet has a timetable in it.
Figures below are the 2026 teaching balance sheet only. They tie to net debt of £960,000 and to a current ratio of 1.40. Prior-year balance sheet detail is withheld in the file on purpose, so you have to ask for it.
| Non-current assets | |
|---|---|
| Plant and equipment | 1,250,000 |
| Current assets | |
| Stock | 640,000 |
| Trade debtors | 951,000 |
| Cash | 110,000 |
| Total current assets | 1,701,000 |
| Total assets | 2,951,000 |
| Current liabilities | |
| Trade creditors | 310,000 |
| Tax and accruals | 245,000 |
| Overdraft | 150,000 |
| Term debt due within one year | 510,000 |
| Total current liabilities | 1,215,000 |
| Non-current liabilities | |
| Term debt | 410,000 |
| Net assets | 1,326,000 |
| Share capital and reserves | 1,326,000 |
Ratios we insist on showing in pairs.
| Measure | 2025 | 2026 | Why it is in the course |
|---|---|---|---|
| Debtor days | 54 | 72 | 951,000 / 4,820,000 × 365. The stretch absorbed roughly three hundred thousand pounds of cash. |
| Creditor days on cost of sales | 35 | 34 | Suppliers are not funding the debtor stretch. The overdraft is. |
| Net debt / EBITDA | 1.7x | 2.3x | 960,000 / 412,000. Mild, until you look at the maturity. |
| EBITDA interest cover | 6.7x | 5.3x | 412,000 / 78,000. Comfortable, and incomplete. |
| Operating profit interest cover | 5.0x | 3.7x | 286,000 / 78,000. The pair stops EBITDA from flattering the file. |
| Current ratio | — | 1.40x | 1,701,000 / 1,215,000. Fine on its face. £510,000 of it is a refinance question. |
The downside the faculty uses.
Turnover down 12% to £4,241,600. Gross margin 28%, so gross profit £1,187,648. Overheads held at the 2026 level of £1,208,200. Operating profit becomes a loss of £20,552. Add back depreciation of £126,000 and EBITDA is about £105,448. Existing interest is still £78,000. Cover is barely there before any new borrowing, and the £510,000 maturity is untouched. A learner who stops at “5.3x cover, recommend approval” has not finished the file.
Faculty illustration, not a required answer
- Support £270,000, being the quoted machine and installation, on a five-year amortising term loan. At an illustrative 8% the monthly payment is about £5,475. That illustration is arithmetic for class, not a rate we offer.
- Do not fund the unexplained £80,000.
- Hold the overdraft at £150,000. Review it if debtor days are not back under 60.
- Require a written plan for the £510,000 due within twelve months before any increase in limits.
- Take a debenture. Discuss a personal guarantee as extra support, not as the reason the cash flow works.
- Ask for monthly aged debtors until days are below 60 for two consecutive month-ends, and for the machine invoice before drawdown.
A fully argued decline also meets the marking standard. The trap is the memo that approves £350,000 because the gross margin is “still healthy”.