Companion files · The Private Markets Career Guides

The Farmland and Timberland Investor

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 workbook, the toolkit and the read-me, in one archive148 KB

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.

The files

Three numbers to reproduce first

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.

Also by Julian R. Sterling

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.