NE22 Bedlington, Hartford Bridge cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £123,618
Input Equity (£30,905)
Input Equity FX (£30,905)
Total Input Equity (£30,905)
Total Input Equity FX (£30,905)
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 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618 £123,618
Finance Amount £92,714 £92,714 £89,944 £87,033 £83,972 £80,755 £77,374 £73,819 £70,083 £66,156 £62,027 £57,688
Monthly Mortgage   (£612) (£612) (£612) (£612) (£612) (£612) (£612) (£612) (£612) (£612) (£612)
Monthly Rental   £430 £430 £430 £430 £430 £430 £430 £430 £430 £430 £430
Yield to Purchase Price %   4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17%
Yield to Property Value %   4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17%
Gross Monthly Cashflow   (£182) (£182) (£182) (£182) (£182) (£182) (£182) (£182) (£182) (£182) (£182)
Gross Annual Cashflow   (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186) (£2,186)
Gross Annual Expenses                        
Annual Management Expenses   (£289) (£289) (£289) (£289) (£289) (£289) (£289) (£289) (£289) (£289) (£289)
Gross Annual Cashflow less Expenses   (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444)
Vacancy Expenses                        
Net Annual Cashflow   (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444) (£2,444)
Net Yield %   (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%)
Debt Coverage Ratio (1:x)   0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
Personal Equity £30,905 £30,905 £33,674 £36,585 £39,646 £42,863 £46,244 £49,799 £53,535 £57,462 £61,591 £65,930
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,475) £295 £3,206 £6,266 £9,483 £12,865 £16,419 £20,156 £24,083 £28,211 £32,551
Return on Investment %   (8.01%) 0.95% 10.37% 20.28% 30.69% 41.63% 53.13% 65.22% 77.93% 91.29% 105.33%
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,475) £289 £3,079 £5,898 £8,747 £11,629 £14,545 £17,498 £20,489 £23,521 £26,597
Real Return on Investment %   (8.01%) 0.94% 9.96% 19.08% 28.30% 37.63% 47.06% 56.62% 66.30% 76.11% 86.06%