M30 Eccles cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £158,802
Input Equity (£39,701)
Total Input Equity (£39,701)
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 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802 £158,802
Finance Amount £119,102 £119,102 £115,544 £111,804 £107,872 £103,740 £99,396 £94,830 £90,030 £84,985 £79,682 £74,107
Monthly Mortgage   (£786) (£786) (£786) (£786) (£786) (£786) (£786) (£786) (£786) (£786) (£786)
Monthly Rental   £638 £638 £638 £638 £638 £638 £638 £638 £638 £638 £638
Yield to Purchase Price %   4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82%
Yield to Property Value %   4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82% 4.82%
Gross Monthly Cashflow   (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148) (£148)
Gross Annual Cashflow   (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779) (£1,779)
Gross Annual Expenses                        
Annual Management Expenses   (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429)
Gross Annual Cashflow less Expenses   (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162)
Vacancy Expenses                        
Net Annual Cashflow   (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162) (£2,162)
Net Yield %   (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%) (1.36%)
Debt Coverage Ratio (1:x)   0.77 0.77 0.77 0.77 0.77 0.77 0.77 0.77 0.77 0.77 0.77
Personal Equity £39,701 £39,701 £43,258 £46,998 £50,930 £55,062 £59,406 £63,972 £68,772 £73,817 £79,121 £84,695
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,208) £1,350 £5,090 £9,021 £13,154 £17,498 £22,064 £26,863 £31,909 £37,212 £42,787
Return on Investment %   (5.56%) 3.40% 12.82% 22.72% 33.13% 44.07% 55.58% 67.66% 80.37% 93.73% 107.77%
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,208) £1,323 £4,888 £8,491 £12,132 £15,816 £19,545 £23,321 £27,147 £31,025 £34,960
Real Return on Investment %   (5.56%) 3.33% 12.31% 21.39% 30.56% 39.84% 49.23% 58.74% 68.38% 78.15% 88.06%