Companion files · The Private Markets Career Guides

The Land Developer

Residential Land Development and Entitlements, from Raw Land to Finished Lots: Residual Land Value, Lot Sales to Homebuilders, A&D Financing and Returns.

DRM-free PDF edition, $19.99: searchable, printable, instant download.Buy the PDFFree sample

These are the companion files of the book. One workbook rebuilds the case of Brenlow Land Partners, a fictional land developer, and Wexmoor Capital, its fictional capital partner, as they option Marlwick Farm, a fictional tract of 412 acres, entitle it, develop 900 lots in three phases and sell them to two builders. It prices the land from the lot price back, lays out every quarter from the option to the last takedown, adds the acquisition and development loan and splits the result between the members. A toolkit holds the tools of Appendix B in an editable form.

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

The landA builder that sells the home for $460,000 can pay $80,600 for a finished 50-foot lot; from the lot prices back, the land is worth $21,900 a gross acre at a 20 percent return, against $22,500 agreed
The tight period$29,775,551 of project costs spent before the first lot is sold; the loan peaks at $11,539,570
The resultA profit of $17,662,272 on gross lot revenue of $70,171,490: 19.6 percent unlevered and 20.8 percent to the members on $16,360,913 of equity, before investor-level taxes and the capital partner’s own fees

The files are provided as they are, without warranty of any kind. The model is illustrative: Brenlow Land Partners, Wexmoor Capital, Marlwick Farm and the two builders are fictional, the model runs by calendar quarter with costs spread evenly over their quarters, and land prices, lot prices, costs, fees, rates and dates are the book’s assumptions, not market data, the terms or results of any real developer or builder or a forecast. Nothing here is legal, tax, accounting, engineering, lending or investment advice.