A weighted scorecard in the shape agencies use, run on a fictional borrower, and why one soft year moves it a full category.
Score each credit ratio against a rating grid, weight the scores, and map the weighted average back to a letter. For an illustrative distributor with $850 million of revenue, 3.30x debt to EBITDA, 5.38x interest cover and 21.3 per cent FFO to debt, six weighted factors give a score of 4.15, an indicative BBB. The scorecard is a starting point, not a rating: it ignores business risk and financial policy, and a 15 per cent fall in EBITDA alone moves it a full category to BB.
Worked in full in Credit Analysis by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
Rating agencies publish sector methodologies in which a handful of quantitative factors, each with a weight, are scored against ranges and combined into an indicated outcome before committee judgement is applied. A credit analyst can run the same mechanics on a private borrower to answer a practical question: does this company look like an investment grade credit or a leveraged one, and how close is it to the line? The grid below is illustrative, built in the shape of an agency scorecard but not copied from any agency. Its bands are round numbers chosen to be plausible for an industrial company, and the method is the transferable part.
The borrower is fictional: a distributor with $850 million of revenue, EBITDA of $161.5 million, gross debt of $533 million at an average cost of 5.6 per cent, $60 million of depreciation and of capital expenditure, a 25 per cent tax rate, $4 million of working capital build and $16 million of dividends.
| Factor | Weight | AAA | AA | A | BBB | BB | B |
|---|---|---|---|---|---|---|---|
| Revenue, $bn | 15% | 50 | 20 | 5 | 1.5 | 0.5 | 0.2 |
| EBITDA margin | 10% | 35% | 25% | 18% | 12% | 8% | 4% |
| Debt / EBITDA, below | 25% | 0.75x | 1.5x | 2.5x | 3.5x | 4.5x | 6.0x |
| EBITDA / interest | 20% | 20x | 12x | 8x | 5x | 3x | 1.5x |
| FFO / debt | 20% | 80% | 50% | 35% | 20% | 12% | 6% |
| FCF / debt | 10% | 40% | 25% | 15% | 8% | 3% | 0% |
Anything worse than the B column scores as CCC. Each category carries a number: AAA is 1, AA is 2, A is 3, BBB is 4, BB is 5, B is 6 and CCC is 7. The weights add to 100 per cent, with leverage, coverage and cash flow carrying 75 per cent between them and scale and margin, the proxies for business risk, the remaining 25.
First compute the ratios on one consistent definition of EBITDA and debt. Cash tax is 25 per cent of EBITDA less depreciation less interest, so 17.9. FFO is EBITDA less interest less cash tax, 113.6. Free cash flow is FFO less capital expenditure, working capital and dividends, 33.6.
Factor score = number of the band the ratio falls in (1 for AAA to 7 for CCC)
Weighted score = Σ weight × factor score
Indicated category = the category whose number is nearest; a remainder above 0.17 is a minus, below −0.17 a plus
Excel, with each ratio in C, its band edges in E:J and the weight in D: =D2*(1+COUNTIF(E2:J2,">"&C2)) for a higher-is-better factor, and =D4*(1+COUNTIF(E4:J4,"<="&C4)) for leverage; sum the column.
| Factor | Ratio | Band | Score | Weight | Contribution |
|---|---|---|---|---|---|
| Revenue | $0.85bn | BB | 5 | 15% | 0.75 |
| EBITDA margin | 19.0% | A | 3 | 10% | 0.30 |
| Debt / EBITDA | 3.30x | BBB | 4 | 25% | 1.00 |
| EBITDA / interest | 5.38x | BBB | 4 | 20% | 0.80 |
| FFO / debt | 21.3% | BBB | 4 | 20% | 0.80 |
| FCF / debt | 6.3% | BB | 5 | 10% | 0.50 |
| Weighted score | BBB | 100% | 4.15 |
The weighted score is 4.15, which sits 0.15 from the BBB anchor of 4 and inside the flat band, so the indication is BBB. Read the table rather than the letter, though. Three of the four financial ratios are BBB, but none comfortably: leverage at 3.30x is 0.2 of a turn from the BB band, FFO to debt at 21.3 per cent is little more than a point above 20, and free cash flow to debt is already BB. Size drags the score down too: at $0.85 billion of revenue the company is a BB on scale whatever its ratios, which is how scorecards encode the view that a small company is more exposed to one lost customer or one bad year.
The definitions behind each ratio matter as much as the grid. Leverage here is gross debt over reported EBITDA; the choice between gross and net, and what counts as debt, is covered in how to calculate net debt to EBITDA, and the FFO line in how to calculate FFO to debt.
| Case | Debt / EBITDA | Score | Indicated |
|---|---|---|---|
| Twice the size, same ratios | 3.30x | 4.00 | BBB |
| Management EBITDA, $20m of add-backs | 2.94x | 4.05 | BBB |
| Base case | 3.30x | 4.15 | BBB |
| Debt raised to 3.51x, interest unchanged | 3.51x | 4.40 | BBB- |
| Debt-funded acquisition, +$200m debt, +$25m EBITDA | 3.93x | 4.80 | BB+ |
| EBITDA 15 per cent lower | 3.88x | 5.00 | BB |
Three lessons sit in this table. A 15 per cent fall in EBITDA, to $137.3 million, moves five factors at once, because margin, leverage, coverage and both cash flow ratios all depend on EBITDA, and the score jumps 0.85 to BB. The acquisition adds earnings and scale but still costs 0.65 of a point, because it is bought with debt at more than the company's own leverage. And the band edges create cliffs: borrowing $33.9 million more to reach 3.51x changes nothing about the business, yet it flips the heaviest factor from BBB to BB and moves the score by 0.25.
Running the scorecard on management's adjusted EBITDA flatters every ratio at once. Here $20 million of add-backs improves the score by only 0.1, because the bands are wide, but on a company sitting closer to an edge the same add-backs can be worth a whole category.
A weighted ratio scorecard turns six numbers into one defensible indication, here 4.15 and BBB, and its real value is the line-by-line view of where the credit is thin. This borrower is investment grade on paper, sub-investment grade on scale and free cash flow, and one soft year from BB. The book's own borrower, its four EBITDAs and the covenant and downside tests that follow are in the free workbooks for Credit Analysis.
There is no single threshold, because agencies set leverage bands by sector and weigh them with scale, margins and cash flow. On the illustrative industrial grid used here, debt to EBITDA below 3.5x scores BBB and below 2.5x scores A. The worked distributor at 3.30x is BBB on leverage but only 0.2 of a turn from the BB band.
You can estimate an indicated rating with a weighted scorecard of ratios, which is how agency methodologies start, but not the rating itself, which includes committee judgement on business risk, liquidity and financial policy. In the worked case the scorecard gives 4.15, an indicative BBB, for a company that is BB on scale and on free cash flow.
It depends how close each ratio sits to its band edge. In the illustrative distributor, a 15 per cent fall in EBITDA pushes leverage to 3.88x, cover to 4.58x and FFO to debt to 17.9 per cent, all BB, and the weighted score rises 0.85 to 5.00, a full category lower.
This article is one calculation from Credit Analysis. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: credit, private credit and distressed debt → · All 1501 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.