Appraisal · what the £4.2m GDV has to cover
Land£1.10mBuild, professional and contingency£2.14mFinance£312kProfit£650k
The scheme
Gross development value£4,200,000
Net saleable area7,000 sq ft
GDV per sq ft, NIA£600
Build per sq ft, GIA£212
Land and acquisition£1,100,000
The funding
Senior debt£2,414,000
Junior debt£426,000
Day one equity£710,000
Peak debt£2,200,000
Programme16 months
Headroom · how close each test runs to its limit
Loan to GDVbinds
67.6%
2.4 pts under a 70% cap
Loan to cost
80.0%
5.0 pts under an 85% cap
Profit on cost
18.3%
3.3 pts over a 15% floor
Loan to GDV is the binding test here, with 2.4 points to spare, so it is the end value that decides the facility rather than the cost. Caps are not universal: across the terms we hold, senior loan to GDV runs from 60% on the high street to 75% with specialist lenders, which is what actually decides how long the lender list is.
Drawdown, sales and debt outstanding · 16 months
M1M4M8M12M16
SeniorJuniorEquitySalesDebt outstanding
Peak debt£2.20m
Sales receipts£4.20m
Debt clearedMonth 14
Programme16 months
Where the £3.55m comes from, and where it goes
Sources of funds
Senior debt£2,414,000 68.0%
Junior debt£426,000 12.0%
Equity (cash)£710,000 20.0%
Total£3,550,000
Cost breakdown
Land and acquisition£1,100,000 31.0%
Hard build costs£1,780,000 50.1%
Professional fees£178,000 5.0%
Finance costs£312,000 8.8%
Contingency£180,000 5.1%
Total£3,550,000
Return on cost, if GDV and build cost move
GDV
-5.0%-2.5%base+2.5%+5.0%
+5.0%8.5%11.3%14.1%16.9%19.7%
+2.5%10.5%13.3%16.2%19.0%21.9%
base12.5%15.4%18.3%21.2%24.1%
-2.5%14.6%17.6%20.5%23.5%26.4%
-5.0%16.8%19.8%22.8%25.8%28.8%
Build cost
GDV movement, left to right
Cost of money · £2.84m of debt, 16 months, two offers
Facility A
0.78% senior · 1.15% junior · capitalised monthly
Senior interest£166,100
Junior interest£85,500
Arrangement, 2.00%£56,800
Exit, 1.00%£28,400
Cost of money£336,800
Facility B
0.85% senior · 1.25% junior · capitalised quarterly
Senior interest£180,300
Junior interest£92,500
Arrangement, 1.25%£35,500
No exit fee£0
Cost of money£308,300
Facility A is the cheaper rate on both tranches and costs £28,500 more. It capitalises monthly rather than quarterly, and it carries an arrangement fee and an exit fee. Bars are to a common scale. The rate is the number on the term sheet; this is the number you pay.
Capital stack · who is repaid first
Second charge12% · 14.50%
Repaid bottom up. Equity is the balancing item, and the last thing out.
Funding structure against total cost
Day one£1.03m
Build£1.50m
Fees and interest£312k
Developer equity£710k
FacilityRateFee
Senior8.95%1.50%
Junior14.50%2.00%
Finance costs
Interest (rolled)£238,000
Arrangement fees£45,000
Monitoring and DD£29,000
Total£312,000