NG6 Bestwood Village, Bulwell, Old Basford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £118,474
Input Equity (£29,619)
Total Input Equity (£29,619)
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 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474 £118,474
Finance Amount £88,856 £88,856 £86,201 £83,411 £80,478 £77,395 £74,154 £70,748 £67,167 £63,403 £59,446 £55,287
Monthly Mortgage   (£586) (£586) (£586) (£586) (£586) (£586) (£586) (£586) (£586) (£586) (£586)
Monthly Rental   £521 £521 £521 £521 £521 £521 £521 £521 £521 £521 £521
Yield to Purchase Price %   5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28%
Yield to Property Value %   5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28% 5.28%
Gross Monthly Cashflow   (£65) (£65) (£65) (£65) (£65) (£65) (£65) (£65) (£65) (£65) (£65)
Gross Annual Cashflow   (£779) (£779) (£779) (£779) (£779) (£779) (£779) (£779) (£779) (£779) (£779)
Gross Annual Expenses                        
Annual Management Expenses   (£350) (£350) (£350) (£350) (£350) (£350) (£350) (£350) (£350) (£350) (£350)
Gross Annual Cashflow less Expenses   (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092)
Vacancy Expenses                        
Net Annual Cashflow   (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092) (£1,092)
Net Yield %   (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%) (0.92%)
Debt Coverage Ratio (1:x)   0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84
Personal Equity £29,619 £29,619 £32,273 £35,063 £37,996 £41,079 £44,320 £47,726 £51,307 £55,071 £59,028 £63,187
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   (£1,130) £1,525 £4,315 £7,248 £10,331 £13,572 £16,978 £20,559 £24,323 £28,280 £32,439
Return on Investment %   (3.81%) 5.15% 14.57% 24.47% 34.88% 45.82% 57.32% 69.41% 82.12% 95.48% 109.52%
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   (£1,130) £1,494 £4,144 £6,822 £9,529 £12,268 £15,040 £17,848 £20,693 £23,578 £26,505
Real Return on Investment %   (3.81%) 5.04% 13.99% 23.03% 32.17% 41.42% 50.78% 60.26% 69.87% 79.61% 89.49%