MK40 Biddenham, Castle, De Parys, Great Denham, Harpur, Queens Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £182,598
Input Equity (£45,650)
Total Input Equity (£45,650)
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 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598 £182,598
Finance Amount £136,949 £136,949 £132,857 £128,557 £124,037 £119,285 £114,290 £109,040 £103,521 £97,720 £91,622 £85,211
Monthly Mortgage   (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904)
Monthly Rental   £752 £752 £752 £752 £752 £752 £752 £752 £752 £752 £752
Yield to Purchase Price %   4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94%
Yield to Property Value %   4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94% 4.94%
Gross Monthly Cashflow   (£152) (£152) (£152) (£152) (£152) (£152) (£152) (£152) (£152) (£152) (£152)
Gross Annual Cashflow   (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825) (£1,825)
Gross Annual Expenses                        
Annual Management Expenses   (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505)
Gross Annual Cashflow less Expenses   (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276)
Vacancy Expenses                        
Net Annual Cashflow   (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276) (£2,276)
Net Yield %   (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%) (1.25%)
Debt Coverage Ratio (1:x)   0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79
Personal Equity £45,650 £45,650 £49,741 £54,041 £58,561 £63,313 £68,308 £73,558 £79,077 £84,878 £90,976 £97,387
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   (£2,330) £1,761 £6,061 £10,582 £15,333 £20,328 £25,579 £31,097 £36,899 £42,997 £49,407
Return on Investment %   (5.10%) 3.86% 13.28% 23.18% 33.59% 44.53% 56.03% 68.12% 80.83% 94.19% 108.23%
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   (£2,330) £1,726 £5,821 £9,959 £14,143 £18,375 £22,659 £26,996 £31,392 £35,849 £40,369
Real Return on Investment %   (5.10%) 3.78% 12.75% 21.82% 30.98% 40.25% 49.64% 59.14% 68.77% 78.53% 88.43%