Add the margin to the base rate (or the floor), spread the OID and fees over the expected life, then check the result against the IRR of the lender's cash flows: here 9.40%, 10.32% and 10.35%.
A unitranche quoted at SOFR + 5.50% with a 2.00% OID and a 0.75% closing fee does not yield 5.50% over SOFR. With SOFR at 3.90% the year 1 cash coupon is 9.40%. Spreading the 2.75% of OID and fees over three years gives an all-in spread of 6.42% and a quick yield of 10.32%. The exact IRR of the lender's cash flows to year 3 is 10.35%.
The case comes from The Private Credit Investor and the Private Credit Modeling course by Julian R. Sterling.Get the DRM-free PDF, $19.99 →or see it on Amazon
All-in yield is the number a credit committee compares across deals, and the number a fund quotes to its investors. It is also the number most often computed three different ways on the same loan. The method below follows a single loan from the term sheet to the IRR, so each step can be checked.
| Input | Value |
|---|---|
| Lender EBITDA (sponsor's adjusted figure: 38.0) | 34.0 |
| Purchase price, 11.0x lender EBITDA | 374.0 |
| Unitranche term loan, 5.25x | 178.5 |
| Margin over SOFR / SOFR floor | 5.50% / 1.00% |
| OID / closing fee | 2.00% / 0.75% |
| Year 1 SOFR | 3.90% |
| Call protection | 102 / 101 / par |
Coupon = max(SOFR, floor) + margin
Year 1: max(3.90%, 1.00%) + 5.50% = 9.40%
In Excel: =MAX(SOFR,Floor)+Margin
The floor is out of the money at a 3.90% SOFR, so it adds nothing today. It matters when rates fall far: with SOFR at 0.50 per cent the coupon would be 6.50%, not 6.00 per cent. A floor is an option the borrower wrote to the lender; its value depends on how far below the floor the forward curve could go over the life of the loan.
Upfront economics = OID + closing fee = 2.00% + 0.75% = 2.75% of par
All-in spread = margin + upfront ÷ 3 = 5.50% + 2.75% ÷ 3 = 6.42%
Quick all-in yield = SOFR + all-in spread = 3.90% + 6.42% = 10.32%
The market divides upfront points by three because most sponsor loans are refinanced or repaid well before their six or seven-year maturity. One point of OID is worth about 33 basis points of spread on that convention; how many basis points one point of OID is worth shows why the true figure moves with the life of the loan.
A course built on one sponsored direct loan, from lender EBITDA to covenants, recovery and fair value, with Excel exercises, a 160-question quiz and the Direct Lending Model, Pro Edition included ($149).
The lender funds 178.5 at a 2.75% discount, so it pays out 173.59 on day one. It then receives interest, 1 per cent a year of amortisation and an excess cash flow sweep, and is repaid at par at the end of year 3, when the call premium has stepped down to zero.
| Date | Cash flow |
|---|---|
| Closing: 178.5 × (1 − 2.75%) | −173.59 |
| Year 1 | 22.37 |
| Year 2 | 22.74 |
| Year 3 | 180.93 |
| IRR | 10.35% |
In Excel: =IRR(range) on the flows above. The IRR is 10.35%, three basis points above the quick yield. The sweep returns principal early, which makes the fee earn over a slightly shorter life than three full years, and the coupon is paid on a balance that is falling.
Held to its sixth year, the same loan yields 9.81%. Two things pull it down: the 2.75% of upfront points is earned over six years instead of three, and the SOFR curve in the case falls from 3.90% to 3.50%. The quote the fund puts in its marketing is usually the three-year figure; the figure the investor earns if the loan stays outstanding is closer to the maturity figure.
The trap: adding the quick all-in spread to today's SOFR and calling it the yield for the life of the loan. On a floating loan the coupon resets every quarter, so any yield beyond year 1 is a forecast of the base rate, not a fact of the loan.
Free Excel template: direct lending credit model.
Every figure is computed by script from the course's running case, Marston Applied Controls, a fictional borrower, and checked on 17 November 2026. For education, not investment advice.
A course built on one sponsored direct loan, from lender EBITDA to covenants, recovery and fair value, with Excel exercises, a 160-question quiz and the Direct Lending Model, Pro Edition included ($149).
The return a lender earns once the margin, the base rate or floor, OID, upfront fees and expected repayment are combined. In the worked case, SOFR + 5.50% with 2.75 points of OID and fees gives 10.35% as the IRR to year 3.
Divide the points by the expected life. The market convention is three years, so 2.75 points of OID and fees add about 0.92% to the 5.50% margin, an all-in spread of 6.42%.
Only when SOFR is below the floor. At a 3.90% SOFR a 1.00% floor is out of the money; at 0.50% it lifts the coupon from 6.00% to 6.50%.
The upfront points are earned over six years instead of three, and the forward SOFR in the case falls from 3.90% to 3.50%: 9.81% against 10.35%.
This article is one calculation from The Private Credit Investor. 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
Prefer a PDF? The same book is sold as a DRM-free PDF edition, searchable and printable. Get the PDF edition, $19.99
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.