NG9 Beeston, Stapleford, Lenton Abbey, Chilwell, Trowell cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £174,217
Input Equity (£43,554)
Total Input Equity (£43,554)
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 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217 £174,217
Finance Amount £130,663 £130,663 £126,759 £122,656 £118,344 £113,810 £109,044 £104,035 £98,769 £93,234 £87,416 £81,300
Monthly Mortgage   (£862) (£862) (£862) (£862) (£862) (£862) (£862) (£862) (£862) (£862) (£862)
Monthly Rental   £625 £625 £625 £625 £625 £625 £625 £625 £625 £625 £625
Yield to Purchase Price %   4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30%
Yield to Property Value %   4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30% 4.30%
Gross Monthly Cashflow   (£238) (£238) (£238) (£238) (£238) (£238) (£238) (£238) (£238) (£238) (£238)
Gross Annual Cashflow   (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852) (£2,852)
Gross Annual Expenses                        
Annual Management Expenses   (£420) (£420) (£420) (£420) (£420) (£420) (£420) (£420) (£420) (£420) (£420)
Gross Annual Cashflow less Expenses   (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227)
Vacancy Expenses                        
Net Annual Cashflow   (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227) (£3,227)
Net Yield %   (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%) (1.85%)
Debt Coverage Ratio (1:x)   0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69
Personal Equity £43,554 £43,554 £47,458 £51,561 £55,873 £60,407 £65,173 £70,182 £75,448 £80,983 £86,801 £92,917
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   (£3,272) £631 £4,734 £9,047 £13,581 £18,346 £23,356 £28,621 £34,156 £39,975 £46,090
Return on Investment %   (7.51%) 1.45% 10.87% 20.77% 31.18% 42.12% 53.62% 65.71% 78.42% 91.78% 105.82%
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   (£3,272) £619 £4,547 £8,515 £12,527 £16,584 £20,689 £24,847 £29,059 £33,329 £37,659
Real Return on Investment %   (7.51%) 1.42% 10.44% 19.55% 28.76% 38.08% 47.50% 57.05% 66.72% 76.52% 86.47%