NE27 Shiremoor, West Allotment, Backworth, Holystone, Murton Village cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £150,497
Input Equity (£37,624)
Total Input Equity (£37,624)
Item On Purchase On Completion Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Property Price/Value £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497 £150,497
Finance Amount £112,873 £112,873 £109,501 £105,957 £102,231 £98,314 £94,198 £89,870 £85,322 £80,540 £75,514 £70,231
Monthly Mortgage   (£745) (£745) (£745) (£745) (£745) (£745) (£745) (£745) (£745) (£745) (£745)
Monthly Rental   £597 £597 £597 £597 £597 £597 £597 £597 £597 £597 £597
Yield to Purchase Price %   4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76%
Yield to Property Value %   4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76%
Gross Monthly Cashflow   (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148)
Gross Annual Cashflow   (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779)
Gross Annual Expenses                        
Annual Management Expenses   (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401)
Gross Annual Cashflow less Expenses   (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137)
Vacancy Expenses                        
Net Annual Cashflow   (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137) (£2,137)
Net Yield %   (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%)
Debt Coverage Ratio (1:x)   0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76
Personal Equity £37,624 £37,624 £40,996 £44,540 £48,266 £52,183 £56,299 £60,627 £65,175 £69,957 £74,983 £80,266
Effective Gearing % 75.00% 75.00% 72.76% 70.40% 67.93% 65.33% 62.59% 59.72% 56.69% 53.52% 50.18% 46.67%
Potential Profit   (£2,180) £1,192 £4,736 £8,462 £12,378 £16,495 £20,822 £25,371 £30,152 £35,178 £40,462
Return on Investment %   (5.79%) 3.17% 12.59% 22.49% 32.90% 43.84% 55.34% 67.43% 80.14% 93.50% 107.54%
Cumulative Inflation Rate %     2.00% 4.04% 6.12% 8.24% 10.41% 12.62% 14.87% 17.17% 19.51% 21.90%
Real Potential Profit   (£2,180) £1,168 £4,549 £7,964 £11,417 £14,910 £18,445 £22,025 £25,653 £29,330 £33,060
Real Return on Investment %   (5.79%) 3.10% 12.09% 21.17% 30.35% 39.63% 49.02% 58.54% 68.18% 77.95% 87.87%