# The Farmland and Timberland Investor: companion files

Julian R. Sterling

## What is here

- **Farmland_Timberland_Investor_Model.xlsx**: the workbook that rebuilds the Merrowfield Natural Capital Fund II case and reproduces the figures of the book with live formulas. Sheets: Read Me, Inputs, Wapsie Rent and Income, Crop Share, Wapsie Value and Mortgage, Calder Operations, Calder Water Balance, Calder Replanting and Valuation, Hollis Creek Growth and Harvest, Hollis Creek Valuation, Depletion, Carbon Scenario, Fund Cash Flows and Waterfall, Checks.
- **Farmland_Timberland_Investor_Toolkit.docx**: the fifteen checklists of Appendix 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, fund reporting checklist), in editable form.

## Which sheet answers which chapter

- Chapter 6: Wapsie Rent and Income and Crop Share (cash rent of $305 an acre in Iowa in 2025; net operating income of $3.64 million in 2025; $265 an acre under a 50/50 crop share against $305 of cash rent)
- Chapters 7 and 8: Wapsie Value and Mortgage (appraised at $179.9 million, an equity mark of $130.9 million or 1.13x; coverage of 1.62x in 2025 against a 1.25x covenant, 1.06x under the rate stress; levered IRR 4.1 percent against 4.2 percent unlevered in the base case)
- Chapter 9: Calder Operations (13.86 million pounds at $1.70 a pound in 2022; net operating income of $9.49 million in 2025; $18.20 million of net cash to the fund from 2022 to 2025)
- Chapter 10: Calder Water Balance (pumping capped at 2.0 acre-feet an acre from 2025; 1,860 acre-feet bought in 2025; projected IRR 2.7 percent under tight water against 5.6 percent)
- Chapter 11: Calder Replanting and Valuation (900 acres replanted in 2024 at $9,000 an acre; projected IRRs of 5.6, 2.7 and 2.7 percent; a mark of $121.5 million, 0.86x cost)
- Chapter 12: Hollis Creek Growth and Harvest (681,274 tons cut in 2025; the 2024 land sale of $6.48 million; $27.52 million of cash to the fund to 30 September 2026)
- Chapter 13: Hollis Creek Valuation (projected IRR 4.7 percent, 4.4 percent with low pulpwood; a mark of $191.6 million at 5.0 percent, $1,649 an acre)
- Chapter 14: Depletion ($15.12 a ton on the merchantable pool; a simplified illustration of $10.30 million on the 2025 harvest)
- Chapter 15: Carbon Scenario (20,000 enrolled acres; a projected IRR of 4.7 percent with the project and 4.7 percent without)
- Chapter 16: Fund Cash Flows and Waterfall ($621.14 million called, $50.95 million distributed, NAV $574.5 million; gross IRR 2.4 percent, net IRR 0.2 percent, net TVPI 1.01x; no carry, $162.4 million below the preferred return)

## Two inputs to change first

1. On Inputs, switch the Calder scenario from base to tight water: watch the water bought, the projected net operating income, the income approach value, the Calder mark and the fund's net asset value move together.
2. On Inputs, switch the Hollis Creek scenario to with carbon project, then change the credit price: watch the harvest given up and the credit revenue on Carbon Scenario, and the projected IRR on Hollis Creek Valuation. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs.

Merrowfield Natural Capital, Merrowfield Natural Capital Fund II, the Wapsie farms, Calder Orchards and Hollis Creek Timberlands are fictional; the model is a simplified teaching model; tax rules, water law and other rules are general and dated October 2026; all case figures are illustrative assumptions, not benchmarks. Provided as is, without warranty. Not investment, tax or legal advice.
