M8 Crumpsall, Cheetham Hill cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £124,589
Input Equity (£31,147)
Input Equity FX (£31,147)
Total Input Equity (£31,147)
Total Input Equity FX (£31,147)
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 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589 £124,589
Finance Amount £93,442 £93,442 £90,650 £87,716 £84,632 £81,390 £77,982 £74,399 £70,634 £66,675 £62,515 £58,141
Monthly Mortgage   (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617)
Monthly Rental   £599 £599 £599 £599 £599 £599 £599 £599 £599 £599 £599
Yield to Purchase Price %   5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77%
Yield to Property Value %   5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77%
Gross Monthly Cashflow   (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18)
Gross Annual Cashflow   (£214) (£214) (£214) (£214) (£214) (£214) (£214) (£214) (£214) (£214) (£214)
Gross Annual Expenses                        
Annual Management Expenses   (£402) (£402) (£402) (£402) (£402) (£402) (£402) (£402) (£402) (£402) (£402)
Gross Annual Cashflow less Expenses   (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573)
Vacancy Expenses                        
Net Annual Cashflow   (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573) (£573)
Net Yield %   (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%)
Debt Coverage Ratio (1:x)   0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92
Personal Equity £31,147 £31,147 £33,939 £36,873 £39,957 £43,199 £46,607 £50,190 £53,955 £57,914 £62,074 £66,448
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   (£616) £2,175 £5,109 £8,194 £11,436 £14,844 £18,426 £22,192 £26,150 £30,311 £34,685
Return on Investment %   (1.98%) 6.98% 16.40% 26.31% 36.72% 47.66% 59.16% 71.25% 83.96% 97.31% 111.36%
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   (£616) £2,132 £4,907 £7,712 £10,548 £13,418 £16,323 £19,265 £22,247 £25,272 £28,340
Real Return on Investment %   (1.98%) 6.84% 15.75% 24.76% 33.86% 43.08% 52.40% 61.85% 71.43% 81.14% 90.99%