NE28 Battle Hill, Willington, Wallsend, North Tyne Tunnel cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £96,903
Input Equity (£24,226)
Total Input Equity (£24,226)
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 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903 £96,903
Finance Amount £72,677 £72,677 £70,506 £68,224 £65,825 £63,303 £60,653 £57,866 £54,938 £51,859 £48,623 £45,221
Monthly Mortgage   (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480)
Monthly Rental   £480 £480 £480 £480 £480 £480 £480 £480 £480 £480 £480
Yield to Purchase Price %   5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95%
Yield to Property Value %   5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95% 5.95%
Gross Monthly Cashflow   £1 £1 £1 £1 £1 £1 £1 £1 £1 £1 £1
Gross Annual Cashflow   £9 £9 £9 £9 £9 £9 £9 £9 £9 £9 £9
Gross Annual Expenses                        
Annual Management Expenses   (£323) (£323) (£323) (£323) (£323) (£323) (£323) (£323) (£323) (£323) (£323)
Gross Annual Cashflow less Expenses   (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279)
Vacancy Expenses                        
Net Annual Cashflow   (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279)
Taxable Income   £9 £9 £9 £9 £9 £9 £9 £9 £9 £9 £9
Tax Payable                        
Net Annual Cashflow Less Tax   (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279) (£279)
Net Yield %   (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%)
Debt Coverage Ratio (1:x)   0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95
Personal Equity £24,226 £24,226 £26,397 £28,679 £31,078 £33,600 £36,250 £39,037 £41,965 £45,044 £48,280 £51,682
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   (£313) £1,858 £4,140 £6,539 £9,060 £11,711 £14,497 £17,426 £20,505 £23,741 £27,143
Return on Investment %   (1.29%) 7.67% 17.09% 26.99% 37.40% 48.34% 59.84% 71.93% 84.64% 98.00% 112.04%
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   (£313) £1,820 £3,976 £6,154 £8,357 £10,586 £12,842 £15,128 £17,445 £19,794 £22,178
Real Return on Investment %   (1.29%) 7.51% 16.41% 25.40% 34.50% 43.70% 53.01% 62.45% 72.01% 81.71% 91.55%