NE10 Felling, Leam Lane, Pelaw cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £103,260
Input Equity (£25,815)
Total Input Equity (£25,815)
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 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260 £103,260
Finance Amount £77,445 £77,445 £75,131 £72,700 £70,143 £67,456 £64,632 £61,663 £58,542 £55,261 £51,812 £48,187
Monthly Mortgage   (£511) (£511) (£511) (£511) (£511) (£511) (£511) (£511) (£511) (£511) (£511)
Monthly Rental   £491 £491 £491 £491 £491 £491 £491 £491 £491 £491 £491
Yield to Purchase Price %   5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70%
Yield to Property Value %   5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70% 5.70%
Gross Monthly Cashflow   (£20) (£20) (£20) (£20) (£20) (£20) (£20) (£20) (£20) (£20) (£20)
Gross Annual Cashflow   (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243)
Gross Annual Expenses                        
Annual Management Expenses   (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330)
Gross Annual Cashflow less Expenses   (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538)
Vacancy Expenses                        
Net Annual Cashflow   (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538)
Net Yield %   (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%)
Debt Coverage Ratio (1:x)   0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91
Personal Equity £25,815 £25,815 £28,129 £30,560 £33,117 £35,804 £38,628 £41,597 £44,718 £47,999 £51,448 £55,073
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   (£573) £1,740 £4,172 £6,729 £9,416 £12,240 £15,209 £18,330 £21,611 £25,059 £28,684
Return on Investment %   (2.22%) 6.74% 16.16% 26.06% 36.47% 47.42% 58.92% 71.01% 83.71% 97.07% 111.12%
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   (£573) £1,706 £4,007 £6,333 £8,685 £11,064 £13,473 £15,913 £18,386 £20,893 £23,437
Real Return on Investment %   (2.22%) 6.61% 15.52% 24.53% 33.64% 42.86% 52.19% 61.64% 71.22% 80.93% 90.79%