Formula
Residual land value = (GDV minus total costs minus target profit) divided by (1 + SDLT on land rate).
SDLT non-residential rates apply where bare land is bought; 5 percent additional-dwellings surcharge applies when the buyer is a company or already owns residential property. Use the SDLT line on the workbench.
Developer return
PPG-Viability Dec-2025 cites 17.5 percent profit on GDV as the working benchmark for unobjectionable schemes. Lenders typically reference 20 percent profit on cost; the two are not interchangeable.
Sensitivity matters
Run the GDV down 10 percent and build up 10 percent at once. If the deal aborts in that quadrant the residual is fragile and your land bid should fall further.
Cells show profit-on-cost percentage at each GDV stress / build-cost shock pair. Cells below your target PoC turn amber-warm; cells below 10 percent abort.