LE13 Melton Mowbray cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £161,101
Input Equity (£40,275)
Total Input Equity (£40,275)
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 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101 £161,101
Finance Amount £120,826 £120,826 £117,216 £113,422 £109,434 £105,242 £100,835 £96,203 £91,334 £86,215 £80,835 £75,180
Monthly Mortgage   (£797) (£797) (£797) (£797) (£797) (£797) (£797) (£797) (£797) (£797) (£797)
Monthly Rental   £580 £580 £580 £580 £580 £580 £580 £580 £580 £580 £580
Yield to Purchase Price %   4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32%
Yield to Property Value %   4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32%
Gross Monthly Cashflow   (£217) (£217) (£217) (£217) (£217) (£217) (£217) (£217) (£217) (£217) (£217)
Gross Annual Cashflow   (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609) (£2,609)
Gross Annual Expenses                        
Annual Management Expenses   (£390) (£390) (£390) (£390) (£390) (£390) (£390) (£390) (£390) (£390) (£390)
Gross Annual Cashflow less Expenses   (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957)
Vacancy Expenses                        
Net Annual Cashflow   (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957) (£2,957)
Net Yield %   (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%) (1.84%)
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 £40,275 £40,275 £43,885 £47,679 £51,667 £55,859 £60,266 £64,898 £69,767 £74,886 £80,266 £85,921
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,999) £610 £4,404 £8,393 £12,585 £16,992 £21,624 £26,493 £31,611 £36,991 £42,647
Return on Investment %   (7.45%) 1.52% 10.94% 20.84% 31.25% 42.19% 53.69% 65.78% 78.49% 91.85% 105.89%
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,999) £598 £4,230 £7,899 £11,608 £15,359 £19,155 £22,999 £26,894 £30,842 £34,846
Real Return on Investment %   (7.45%) 1.48% 10.50% 19.61% 28.82% 38.14% 47.56% 57.11% 66.77% 76.58% 86.52%