Every figure on these screens is extracted programmatically from the workbook itself — nothing re-typed, nothing asserted.
Twenty-nine screens: the place and the lots, the prices and what they cost, when the cash actually arrives, how it was financed, what could go wrong — and the result. Then how it was built.
Fourteen buildings and a kindergarten, opened in the order the site and the market allow — each start a separate financing decision.
Each lot opens at a launch price and steps up tranche by tranche — the ladder is priced, never a flat average.
Where each lot sits in the build sequence — and what it is.
From the average sale price down to what the project keeps. Land at $260 per m² of plot is the structural edge; everything else is execution.
Development costs ex-VAT, then the land — the plot plus the city's in-kind share.
Two kinds of capital, each used for what it does best.
The four shocks that matter: a market-wide price cut, the late premium never materialising, construction inflation, and a year lost to slow absorption.
One hundred and eight months, six lots, two lenders and a buffer — reduced to the number a shareholder asks for first.
A 24-sheet workbook where market evidence enters at one end and a monthly cash position leaves at the other.
What this model was built with. Named plainly, because the craft is the point.
Lots 6 and 5, costed bottom-up from building budgets. Each tranche: area sold at that price, and its sales window.
Lots 3, 4 and 1, parametric until their architecture is fixed. Lot 2 is the kindergarten, sold as one block.