MK41 Brickhill, Clapham, De Parys, Goldington, Harpur, Newnham, Putnoe, Renhold, Salph End cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £227,382
Input Equity (£56,846)
Input Equity FX (£56,846)
Total Input Equity (£56,846)
Total Input Equity FX (£56,846)
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 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382 £227,382
Finance Amount £170,537 £170,537 £165,442 £160,087 £154,458 £148,541 £142,321 £135,783 £128,910 £121,686 £114,093 £106,110
Monthly Mortgage   (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125) (£1,125)
Monthly Rental   £866 £866 £866 £866 £866 £866 £866 £866 £866 £866 £866
Yield to Purchase Price %   4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57%
Yield to Property Value %   4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57% 4.57%
Gross Monthly Cashflow   (£259) (£259) (£259) (£259) (£259) (£259) (£259) (£259) (£259) (£259) (£259)
Gross Annual Cashflow   (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109) (£3,109)
Gross Annual Expenses                        
Annual Management Expenses   (£582) (£582) (£582) (£582) (£582) (£582) (£582) (£582) (£582) (£582) (£582)
Gross Annual Cashflow less Expenses   (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629)
Vacancy Expenses                        
Net Annual Cashflow   (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629) (£3,629)
Net Yield %   (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%) (1.60%)
Debt Coverage Ratio (1:x)   0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73
Personal Equity £56,846 £56,846 £61,940 £67,295 £72,924 £78,841 £85,061 £91,599 £98,472 £105,696 £113,289 £121,272
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,691) £1,403 £6,758 £12,387 £18,304 £24,524 £31,062 £37,935 £45,159 £52,753 £60,735
Return on Investment %   (6.49%) 2.47% 11.89% 21.79% 32.20% 43.14% 54.64% 66.73% 79.44% 92.80% 106.84%
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,691) £1,375 £6,491 £11,659 £16,883 £22,168 £27,516 £32,932 £38,419 £43,982 £49,625
Real Return on Investment %   (6.49%) 2.42% 11.42% 20.51% 29.70% 39.00% 48.41% 57.93% 67.59% 77.37% 87.30%