Articles

How to calculate the all-in yield on a unitranche loan

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.

The case

The running case: Marston Applied Controls, Inc. (fictional), $m.
InputValue
Lender EBITDA (sponsor's adjusted figure: 38.0)34.0
Purchase price, 11.0x lender EBITDA374.0
Unitranche term loan, 5.25x178.5
Margin over SOFR / SOFR floor5.50% / 1.00%
OID / closing fee2.00% / 0.75%
Year 1 SOFR3.90%
Call protection102 / 101 / par

Step 1: the cash coupon, with the floor

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.

Step 2: the all-in spread under the three-year convention

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.

Module 4 of the course works this whole calculation, free

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).

Try module 4 and ten quiz questions, free →

Step 3: the exact yield, as the IRR of the lender's cash flows

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.

Lender cash flows on the term loan, base case, $m. Repayment at the end of year 3.
DateCash flow
Closing: 178.5 × (1 − 2.75%)−173.59
Year 122.37
Year 222.74
Year 3180.93
IRR10.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.

Step 4: yield to maturity, and why it is lower

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.

What else moves the all-in yield

Takeaway

Free Excel template: direct lending credit model.

Sources

  1. Julian R. Sterling, Private Credit Modeling (course, 2026): running case Marston Applied Controls
  2. Julian R. Sterling, The Private Credit Investor
  3. Free direct lending credit model (Excel)

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.

Learn the whole method: Private Credit Modeling

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).

Try module 4 and ten quiz questions, free →

Questions readers ask

What is the all-in yield on a loan?

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.

How do you convert OID into spread?

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%.

Does a SOFR floor change the yield?

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%.

Why is the yield to maturity lower than the yield to three years?

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%.

Read the whole case

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.

Also on this site

All 1908 articles →