NN2 Kingsthorpe cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £247,088
Input Equity (£61,772)
Input Equity FX (£61,772)
Total Input Equity (£61,772)
Total Input Equity FX (£61,772)
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 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088 £247,088
Finance Amount £185,316 £185,316 £179,780 £173,961 £167,844 £161,414 £154,655 £147,551 £140,082 £132,232 £123,980 £115,306
Monthly Mortgage   (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223) (£1,223)
Monthly Rental   £734 £734 £734 £734 £734 £734 £734 £734 £734 £734 £734
Yield to Purchase Price %   3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56%
Yield to Property Value %   3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56%
Gross Monthly Cashflow   (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489)
Gross Annual Cashflow   (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868) (£5,868)
Gross Annual Expenses                        
Annual Management Expenses   (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493)
Gross Annual Cashflow less Expenses   (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309)
Vacancy Expenses                        
Net Annual Cashflow   (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309) (£6,309)
Net Yield %   (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £61,772 £61,772 £67,308 £73,127 £79,244 £85,674 £92,433 £99,537 £107,006 £114,856 £123,108 £131,782
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   (£6,362) (£826) £4,994 £11,110 £17,540 £24,299 £31,404 £38,872 £46,722 £54,974 £63,648
Return on Investment %   (10.30%) (1.34%) 8.08% 17.99% 28.40% 39.34% 50.84% 62.93% 75.64% 88.99% 103.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   (£6,362) (£809) £4,796 £10,457 £16,179 £21,965 £27,819 £33,746 £39,749 £45,834 £52,005
Real Return on Investment %   (10.30%) (1.31%) 7.76% 16.93% 26.19% 35.56% 45.03% 54.63% 64.35% 74.20% 84.19%