N17 Tottenham, South Tottenham cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £348,613
Input Equity (£87,153)
Total Input Equity (£87,153)
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 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613 £348,613
Finance Amount £261,460 £261,460 £253,649 £245,439 £236,809 £227,737 £218,201 £208,177 £197,640 £186,565 £174,922 £162,684
Monthly Mortgage   (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726) (£1,726)
Monthly Rental   £1,214 £1,214 £1,214 £1,214 £1,214 £1,214 £1,214 £1,214 £1,214 £1,214 £1,214
Yield to Purchase Price %   4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18%
Yield to Property Value %   4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18%
Gross Monthly Cashflow   (£512) (£512) (£512) (£512) (£512) (£512) (£512) (£512) (£512) (£512) (£512)
Gross Annual Cashflow   (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138) (£6,138)
Gross Annual Expenses                        
Annual Management Expenses   (£816) (£816) (£816) (£816) (£816) (£816) (£816) (£816) (£816) (£816) (£816)
Gross Annual Cashflow less Expenses   (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867)
Vacancy Expenses                        
Net Annual Cashflow   (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867) (£6,867)
Net Yield %   (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%)
Debt Coverage Ratio (1:x)   0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
Personal Equity £87,153 £87,153 £94,964 £103,174 £111,804 £120,876 £130,412 £140,436 £150,973 £162,048 £173,691 £185,929
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   (£6,954) £856 £9,067 £17,697 £26,769 £36,305 £46,329 £56,865 £67,941 £79,583 £91,821
Return on Investment %   (7.98%) 0.98% 10.40% 20.31% 30.71% 41.66% 53.16% 65.25% 77.96% 91.31% 105.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   (£6,954) £839 £8,708 £16,656 £24,691 £32,817 £41,040 £49,366 £57,802 £66,352 £75,025
Real Return on Investment %   (7.98%) 0.96% 9.99% 19.11% 28.33% 37.65% 47.09% 56.64% 66.32% 76.13% 86.08%