A lender's underwriting model for a sponsor-backed unitranche: lender EBITDA, sizing, OID and exact yield, revolver, sweep and PIK toggle, covenants with headroom and cure, three scenarios, a recovery waterfall and a fair value mark, with 31 built-in checks.
Private Credit Modeling includes the Direct Lending Model, Pro Edition, plus a 32-page Course Book, an Excel workbook that checks your answers and a 160-question quiz with a final exam. For $50 more than the model alone, you learn the whole analysis behind it.
Enter the borrower's last twelve months, the add-backs you accept, the plan and the term sheet. The workbook builds the lender's EBITDA and the sources and uses, runs a six-year loan schedule with no circular reference, tests the covenants, compares Base, Downside and Stress, computes the lender's yields, the recovery in default and the expected loss, and marks the loan at fair value.
One zip file: the model with a worked example, a blank copy and a 15-page PDF user guide. Single-user license.
Secure checkout by Stripe. Want to learn the whole analysis? Private Credit Modeling, the course, includes this model ($149). The free direct lending model stays free.

Blue text on a pale yellow fill marks an input; every other cell is a formula.

Marston Applied Controls, Inc., a fictional US maker of industrial controls, bought by a sponsor at the end of FY2026. Amounts in $ millions:
| Measure | Value |
|---|---|
| Sponsor adjusted / lender EBITDA | 38.0 / 34.0 |
| Enterprise value / unitranche | 374.0 / 178.5 (5.25x) |
| Year 1 coupon / all-in spread (3-year) | 9.40% / 6.42% |
| Yield to year 3 / to maturity | 10.35% / 9.81% |
| Base: year 1 leverage and EBITDA cushion | 4.43x, 34.4% |
| Downside: year 1 leverage and cushion | 5.58x, 17.3% |
| Stress: year 1 leverage, FCCR, cure | 7.20x, 0.90x, 4.13 |
| Recovery in default / LGD / expected loss a year | 72.0% / 28.0% / 0.70% |
| Fair value after 1 year, +50 bps | 97.02% of par |

No. Interest is charged on opening balances and the revolver is sized before the sweep, so the sheet calculates in one pass: no iterative calculation, no macro, no data table.
The free model works one case of The Private Credit Investor with a fixed coupon. The Pro edition is a general tool: EBITDA bridge, SOFR floor, OID and fees with exact yields, revolver, PIK toggle, step-down covenants with cure, three scenarios run side by side, recovery, fair value and 31 checks. The free model stays free.
Yes. It uses standard functions only and was recalculated and verified cell by cell in LibreOffice. Charts may look slightly different outside Excel.
It is annual, with one term loan and one revolver. There is no delayed draw term loan, no second lien, no first out / last out split, and tax has no loss carry-forward. The guide lists every simplification.
Yes: Private Credit Modeling ($149) teaches the whole analysis on the same case and includes this model.
Yes, the blank copy is built for that. The license is single-user, the example borrower is fictional and nothing in the model is investment advice.