Preset defaults
- Units: 60
- GIA per unit: 600 sqft
- NIA ratio: 78%
- Build cost: 2,650 £/sqm
- Professional fees: 12%
- Contingency: 7.5%
- s106 / CIL / BNG per unit: £14,000
- Finance rate: 9%
- Duration: 24 months
- Target PoC: 18%
What this preset is for
BTR GDV is NOI / net initial yield. Op-cost ratio 25 to 30 percent of gross rent; yield 4.25 to 5.5 percent.
Yield-based GDV
- BTR GDV = NOI / net initial yield. Op-cost ratio 25 to 30 percent of gross rent.
- London Z1-Z3 NIY: 4.25 to 4.75 percent. Manchester: 4.75 to 5.25 percent. Birmingham: 5.0 to 5.5 percent.
Profit-on-cost
- BTR PoC typically lower than build-for-sale (15 to 18 percent vs 20+).
- Lower target return justified by certainty of forward-funded exit and yield compression.
Open in workbench
Inputs
MAX LAND BID£0At 18% profit on cost, 60 units, 600 sqft GIA each.
ABORT
GDV£11,934,000
Build cost£8,862,946
Prof fees£1,063,554
s106/CIL/BNG£840,000
Contingency£807,487
Finance interest£1,041,659
Target profit£2,270,816
Total costs (excl land)£12,615,646
Senior debt @ LTGDV£7,757,100
PoC-5.4%
PoGDV-5.7%
LTC61.5%
Sensitivity (PoC %)
Build -5%Build +5%Build +10%Build +15%Build +20%
GDV -15%-16%-23%-26%-29%-32%
GDV -10%-11%-19%-22%-25%-28%
GDV -5%-6%-14%-18%-21%-24%
GDV 0%-1%-10%-13%-17%-20%
GDV +5%4%-5%-9%-13%-16%
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.