NE35 Boldon Colliery cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £111,004
Input Equity (£27,751)
Total Input Equity (£27,751)
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 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004 £111,004
Finance Amount £83,253 £83,253 £80,766 £78,152 £75,404 £72,515 £69,479 £66,287 £62,932 £59,405 £55,698 £51,801
Monthly Mortgage   (£549) (£549) (£549) (£549) (£549) (£549) (£549) (£549) (£549) (£549) (£549)
Monthly Rental   £455 £455 £455 £455 £455 £455 £455 £455 £455 £455 £455
Yield to Purchase Price %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Yield to Property Value %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Gross Monthly Cashflow   (£95) (£95) (£95) (£95) (£95) (£95) (£95) (£95) (£95) (£95) (£95)
Gross Annual Cashflow   (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139)
Gross Annual Expenses                        
Annual Management Expenses   (£305) (£305) (£305) (£305) (£305) (£305) (£305) (£305) (£305) (£305) (£305)
Gross Annual Cashflow less Expenses   (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412)
Vacancy Expenses                        
Net Annual Cashflow   (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412) (£1,412)
Net Yield %   (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%)
Debt Coverage Ratio (1:x)   0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79
Personal Equity £27,751 £27,751 £30,238 £32,852 £35,600 £38,489 £41,525 £44,717 £48,072 £51,599 £55,306 £59,203
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   (£1,444) £1,043 £3,657 £6,405 £9,294 £12,330 £15,522 £18,877 £22,404 £26,111 £30,007
Return on Investment %   (5.20%) 3.76% 13.18% 23.08% 33.49% 44.43% 55.93% 68.02% 80.73% 94.09% 108.13%
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   (£1,444) £1,022 £3,512 £6,028 £8,572 £11,145 £13,750 £16,387 £19,060 £21,770 £24,518
Real Return on Investment %   (5.20%) 3.68% 12.66% 21.72% 30.89% 40.16% 49.55% 59.05% 68.68% 78.45% 88.35%