# The Land Developer: companion files

Julian R. Sterling

## What is here

- **Land_Developer_Model.xlsx**: the workbook that rebuilds the Marlwick case and reproduces the figures of the book with live formulas. Sheets: Inputs, 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.
- **Land_Developer_Toolkit.docx**: the 6 tools of Appendix B (feasibility-period checklist; entitlement calendar template; wetlands and stormwater file; lot purchase agreement term sheet; a&D loan term sheet; takedown monitoring sheet), in editable form.

## Which sheet answers which chapter

- Chapter 3: Residual (the builder can pay $80,600 for a finished 50-foot lot; the discounted residual is $21,900 a gross acre at a 20 percent return, against $22,500 agreed)
- Chapters 10 to 12: Project (three phase budgets, the takedown calendar, the builders' deposits and the escalator)
- Chapter 14: Project (gross lot revenue of $70,171,490, a profit of $17,662,272 and an unlevered return of 19.6 percent)
- Chapter 13: Financing (equity of $16,360,913, a peak loan of $11,539,570 and a levered return of 20.8 percent)
- Chapter 15: Project (the bulk sale of the entitled land: a profit of $3,607,300) and every sheet for the stress tests
- Chapter 16: Venture (the split of $33,094,173 of distributions between Wexmoor and Brenlow)
- Appendix A: 9 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, set the entitlement period at 8 quarters: watch the last takedown, the profit and the two returns move on Project and Financing.
2. On Inputs, set the base lot prices 10 percent lower (57,600, 68,400 and 81,000): watch the profit, the returns and the peak loan. Reset the inputs afterwards: the checks compare 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. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The checks at the foot of the Venture sheet should read ALL CHECKS OK on the default inputs.

The model runs by calendar quarter, costs are spread evenly over their quarters, and returns are before investor-level taxes and the capital partner's own fees: simplifications for teaching. Brenlow Land Partners, Wexmoor Capital, Marlwick Farm and the two builders are fictional; land prices, lot prices, costs, fees, rates and dates are teaching assumptions, not market data, the terms or results of any real developer or builder, or a forecast. Provided as is, without warranty. Not legal, tax, accounting, engineering, lending or investment advice.
