N18 Upper Edmonton, Edmonton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £315,444
Input Equity (£78,861)
Total Input Equity (£78,861)
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 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444 £315,444
Finance Amount £236,583 £236,583 £229,516 £222,086 £214,277 £206,069 £197,440 £188,370 £178,836 £168,814 £158,279 £147,206
Monthly Mortgage   (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561) (£1,561)
Monthly Rental   £1,146 £1,146 £1,146 £1,146 £1,146 £1,146 £1,146 £1,146 £1,146 £1,146 £1,146
Yield to Purchase Price %   4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36%
Yield to Property Value %   4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36%
Gross Monthly Cashflow   (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415)
Gross Annual Cashflow   (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985) (£4,985)
Gross Annual Expenses                        
Annual Management Expenses   (£770) (£770) (£770) (£770) (£770) (£770) (£770) (£770) (£770) (£770) (£770)
Gross Annual Cashflow less Expenses   (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672)
Vacancy Expenses                        
Net Annual Cashflow   (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672) (£5,672)
Net Yield %   (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%) (1.80%)
Debt Coverage Ratio (1:x)   0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70
Personal Equity £78,861 £78,861 £85,928 £93,358 £101,167 £109,375 £118,004 £127,074 £136,608 £146,630 £157,165 £168,238
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,755) £1,313 £8,742 £16,551 £24,760 £33,388 £42,458 £51,993 £62,014 £72,549 £83,623
Return on Investment %   (7.30%) 1.66% 11.09% 20.99% 31.40% 42.34% 53.84% 65.93% 78.64% 92.00% 106.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   (£5,755) £1,287 £8,396 £15,578 £22,838 £30,180 £37,611 £45,136 £52,760 £60,488 £68,326
Real Return on Investment %   (7.30%) 1.63% 10.65% 19.75% 28.96% 38.27% 47.69% 57.23% 66.90% 76.70% 86.64%