Companion files · The Private Markets Career Guides
How Institutions Buy, Value and Manage Farmland and Timberland: Row Crops and Cash Rent, Orchards and Water, Pine Plantations and Stumpage, Appraisals, Carbon, Fund Returns and the Career.
These are the companion files of the book. One workbook rebuilds the Merrowfield Natural Capital Fund II case: the Wapsie cash rents, crop share illustration, appraisals, farm mortgage and coverage ratios, the Calder almond crops, water balance under the pumping cap, replanting and appraisal, the Hollis Creek age classes, harvests, stumpage, valuation, depletion and carbon scenario, the marks at 30 September 2026, and the fund’s waterfall and net returns. A toolkit holds the fifteen checklists of Appendix B in an editable form.
The archive holds the workbook, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links. The workbook recalculates in Excel, LibreOffice or Google Sheets.
Chapters 6 to 16
One Inputs sheet holds every case assumption: the fund terms, the Wapsie acres, rents, values and mortgage, the Calder blocks, yields, costs, water and prices, the Hollis Creek age classes, growth curve, harvest plan and stumpage prices, the scenario switches and the other positions. One sheet per question, and a Checks sheet that puts the figures printed in the book beside the cells that compute them.
Download the workbook114 KBAppendix B
Row-crop farm data room checklist, title, survey and access checklist, farm lease review checklist, soil and productivity checklist, farmland appraisal review checklist, farm mortgage checklist, permanent crop diligence checklist, water rights and SGMA checklist, replanting decision checklist, timber cruise and inventory checklist, timber sale contract checklist, carbon project checklist, foreign ownership and AFIDA filing checklist, quarterly valuation checklist and fund reporting checklist.
Download the toolkit40 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me4 KB| Wapsie, row-crop farms | $162.95 million for 14,500 acres with a $49.0 million mortgage at 4.60 percent: an equity mark of $130.9 million, and a projected levered IRR of 4.1 percent below the unlevered 4.2 percent in the base case |
| Calder, an almond orchard | $142.0 million for 6,400 acres: 1,860 acre-feet bought in 2025 under the pumping cap, a projected IRR of 5.6 percent (2.7 percent under tight water) and a mark of $121.5 million |
| The fund at 30 September 2026 | $621.14 million called, $50.95 million distributed and $574.5 million of net asset value: a gross IRR of 2.4 percent, a net IRR of 0.2 percent, a net TVPI of 1.01x and no carry |
The files are provided as they are, without warranty of any kind. The model is illustrative: Merrowfield Natural Capital, the Wapsie farms, Calder Orchards, Hollis Creek Timberlands and the other names are fictional, the model is simplified, the rules are general and dated October 2026, and the figures are the book’s assumptions, not benchmarks. Nothing here is investment, tax or legal advice.
More in real estate, with free companion files. The full list of titles is on the author page.
Optional: join the reader list to get an email when a workbook is corrected or a new title goes up.