MK14 Blakelands, Conniburrow, Downs Barn, Giffard Park, Great Linford, Linford Wood, Stantonbury, Neath Hill cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £202,800
Input Equity (£50,700)
Total Input Equity (£50,700)
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 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800 £202,800
Finance Amount £152,100 £152,100 £147,556 £142,780 £137,760 £132,482 £126,935 £121,104 £114,974 £108,531 £101,758 £94,639
Monthly Mortgage   (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004) (£1,004)
Monthly Rental   £900 £900 £900 £900 £900 £900 £900 £900 £900 £900 £900
Yield to Purchase Price %   5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32%
Yield to Property Value %   5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32% 5.32%
Gross Monthly Cashflow   (£104) (£104) (£104) (£104) (£104) (£104) (£104) (£104) (£104) (£104) (£104)
Gross Annual Cashflow   (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251) (£1,251)
Gross Annual Expenses                        
Annual Management Expenses   (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604)
Gross Annual Cashflow less Expenses   (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791)
Vacancy Expenses                        
Net Annual Cashflow   (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791) (£1,791)
Net Yield %   (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%) (0.88%)
Debt Coverage Ratio (1:x)   0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85
Personal Equity £50,700 £50,700 £55,244 £60,020 £65,040 £70,318 £75,865 £81,696 £87,826 £94,269 £101,042 £108,161
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,856) £2,688 £7,464 £12,485 £17,762 £23,309 £29,141 £35,270 £41,713 £48,486 £55,605
Return on Investment %   (3.66%) 5.30% 14.72% 24.62% 35.03% 45.98% 57.48% 69.57% 82.27% 95.63% 109.68%
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,856) £2,634 £7,169 £11,750 £16,383 £21,070 £25,814 £30,619 £35,488 £40,425 £45,434
Real Return on Investment %   (3.66%) 5.20% 14.14% 23.18% 32.31% 41.56% 50.92% 60.39% 70.00% 79.73% 89.61%