Companion files
Subscription Lines, NAV Facilities and the Credit Behind Private Funds
These are the companion files of The Fund Finance Professional by Julian R. Sterling.The book on Amazon →
Four Excel workbooks that carry the book’s own figures, with one flagged exception, which is the most useful thing in the pack. Around them, a blank set to run your own facility, four working documents to print, forty questions that mark themselves, and three cases the book does not work. All free. Nothing is gated behind a sign-up, and no email address is asked for.
Ten workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 22 September 2026.
Read the book already? An honest review on Amazon, good or bad, is what the next reader goes on: write a review. The files stay free either way.
Reading the paperback or the Kindle edition? The same book is also sold as a DRM-free PDF: searchable, printable, yours on any device. $19.99, instant download.Buy the PDF edition → Free sample
Finished the book? Two or more PDF editions bought together are 15% off. Browse the PDF editions →
The working models behind the books, built out for live deals: the Pro models →
Practise the controller's job on one fund, step by step: the Private Fund Finance & Controllership course →
Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.
Join the reader listRun by MailerLite, off this site. How your address is used.
These carry the book’s own figures, so that every number it prints can be traced to a live formula. Download these four79 KB
Chapter 4
The Northbridge subscription facility to the decimal. Four investor groups and four levers between an uncalled commitment and a dollar of borrowing capacity — exclusions, concentration caps, advance rates, the lender’s reserve — applied in that order, because the order changes the answer. 950 million of uncalled commitment becomes 665.5 million of base value, then 650.5 after the reserve.
Then the sheet that justifies the file. The base is 650.5 and the facility is 250, so availability is 250 and 400.5 million of hard-won eligibility buys nothing. Run the chapter’s stress — the largest investor downgraded, the dollar up 8 per cent against 100 million of commitments — and the base falls 29.3 million while availability does not move by a cent. Then raise the facility until the base binds, and the same two events start costing real money.
Chapter 8
The chapter gives the case and withholds the number. Buy at 100, sell at 120 a year later: 20 per cent without a facility. Run it with a line for six months, call 102 at month six, distribute 120 at month twelve, and the chapter says the IRR is much higher and stops. It is 38.41 per cent.
And the half that usually goes missing: the money multiple falls from 1.200 to 1.176, because the interest is real and the timing is not. Investors are two dollars poorer and the headline is eighteen points better. The calculator sheet prices each point of IRR in cents of interest — and shows that the later the capital is called, the cheaper each point becomes, right up to the column where the holding period reaches zero and the formula refuses to print anything at all.
Chapters 9 and 10
800 million of reported equity NAV becomes 650 million of lending value once a restricted asset is excluded, a concentrated one is haircut and a tax reserve comes off. Nineteen per cent never reaches the lending value, and the ratio the lender runs sits 3.7 points above the one on the cover page.
Then Atlas Portfolio Fund II. Chapter 10 states that in its downside the portfolio falls to approximately 455 million, and its own three haircuts on its own three buckets give 455.3. The margin is thin: the further decline the chapter asks for leaves the loan to value at 29.3 per cent, just inside the line, and a downside 24 million lower would take it to 30.9, through it.
Appendix H · Chapters 8, 9 and 14
Chapter 8 builds the bridge from reported NAV to adjusted eligible NAV, and Chapter 9 then computes every Atlas ratio without it. Carried through the bridge on the book's own two rates — a 25 per cent concentration haircut and a tax reserve of 2.5 per cent, both from Chapter 8's worked example — each ratio moves. The base case is 21.4 per cent and not 19.4, the downside 28.6 and not 26.4, the further decline of paragraph 515 31.8 and not 29.3. The gap is a little over two points at every state, and it runs the same way at each, because a deduction can only shrink the denominator.
The test the chapter calls the most useful is the mildest one it runs. Paragraph 495 proposes minus fifteen per cent across the portfolio, no exits for eighteen months and 200 basis points of extra cost. Two pages earlier, paragraph 514 has already taken Orion down 45, Vector 30 and the rest 15. On value the combined test leaves 527.0 against 455.3 — 71.7 higher, and 3.4 points of lower loan-to-value on the covenant base.
What it breaks instead is the cash, and the chapter never separates the two. Its other two limbs are cash limbs; neither touches value. Paragraph 495 then asks whether the fund can remain compliant and repay without a forced sale, as though that were one question. Under its own test it is two, and they answer differently: the ratio stays comfortable and the recurring stream stops paying the interest.
And there is no interest rate anywhere in the book. Paragraph 483 defines coverage as receipts over cash interest and fees. Paragraph 495 adds 200 basis points to a base it never states. Chapter 12 asks a borrower to compare margins. The only cost of funds implied in three hundred pages is Chapter 7's subscription line — 120 drawn for twelve months at a cost of 8, which is 6.67 per cent, and a NAV facility prices above that, never below. So the file does not assert a rate. It inverts the question and gives the rate at which coverage reaches 1.00 times, for any recurring yield you put in. Twelve quarters, a covenant staircase placed against the book's own four states, and the hundred million of Northbridge uncalled commitment that sits outside the borrowing base, priced as if it were admitted. Fourteen controls, eight of which reproduce the book before anything is questioned.
In the borrowing-base file, set the facility to 700 million and run the stress again. A downgrade that cost nothing a moment ago now costs 29 million of availability, and nothing about the investors changed. The crossover between the two regimes is the number a treasurer should know before signing, and almost nobody computes it.
In the IRR file, walk along the calculator row by row and watch the cost of a point of headline return fall as the capital call moves later. That is not a quirk of the example. It is the shape of the arithmetic, and it points in an uncomfortable direction.
The book’s formulas with every input emptied. Type in your own investor register or portfolio; the checks sheet counts what is still missing and tests what must hold on any facility.
Chapters 3, 4, 8, 9 and 10
The borrowing base and availability, with the stress of Chapter 4, and the NAV facility underwriting, from reported NAV to the loan to value that breaches. The amber cells are the inputs. Each file ends on a checks sheet: how many inputs are still empty, then six tests that hold on any facility, such as availability being the lower of base and commitment, or the uses accounting for the whole facility.
The book’s own inputs are listed in a text file inside the archive. Type them back in and the files return 650.5, 29.3 and 400, exactly as the chapters do.
Download the blank set33 KBEight pages to print and take into a meeting. A4, with margins wide enough for US Letter.
Appendices B and G · Chapters 3 to 9
The subscription facility and NAV facility diligence checklists of Appendix B, fifty-two items with status, owner and note columns. Closing readiness and the monthly operations checklist. A borrowing-base and loan-to-value worksheet that applies the levers in the order the agreement sets. And the NAV asset review page of Template 3, with the twelve questions a credit memo must answer before it goes to committee.
Download the PDF20 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Nine on subscription lines, seven on the economics of Chapter 7, nine on NAV facilities, seven on lenders, borrowers and workouts, and eight on the three cases below. Numbers are marked to a tolerance, multiple choice to the letter, and the score sheet counts your errors part by part: that is your revision list.
Nothing is hidden. The marking sheet holds every answer, every tolerance, and the reason for each answer.
Download the question book17 KBNew material, not a restatement. Three situations the chapters name in passing and never take to a number. Each case is one workbook: the note is the first sheet, the model is the rest, and a checks sheet closes it. Type your own figures in and every finding recomputes.
Chapters 4 and 6 · Case one
The Chapter 4 base, drawn to 630 against a 650 facility, loses its largest Group A investor. The base falls by 45, not 135, because the concentration cap absorbs two thirds of the exit. Curing the 24.5 deficiency takes a capital call of 80.8: every dollar called also removes about 70 cents of collateral. And the call arrives five business days after the cure period ends.
Chapter 7 · Case two
One investment, 100 in and 150 out over five years, through a European waterfall with and without a twelve-month line. The line costs the investors 6.67 of interest and moves the carry from 3.07 to 4.88, because the preferred return runs a year less. The investors’ net IRR is 8.0 per cent in both columns; their profit falls by 8.48. The IRR the fund reports rises.
Chapter 8 · Case three
Atlas distributes 40 of its 120 facility today and repays it from exits. At 8 per cent it costs 10.39 over three years. The IRR rises only when the portfolio outgrows the rate, and falls from 0.00 to minus 0.66 per cent if exits slip. Whether the investors gain depends on their own cost of capital: 2.14 of value at 10 per cent, a loss of 2.31 at 6.
Download the three cases36 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| Checks sheet | twenty-five controls across the three files, each stating its own verdict |
Twenty-three of the twenty-five read PASS. Two are designed not to: one names the 24.3 million that does not reconcile in Chapter 10, the other names the divergence it causes. A file that had quietly picked one of the two numbers would have looked tidier and taught less.
The Fund Finance Professional develops the complete framework behind these models, with the assumptions, trade-offs and worked examples tied together.
View the book on Amazon Read the related analysisAlso as an ebook on Apple Books.
The workbooks open in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. They use no macros and no add-ins, so nothing needs to be enabled or trusted. If your spreadsheet asks to update links on opening, decline — there are none.
| 22 Sep 2026 | A blank set of two models, four working documents on eight pages, forty questions that mark themselves and three new cases. In the book’s workbooks, the check verdicts that were written in French now read in English (COVERED, MATERIAL DIVERGENCE, ACCRETIVE, yes and NO); no figure changed. |
More in private equity and funds, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: subscription line IRR calculator.
These files accompany The Fund Finance Professional. The book is on Amazon.
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.