Companion files
A Practitioner’s Guide to Strategy, Track Record, Terms and Getting to First Close
These are the companion files of Raising a Real Estate Fund by Julian R. Sterling.The book on Amazon →
One Excel workbook that runs Chapter 17’s funnel on a calendar, now corrected. Around it, a blank version for your own raise, thirteen 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.
Six workbooks, the printable documents and the read-me. Each group below can also be downloaded on its own. Last revised 24 September 2026.
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 →
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.
Appendix F · Chapters 15, 17, 18 and 20
The printed funnel does not obey the rule printed beside it. Half grant a first meeting, half produce a second, half enter diligence, half reach a soft circle, two-thirds convert. Applied to 180 names those five rules give 90, 45, 22.5, 11.25 and 7.5 — not 90, 40, 22, 12 and 8. Three of the five stages depart from the rule (90 to 40, 40 to 22, 22 to 12) and the errors very nearly cancel, which is why nobody notices. But 7.5 commitments is 93,750,000 against a stated first close of 100,000,000. To close eight on the rules as worded, the screened list has to be 192 names, not 180.
The eight investors do not arrive as eight investors. Run the same funnel on a calendar and they arrive as two lumps, because soft circles wait for quarterly committees: 37,500,000 closing in month 7.6 and 56,250,000 in month 11.3. The hundred million is never reached at all. Chapter 17 computes, to the unit, that a slip from month nine to month fifteen costs 1,950,000 — and the workbook reproduces that figure exactly. It is not the cost of a delay. It is the cost of the plan.
The response to the start date is a cliff, not a slope. Beginning in week 19 through week 25 all close the same 93,750,000 by month twelve. Week 27 closes 81,250,000. Week 28 closes 75,000,000, and the first close jumps from month 6.5 to month 9.9, because the leading cohort misses a papers deadline by days and takes everything behind it along. Starting three weeks after the book’s week 22 costs nothing; six weeks costs 20 per cent. Between early May and late July, a third of the money moves on the choice of start week.
The house does not survive its own first close. The chapter’s management company costs 200,000 a month; its 100,000,000 first close at 1.5 per cent pays 125,000 — 62.5 per cent of the burn. The capital that has to close before the fee covers the cost is 160,000,000. The partners fund 2,095,312 by month twelve and 4,082,812 by month thirty-six, and the house never turns cash-positive on the first close alone.
Two rules the book never puts in the same sentence. Chapter 20 sets the first close at a quarter to a third of target; Appendix C computes break-even at full fund size. The fee at first close is charged on what has closed. A quarter-close covers the Appendix C budget only from a target of 485,714,286; a third-close only from 364,285,714. The book’s own 300,000,000 fund runs a 375,000 annual deficit, and that deficit is the committed partner capital chapter 20’s third test asks for — the number chapter 18 says a reviewer will call a thin runway.
And the fix is not the one a founder reaches for. Two constraints bind: the list and the diary. Going from six sessions a week to twelve at 180 names changes nothing. Going from 180 names to 240 at the same six a week closes 112,500,000. Sixty more names is worth more than doubling the travel. Forty checks.
Download the workbook137 KBGo to sheet 8 and read the second column downwards. Then change the start week on sheet 1 to 28 and watch sheet 4 rebuild: the leading cohort misses a papers deadline by days, waits a full quarter, and takes the whole raise with it. That single step is the chapter’s own sentence about the first of March, applied to the chapter’s own funnel. Then find the book’s cell on sheet 9 — 180 names, six a week. Move right along the row and nothing happens. Move down the column and the target is cleared.
It cannot tell you your own conversion rates, and those are the first inputs to replace. It cannot tell you whether a particular investor’s committee is monthly or quarterly — which is exactly why chapter 17 tells you to ask, in those words, when it sits and who writes the paper. And it cannot judge a strategy: a funnel that converts badly because the fund is wrong for the market looks identical, in this workbook, to one that converts badly because the list is too short. The chapter’s own test settles that one, and it is not arithmetic — if eleven investors decline for the same reason, that reason is the product.
The workbook with every input emptied. Enter your own list, conversion rates, meeting rate, stage durations, committee calendar and management company; the checks sheet counts what is still missing and tests what holds for any inputs.
Chapters 15, 17, 18 and 20 · Appendices C and F
Your screened list and five conversion rates, your ticket and first-close target, your meeting rate and the sessions each stage takes, your start week, the weeks between stages, the committee weeks of your investors and the weeks your market goes quiet, and your management company’s cost and fee. The file gives the funnel, the diary it implies, the queue week by week, the burn against the fee, the first-close rule against break-even, the cliff across thirteen start weeks and the grid of list against diary.
The book’s inputs are listed in a text file inside the archive. Type them back in and the file returns 93,750,000 closed by month twelve in two lumps, in months 7.6 and 11.3, and partners funding 2,095,312 by month twelve.
Download the blank set80 KBThirteen pages to print and use. A4, with margins wide enough for US Letter.
Chapters 2 to 20 · Appendices A and D
The strategy at three lengths with its seven elements and the capability test. The deal-by-deal track record schedule with the gross-to-net bridge and its seven presentation checks. The attribution schedule in four claims, with the reference call question by question. Bottom-up sizing, the deployment model and pipeline coverage. The house: four functions, hires on triggers, the cap table and the key person draft. The management company budget, break-even and the fee across the fund’s life.
The term sheet, term by term. The consent matrix, the allocation log, the GP commitment by source and the side letter schedule. The investor map filtered by permission, the anchor asks priced, the agent mandate. The weekly pipeline with its unflattering column and the committee calendar. The operational due diligence policy set, evidence file and runway test. The data room index, the figures file, the question log and the hard answers. The first-close tests, the equalisation lines and the Appendix A deadlines.
Download the PDF38 KBA workbook that marks itself. Answer in the yellow cells; the marking fills in as you go.
All parts of the book
Eight on what is sold and the record, six on the house and the vehicle, eight on the economics with Appendix C, six on terms, governance and alignment, eight on investors, the process and the close with Appendix F, and four 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 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.
Chapter 10 · Case one
Chapter 10 tells the manager to model “the case in which everything is realised two years later than planned” and never runs it. On its own four-asset fund, with nothing added: one year late the whole-fund carry is still 10.0; two years late it is 0.09, because the fund’s return slides to 8.01 per cent, a whisker above the hurdle. Deal by deal the manager still takes 13.0 in years 4 and 5, so the clawback is 12.9, not 3. Capped after tax, the investors are 3.87 short for good, and escrow at a quarter holds 3.25.
Chapter 6 · Case two
Chapter 6 prices two drafts of the key person clause and gives the remedy only in words: “two of the six, or one of the two founders plus one other”. At the chapter’s 5 per cent a year over five years, any one of six fires with probability 78.5 per cent; two of six, 40.9 per cent, about the risk of naming only two (40.1 per cent) while covering six people; a founder and one other, 25.7 per cent; both founders, 5.1 per cent. The threshold, not the list, sets the risk. Even at 2.3 per cent departures a year, any one of six is a coin flip.
Chapter 20 · Appendix C · Case three
Chapter 20 says the equalisation rate is “a proxy for what A gave up” and never says by how much. At cost, B takes half of any gain A carried alone: on an asset worth an ADDED 10.5 million at the second close, 150,000 moves from A to B. The 6 per cent rate is fair only if the asset rose 2 per cent in those four months. And the book pays the interest on the fee catch-up to the manager in Chapter 20 and to the early investors in Appendix C, Case 4: 7,875 that the model puts on both conventions.
Download the three cases43 KB| Amber fill | an input — you may edit these |
| Grey fill | a formula — do not overtype these |
| ASSUMPTION | an input the book does not state, each labelled with the reason |
| Checks sheet | forty controls — five exist only to reproduce the book before disagreeing with it |
Every figure is illustrative. The fund, the house and the investors are invented, as they are in the book. Every input is one the book states, except two session counts and three stage durations, which are labelled as deductions beside the sentence in the book they are deduced from.
The workbook opens in Microsoft Excel, LibreOffice Calc, Google Sheets and Numbers. It uses 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.
| 24 Sep 2026 | The book’s workbook corrected: the committee weeks and the August and December dead weeks were text that no formula read, and are now inputs every sheet uses; three of the five printed funnel steps depart from the rule, not two; the cliff needs a six-week late start, not three, to lose 20 per cent. Forty checks. Added: a blank version, thirteen working documents, forty questions that mark themselves and three new cases. The workbook can now also be downloaded on its own. |
More in real estate, with free companion files. The full list of titles is on the author page.
Also available as a standalone free template: fundraising funnel and timeline model.
Raising a Real Estate Fund 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 · Google Play ยท DRM-free PDF edition ($19.99).
These files accompany Raising a Real Estate Fund. 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.