NE39 Rowlands Gill, High Spen, Hamsterley Mill, Eastern Chopwell Wood cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £175,878
Input Equity (£43,970)
Total Input Equity (£43,970)
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 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878 £175,878
Finance Amount £131,909 £131,909 £127,968 £123,826 £119,472 £114,895 £110,084 £105,027 £99,711 £94,123 £88,250 £82,075
Monthly Mortgage   (£871) (£871) (£871) (£871) (£871) (£871) (£871) (£871) (£871) (£871) (£871)
Monthly Rental   £523 £523 £523 £523 £523 £523 £523 £523 £523 £523 £523
Yield to Purchase Price %   3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57%
Yield to Property Value %   3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57% 3.57%
Gross Monthly Cashflow   (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347)
Gross Annual Cashflow   (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166) (£4,166)
Gross Annual Expenses                        
Annual Management Expenses   (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352)
Gross Annual Cashflow less Expenses   (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480)
Vacancy Expenses                        
Net Annual Cashflow   (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480) (£4,480)
Net Yield %   (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £43,970 £43,970 £47,910 £52,052 £56,406 £60,983 £65,794 £70,851 £76,167 £81,755 £87,628 £93,803
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   (£4,518) (£577) £3,565 £7,919 £12,496 £17,306 £22,364 £27,679 £33,267 £39,141 £45,315
Return on Investment %   (10.28%) (1.31%) 8.11% 18.01% 28.42% 39.36% 50.86% 62.95% 75.66% 89.02% 103.06%
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   (£4,518) (£566) £3,424 £7,453 £11,525 £15,644 £19,811 £24,029 £28,303 £32,634 £37,026
Real Return on Investment %   (10.28%) (1.29%) 7.79% 16.95% 26.21% 35.58% 45.06% 54.65% 64.37% 74.22% 84.21%