Eight skills, in the order a direct lending analyst uses them on a live deal, each practised on the same sponsored loan.
To learn private credit modeling, work one sponsored direct loan from start to finish in eight steps: rebuild lender EBITDA, size the debt, price it, build the annual loan model, test the covenants, stress the credit and run recovery, value the loan, and walk the loan yield to the fund's net return. Most analysts can do it in four to eight hours of focused work on a single case.
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
Most modeling material teaches the buyer's side of a buyout. A lender asks different questions: how much of the EBITDA is real, how much debt it carries, what the loan really yields, when the covenants bite and what comes back if it goes wrong. The order below is the order of a credit memo, and each step uses the output of the one before.
The running case is a fictional US maker of industrial controls bought by a sponsor for 374.0m, financed with a 178.5m unitranche at 5.25x and 47.7% LTV.
Start from the sponsor's adjusted figure and decide, add-back by add-back, what the lender accepts. In the case 38.0 becomes 34.0. Everything after this step is a multiple of that number.
Practise: what an add-back bridge is actually worth.
Turn leverage, interest cover, fixed charge cover and LTV limits into dollar caps and keep the lowest: 178.5, 180.9, 208.2 and 187.0, so leverage binds at 178.5.
Practise: loan to value in direct lending.
Floor, margin, OID, fees, call protection and PIK, into a coupon (9.40%), an all-in spread (6.42%) and an exact IRR (10.35%).
Practise: the unitranche all-in yield.
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).
An annual schedule from cash flow available for debt service to closing balances: amortisation, a cash sweep, revolver draws and repayments, interest on opening balances so there is no circular reference.
Practise: the free direct lending model.
Leverage and fixed charge cover each year, the EBITDA cushion (34.4% in year 1 of the base case, 17.3% in the downside) and the equity cure a breach would need.
Practise: the fixed charge coverage ratio.
A coherent downside and stress case, enterprise value in default, the waterfall and expected loss: 72.0% recovery and 0.70% a year of expected loss in the case.
Practise: the loss rate in private credit.
Fair value by the yield method, Level 3: calibrate to the entry yield, then mark for spread moves. A 50 bp widening takes the loan to 97.02% of par.
Practise: how to fair value a private credit loan.
Leverage, fees, carry, expenses and losses between the loan and the investor: a 10.35% loan becomes a 8.97% net fund return.
Practise: how much leverage adds to private credit returns.
The trap: learning the formulas one by one, on unrelated examples. A lender's model is a chain, and the skill is in the links: the EBITDA you accept decides the sizing, the sizing decides the coupon burden, and the coupon burden decides when the covenants bite.
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).
With basic Excel and a first idea of EBITDA, most learners need four to eight hours on one complete case: thirty minutes to an hour per skill, then a timed test. Speed comes from repeating the same case, not from more cases.
No. It helps to know how a buyout is financed, but the lender's model is simpler on equity and deeper on the debt: sizing, pricing, covenants, recovery and valuation.
MAX and MIN for floors and caps, IRR and NPV for yields and fair value, and a clean annual layout with interest on opening balances so the cash sweep needs no circular reference.
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.