Companion files · The Private Markets Career Guides
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 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 3 to 16, and Appendix A
An Inputs sheet holds every assumption of the case, and four sheets follow the book: Residual, Project, Financing, Venture. A block of checks at the foot of the Venture sheet puts the figures printed in the book beside the cells that compute them, and the 9 exercises of Appendix A run on it.
Download the workbook61 KBAppendix B
Feasibility-period checklist; Entitlement calendar template; Wetlands and stormwater file; Lot purchase agreement term sheet; A&D loan term sheet; Takedown monitoring sheet.
Download the toolkit41 KBRead first
What each file holds, which sheet answers which chapter, and the two inputs to change first.
Download the read-me3 KB| The land | A 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 result | A 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.