LE65 Ashby-de-la-Zouch, Boundary, Calke, Smisby, Willesley, Worthington cash flow analysis
Customise this data
Cash Flow Chart
Cash Flow Analysis
Transaction | Amount |
---|---|
Completion Price | £280,166 |
Input Equity | (£70,042) |
Total Input Equity | (£70,042) |
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 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 | £280,166 |
Finance Amount | £210,125 | £210,125 | £203,847 | £197,249 | £190,313 | £183,023 | £175,359 | £167,303 | £158,835 | £149,934 | £140,578 | £130,743 |
Monthly Mortgage | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | (£1,387) | |
Monthly Rental | £735 | £735 | £735 | £735 | £735 | £735 | £735 | £735 | £735 | £735 | £735 | |
Yield to Purchase Price % | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | |
Yield to Property Value % | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | 3.15% | |
Gross Monthly Cashflow | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | (£652) | |
Gross Annual Cashflow | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | (£7,821) | |
Gross Annual Expenses | ||||||||||||
Annual Management Expenses | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | (£494) | |
Gross Annual Cashflow less Expenses | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | |
Vacancy Expenses | ||||||||||||
Net Annual Cashflow | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | |
Taxable Income | ||||||||||||
Tax Payable | ||||||||||||
Net Annual Cashflow Less Tax | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | (£8,262) | |
Net Yield % | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | (2.95%) | |
Debt Coverage Ratio (1:x) | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | 0.50 | |
Personal Equity | £70,042 | £70,042 | £76,319 | £82,917 | £89,853 | £97,143 | £104,807 | £112,863 | £121,331 | £130,232 | £139,588 | £149,423 |
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 | (£8,314) | (£2,037) | £4,561 | £11,497 | £18,787 | £26,451 | £34,507 | £42,975 | £51,876 | £61,232 | £71,067 | |
Return on Investment % | (11.87%) | (2.91%) | 6.51% | 16.41% | 26.82% | 37.76% | 49.27% | 61.36% | 74.06% | 87.42% | 101.46% | |
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 | (£8,314) | (£1,997) | £4,380 | £10,821 | £17,329 | £23,910 | £30,567 | £37,307 | £44,134 | £51,052 | £58,067 | |
Real Return on Investment % | (11.87%) | (2.85%) | 6.25% | 15.45% | 24.74% | 34.14% | 43.64% | 53.26% | 63.01% | 72.89% | 82.90% |