N19 Upper Holloway, Archway, Tufnell Park, Hornsey cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £601,009
Input Equity (£150,252)
Total Input Equity (£150,252)
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 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009 £601,009
Finance Amount £450,757 £450,757 £437,291 £423,137 £408,258 £392,618 £376,178 £358,897 £340,732 £321,638 £301,566 £280,468
Monthly Mortgage   (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975) (£2,975)
Monthly Rental   £1,676 £1,676 £1,676 £1,676 £1,676 £1,676 £1,676 £1,676 £1,676 £1,676 £1,676
Yield to Purchase Price %   3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35%
Yield to Property Value %   3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35% 3.35%
Gross Monthly Cashflow   (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299) (£1,299)
Gross Annual Cashflow   (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590) (£15,590)
Gross Annual Expenses                        
Annual Management Expenses   (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126) (£1,126)
Gross Annual Cashflow less Expenses   (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595)
Vacancy Expenses                        
Net Annual Cashflow   (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595) (£16,595)
Net Yield %   (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%) (2.76%)
Debt Coverage Ratio (1:x)   0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54
Personal Equity £150,252 £150,252 £163,718 £177,872 £192,751 £208,391 £224,831 £242,112 £260,277 £279,371 £299,443 £320,541
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   (£16,716) (£3,250) £10,904 £25,783 £41,423 £57,863 £75,144 £93,309 £112,403 £132,475 £153,573
Return on Investment %   (11.13%) (2.16%) 7.26% 17.16% 27.57% 38.51% 50.01% 62.10% 74.81% 88.17% 102.21%
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   (£16,716) (£3,185) £10,472 £24,267 £38,207 £52,303 £66,565 £81,004 £95,629 £110,451 £125,481
Real Return on Investment %   (11.13%) (2.12%) 6.97% 16.15% 25.43% 34.81% 44.30% 53.91% 63.65% 73.51% 83.51%