N9 Lower Edmonton, Edmonton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £321,581
Input Equity (£80,395)
Total Input Equity (£80,395)
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 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581 £321,581
Finance Amount £241,186 £241,186 £233,981 £226,407 £218,446 £210,078 £201,281 £192,035 £182,315 £172,098 £161,359 £150,069
Monthly Mortgage   (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592)
Monthly Rental   £1,188 £1,188 £1,188 £1,188 £1,188 £1,188 £1,188 £1,188 £1,188 £1,188 £1,188
Yield to Purchase Price %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Yield to Property Value %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Gross Monthly Cashflow   (£404) (£404) (£404) (£404) (£404) (£404) (£404) (£404) (£404) (£404) (£404)
Gross Annual Cashflow   (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847) (£4,847)
Gross Annual Expenses                        
Annual Management Expenses   (£798) (£798) (£798) (£798) (£798) (£798) (£798) (£798) (£798) (£798) (£798)
Gross Annual Cashflow less Expenses   (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560)
Vacancy Expenses                        
Net Annual Cashflow   (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560) (£5,560)
Net Yield %   (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%)
Debt Coverage Ratio (1:x)   0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71
Personal Equity £80,395 £80,395 £87,600 £95,174 £103,135 £111,503 £120,300 £129,546 £139,266 £149,483 £160,222 £171,512
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   (£5,646) £1,559 £9,133 £17,094 £25,462 £34,259 £43,505 £53,225 £63,442 £74,182 £85,471
Return on Investment %   (7.02%) 1.94% 11.36% 21.26% 31.67% 42.61% 54.11% 66.20% 78.91% 92.27% 106.31%
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   (£5,646) £1,528 £8,771 £16,089 £23,486 £30,967 £38,539 £46,206 £53,974 £61,849 £69,836
Real Return on Investment %   (7.02%) 1.90% 10.91% 20.01% 29.21% 38.52% 47.94% 57.47% 67.14% 76.93% 86.87%