N11 New Southgate, Friern Barnet, Bounds Green, Arnos Grove cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £535,895
Input Equity (£133,974)
Total Input Equity (£133,974)
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 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895 £535,895
Finance Amount £401,921 £401,921 £389,915 £377,294 £364,027 £350,082 £335,423 £320,014 £303,817 £286,791 £268,894 £250,082
Monthly Mortgage   (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653) (£2,653)
Monthly Rental   £1,419 £1,419 £1,419 £1,419 £1,419 £1,419 £1,419 £1,419 £1,419 £1,419 £1,419
Yield to Purchase Price %   3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18%
Yield to Property Value %   3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18%
Gross Monthly Cashflow   (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234) (£1,234)
Gross Annual Cashflow   (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804) (£14,804)
Gross Annual Expenses                        
Annual Management Expenses   (£953) (£953) (£953) (£953) (£953) (£953) (£953) (£953) (£953) (£953) (£953)
Gross Annual Cashflow less Expenses   (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655)
Vacancy Expenses                        
Net Annual Cashflow   (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655) (£15,655)
Net Yield %   (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%)
Debt Coverage Ratio (1:x)   0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51
Personal Equity £133,974 £133,974 £145,980 £158,601 £171,868 £185,813 £200,472 £215,881 £232,078 £249,104 £267,001 £285,814
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,757) (£3,751) £8,870 £22,137 £36,082 £50,741 £66,150 £82,347 £99,373 £117,270 £136,082
Return on Investment %   (11.76%) (2.80%) 6.62% 16.52% 26.93% 37.87% 49.38% 61.47% 74.17% 87.53% 101.57%
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,757) (£3,676) £8,519 £20,835 £33,281 £45,866 £58,598 £71,488 £84,543 £97,774 £111,189
Real Return on Investment %   (11.76%) (2.74%) 6.36% 15.55% 24.84% 34.24% 43.74% 53.36% 63.10% 72.98% 82.99%