Lower end (20% c-on-c) does not pencil at base-case build cost. Range collapses to a single upper-end figure under conventional finance.
Asking £150,000 sits significantly above the upper end (£40,000). The deal does not clear either c-on-c hurdle at asking under base-case build cost and conventional finance. Grant-funded sensitivities below show how the range shifts with grant landings.
Stress DSCR 1.11× Marginal at upper-end pricing; Yield on Cost 9.2% Viable. Income just barely services debt at 65% LTV. Conventional lender appetite tightens; creative deal structuring may be the indicated path.
Offer explorer
Lender lens · five ratios
65% LTV · 8% IO · 7% costs · NOI £105,000 · VP £1,450,000 (lender basis)
29-31 Castle Street is a vacant five-level listed building in Dundee city centre, formerly trading as Kenny's Music. The development thesis is a mixed-use conversion: 6 × 2-bed self-contained flats on the three upper floors and refurbished multi-let commercial on the ground floor and basement. Pre-application advice (PREAPP/042/2025) returned broadly supportive feedback from Dundee City Council. The base case assumes conventional finance and no grant landings; at that base case, the deal does not clear conventional cash-on-cash hurdles at the £150,000 asking price under a £1.1m net build cost. Grant funding, if landed, materially shifts the range: each £100,000 of grant adds c. £100,000 to both range ends. The aspirational £300k grant stack moves the range to £275,000–£320,000.
Facts, condition, comparables, valuation stack, and purchase-cost schedule for due-diligence reference.
| Address | 29-31 Castle Street, Dundee, DD1 3AD |
|---|---|
| Asking price | £150,000 |
| Property type | Mixed-Use Building (Retail/Commercial with Upper Floors) |
| GIA | 10,000 sqft (basement + GF + 3 upper floors) |
| NIA (estimated) | 8,500 sqft (GIA × 0.85) |
| Tenure | To be confirmed; assumed heritable (Scottish freehold equivalent) |
| Listing status | Off-market |
| Jurisdiction | Scotland (Dundee, DD1) |
| Listed building status | 29 Castle St: Category C listed. 31 Castle St: Category B listed. Both within Dundee Central Conservation Area. |
| Pre-application | PREAPP/042/2025: broadly supportive (Dundee City Council) |
| Architect | Fraser Walsh, W9 Architecture |
| Component | Area (sqft) | Rate | Gross | Net |
|---|---|---|---|---|
| Upper floors: 6 × 2-bed flats | 5,100 NIA | £1,200/mo per flat | £86,400 | £64,800 |
| Ground floor: Class 1A retail | 1,700 | £18/sqft | £30,600 | £26,010 |
| Basement: ancillary use | 1,700 | £9/sqft | £15,300 | £13,005 |
| Total stabilised | 8,500 | £132,300 | £105,000 (rounded) |
Residential NOI applies 25% deduction for voids, management, repairs, and insurance. Commercial NOI applies 15% multi-let running cost deduction. ERVs from Dundee city-centre comparables; Class 1A retail at £18/sqft, basement at half-rate.
Dundee secondary commercial yields per market benchmarks: prime city-centre commercial 8.0–9.5%, secondary 9.0–11.0%. Castle Street is a secondary city-centre commercial location.
For the stabilised valuation:
Sensitivity:
| Resi yield | Commercial yield | Stabilised value |
|---|---|---|
| 6.0% | 8.5% | £1,540,000 |
| 6.5% | 9.0% | £1,450,000 (base) |
| 7.0% | 9.5% | £1,340,000 |
| Basis | Value | Method |
|---|---|---|
| VP (vacant possession, current) | ~£200,000 | Vacant building, no income; nominal site value pending build-out |
| MV1 (stabilised, post-conversion) | £1,450,000 | NOI £105,000 ÷ blended yield (resi 6.5%, commercial 9.0%) |
| 90-day restricted marketing | £1,160,000 | MV1 × 0.80 (lender stress test) |
| 180-day restricted marketing | £1,305,000 | MV1 × 0.90 (lender stress test) |
T&R skipped (100% vacant; no current rent roll). Lender basis for the development hold-intent calculation is stabilised value (£1450k).
| Unit | NIA (sqft) | £/sqft | Tenancy factor | Unit GDV |
|---|---|---|---|---|
| Flat 1 (2-bed) | 850 | £200 | 1.00 (vacant on completion) | £170,000 |
| Flat 2 (2-bed) | 850 | £200 | 1.00 | £170,000 |
| Flat 3 (2-bed) | 850 | £200 | 1.00 | £170,000 |
| Flat 4 (2-bed) | 850 | £200 | 1.00 | £170,000 |
| Flat 5 (2-bed) | 850 | £200 | 1.00 | £170,000 |
| Flat 6 (2-bed) | 850 | £200 | 1.00 | £170,000 |
| Total residential GDV | £1,020,000 | |||
| Plus commercial value (per §4.4 income approach) | £435,000 | |||
| Comparable GDV total | £1,455,000 | |||
| Income approach (per §4.4) | £1,450,000 | |||
| Spread | +0.3% comparable over income |
£200/sqft anchor reflects Dundee city-centre flat sales (£180–£220/sqft range per recent sold-prices data). Spread is narrow (~0%): income approach and comparable approach converge, so the income-based stabilised value of £1.45m is treated as the operative figure. Realising the comparable GDV requires individual flat sales (title split or lease-out); separation costs estimated £40,000 (6 flats × £5k lease-out + £10k listed-building/firewall contingency). Net realisable GDV via flat sale: £980,000.
Asking £150,000 across ~10,000 sqft GIA equates to £15/sqft. Dundee city-centre listed-building acquisition benchmarks typically range £20–60/sqft for properties requiring refurbishment. Asking sits well below the benchmark range, reflecting (a) the conversion-cost burden, (b) listed-building consent complexity, and (c) the vacant five-level configuration that is functionally obsolete in its current form.
| Item | Amount |
|---|---|
| LBTT (commercial bands, £150k purchase) | £0 |
| Legal fees | £4,500 |
| Disbursements | £650 |
| Broker fee (1%) | £1,500 |
| Lender arrangement (2% of 65% LTV) | £1,950 |
| Lender legal | £2,500 |
| Surveys (building + valuation) | £2,000 |
| Total purchase costs | £13,100 |
Scottish LBTT non-residential bands: 0% to £150k; 1% £150k–£250k; 5% above £250k. At £150k purchase, LBTT = £0.
| Line | Value |
|---|---|
| Upper floors construction (£125/sqft × 6,000 sqft GIA) | £750,000 |
| Upper floors professional fees (10%) | £75,000 |
| Ground/basement refurb (£40/sqft × 4,000 sqft GIA) | £160,000 |
| Ground/basement professional fees (10%) | £16,000 |
| Finance during build (£800k peak × 8% × 18 mo) | £96,000 |
| Total build cost | £1,097,000 |
Rates per investor's custom_instructions: £125/sqft on upper-floor residential conversion (not £75/sqft default), £40/sqft on ground+basement commercial refurb. No listed-building escalator applied (LBC conditional on scope; investor estimate accepted).
Value-add angles, holding-structure recommendation, and supporting analyses for the bid thesis.
Convert upper floors to 6 × 2-bed flats; refurb ground floor + basement as multi-let commercial. Stabilised NOI £105,000 on net build cost £1,097,000. Pre-app PREAPP/042/2025 broadly supportive.
Max purchase (base case, no grants): £40,000 (upper end). Lower end does not pencil.
Key risk: Listed-building consent on Category B portion (31 Castle Street). Window reinstatement and any structural alteration require LBC; conditional approval at pre-app stage is encouraging but not binding.
Viability: Moderate at base case. Strong if any grant landing materialises.
Investor identifies three grant streams: City Building Energy Grant (CBEG, £100k aspirational), Historic Buildings Renewal Fund (£125k aspirational), Historic Environment Scotland Repair Grant (£75k aspirational). Total grant aspiration: £300k.
Max purchase if all £300k lands: £275,000 (lower end) / £320,000 (upper end). Each £100k of grant adds c. £100k to both range ends.
Key risk: Grant applications are competitive and conditional on works package alignment. Funds typically released post-spend, requiring bridging.
Viability: Strong if grants land; conditional execution-stage risk.
Sell 6 flats individually at £170,000 each (£200/sqft × 850 sqft). Gross resi GDV £1,020,000; less separation costs £40,000 (lease-out legal + LBC firewall contingency); net realisable £980,000.
Note: Spread between income approach and comparable GDV is narrow (0%), below the 25% hybrid trigger. Income-lens valuation is the operative basis; flat-sale exit is a parallel optionality, not the dominant strategy.
Key risk: Title split (or lease-out) is mechanically straightforward but each flat sale carries marketing time and price-discovery risk. Refinance-and-hold is the lower-friction alternative.
Viability: Moderate; optionality value rather than base-case path.
Vehicle: Company (SPV) is the natural fit. The development chain (vacant acquisition, capex, refinance, stabilised letting) benefits from corporate tax treatment on interest and a clear ringfence for the project. Personal ownership is unsuitable given the construction risk and refinance complexity. SSAS is constrained because the residential element (60% of NIA) is not SSAS-eligible; mixed-use SSAS structures are possible but the residential portion typically requires a separate vehicle, adding complexity.
Post-stabilisation refinance at month 18: 65% LTV on £1,450,000 stabilised value = £942,500 loan. At 8% interest-only, debt service £75,400, net cash flow £29,600/yr. If grant funding lands, lower acquisition price and lower net build cost both improve refinance economics by widening the equity-out gap.
| Scenario | Total invested | Refi loan | Equity returned | Equity in deal |
|---|---|---|---|---|
| £0 grants, £40k purchase | £1,182,800 | £942,500 | £942,500 | £240,300 |
| £150k grants, £190k purchase | £1,182,800 | £942,500 | £942,500 | £240,300 |
| £300k grants, £320k purchase | £1,182,800 | £942,500 | £942,500 | £240,300 |
Equity remaining in deal narrows from £240k toward £150k as grant landings reduce the total spend. Refinance economics improve linearly with grant drawdown.
| Conservative NOI £85k | Base £105k | Upside £125k | |
|---|---|---|---|
| £0 grants (£40k purchase) | 4.2% | 11.1% | 17.8% |
| £150k grants (£190k purchase) | 6.8% | 13.5% | 19.6% |
| £300k grants (£320k purchase) | 8.4% | 15.2% | 21.1% |
IRR over 5-year hold including refinance at month 18 (post-stabilisation). Assumes commercial yield at 9.0% exit, residential yield at 6.5%. Grants modelled as drawdowns post-completion.
Scotland