The practical conclusion so far: £2,211 must be independently supported, costs must be measured against all-in capital, and the property should produce an acceptable net return before any optimistic resale assumptions.
Thanks all. I’ve rebuilt the model to separate routine maintenance from major works and added void council tax/utilities, reletting, insurance sensitivity and all-in acquisition cost. I won’t offer until £2,211 is supported by close rental evidence and the survey is costed. If net yield before financing falls below 3%, I’ll pass.
That is a sensible decision rule. Just remember that several agent opinions repeating £2,211 are still estimates; the quality and comparability of the underlying rental examples matter more than the number of opinions.
When the survey arrives, ask which items are urgent, which are maintenance and which are merely observations. Then seek costs for the material items. Otherwise a long report can distort the model in either direction.
Your revised model should now show a normal case and a cash-reserve case. The latter answers whether you can carry a void plus a major repair without being forced into a poor financing or sale decision.
The 3% floor is clear, but don’t make vacancy the balancing figure that conveniently reaches it. Use vacancy evidence independently, then accept whatever net yield results.
Before fixing the offer ceiling, compare other Birmingham properties using the same all-in method. The alternative may not be another detached home; it should be whatever competes for the same capital and objective.
Once conservative annual net income is established, divide it by your 3% requirement to derive maximum total capital committed. Subtract expected acquisition costs and immediate work to reach a possible purchase-price ceiling.
Also consider liquidity. Even if the model clears 3%, a single £830,700 property concentrates capital and may take time to sell. That deserves compensation beyond merely avoiding negative cash flow.
Obtain the address-specific insurance indication before exchanging or otherwise becoming committed. If the quote or conditions are unexpectedly difficult, the reserve percentage won’t tell you enough.
Final thought: don’t force an owner-occupier-priced house to behave like a high-yield rental. If verified rent and realistic costs cannot support your floor, passing is a valid conclusion rather than a failure of the spreadsheet.