N22 Wood Green, Bounds Green, Bowes Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £523,350
Input Equity (£130,838)
Input Equity FX (£130,838)
Total Input Equity (£130,838)
Total Input Equity FX (£130,838)
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 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350 £523,350
Finance Amount £392,513 £392,513 £380,787 £368,461 £355,505 £341,886 £327,571 £312,523 £296,705 £280,077 £262,599 £244,227
Monthly Mortgage   (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590) (£2,590)
Monthly Rental   £1,358 £1,358 £1,358 £1,358 £1,358 £1,358 £1,358 £1,358 £1,358 £1,358 £1,358
Yield to Purchase Price %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Yield to Property Value %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Gross Monthly Cashflow   (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232) (£1,232)
Gross Annual Cashflow   (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790) (£14,790)
Gross Annual Expenses                        
Annual Management Expenses   (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913)
Gross Annual Cashflow less Expenses   (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605)
Vacancy Expenses                        
Net Annual Cashflow   (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605) (£15,605)
Net Yield %   (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £130,838 £130,838 £142,563 £154,889 £167,845 £181,464 £195,779 £210,827 £226,645 £243,273 £260,751 £279,123
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   (£15,703) (£3,977) £8,349 £21,305 £34,924 £49,239 £64,287 £80,105 £96,733 £114,211 £132,583
Return on Investment %   (12.00%) (3.04%) 6.38% 16.28% 26.69% 37.63% 49.14% 61.23% 73.93% 87.29% 101.33%
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   (£15,703) (£3,897) £8,018 £20,052 £32,212 £44,508 £56,948 £69,541 £82,297 £95,223 £108,330
Real Return on Investment %   (12.00%) (2.98%) 6.13% 15.33% 24.62% 34.02% 43.53% 53.15% 62.90% 72.78% 82.80%