NE63 Ashington cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £95,527
Input Equity (£23,882)
Total Input Equity (£23,882)
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 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527 £95,527
Finance Amount £71,645 £71,645 £69,505 £67,255 £64,890 £62,404 £59,791 £57,045 £54,157 £51,122 £47,932 £44,579
Monthly Mortgage   (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473)
Monthly Rental   £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Yield to Purchase Price %   5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03%
Yield to Property Value %   5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03% 5.03%
Gross Monthly Cashflow   (£73) (£73) (£73) (£73) (£73) (£73) (£73) (£73) (£73) (£73) (£73)
Gross Annual Cashflow   (£870) (£870) (£870) (£870) (£870) (£870) (£870) (£870) (£870) (£870) (£870)
Gross Annual Expenses                        
Annual Management Expenses   (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269)
Gross Annual Cashflow less Expenses   (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111)
Vacancy Expenses                        
Net Annual Cashflow   (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111)
Net Yield %   (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%) (1.16%)
Debt Coverage Ratio (1:x)   0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80
Personal Equity £23,882 £23,882 £26,022 £28,272 £30,637 £33,122 £35,736 £38,482 £41,370 £44,404 £47,595 £50,948
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,139) £1,001 £3,251 £5,615 £8,101 £10,714 £13,461 £16,348 £19,383 £22,574 £25,927
Return on Investment %   (4.77%) 4.19% 13.61% 23.51% 33.92% 44.86% 56.37% 68.46% 81.16% 94.52% 108.56%
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,139) £981 £3,122 £5,285 £7,472 £9,685 £11,924 £14,192 £16,491 £18,821 £21,184
Real Return on Investment %   (4.77%) 4.11% 13.07% 22.13% 31.29% 40.55% 49.93% 59.43% 69.05% 78.81% 88.70%