MK12 Greenleys, Hodge Lea, Old Wolverton, Stacey Bushes, Wolverton, Wolverton Mill cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £212,780
Input Equity (£53,195)
Total Input Equity (£53,195)
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 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780 £212,780
Finance Amount £159,585 £159,585 £154,818 £149,806 £144,539 £139,002 £133,181 £127,063 £120,632 £113,872 £106,766 £99,296
Monthly Mortgage   (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053) (£1,053)
Monthly Rental   £841 £841 £841 £841 £841 £841 £841 £841 £841 £841 £841
Yield to Purchase Price %   4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74%
Yield to Property Value %   4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74%
Gross Monthly Cashflow   (£212) (£212) (£212) (£212) (£212) (£212) (£212) (£212) (£212) (£212) (£212)
Gross Annual Cashflow   (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548) (£2,548)
Gross Annual Expenses                        
Annual Management Expenses   (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565)
Gross Annual Cashflow less Expenses   (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052)
Vacancy Expenses                        
Net Annual Cashflow   (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052) (£3,052)
Net Yield %   (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%) (1.43%)
Debt Coverage Ratio (1:x)   0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76
Personal Equity £53,195 £53,195 £57,962 £62,974 £68,241 £73,778 £79,599 £85,717 £92,148 £98,908 £106,014 £113,484
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,113) £1,655 £6,666 £11,933 £17,470 £23,291 £29,409 £35,840 £42,600 £49,706 £57,176
Return on Investment %   (5.85%) 3.11% 12.53% 22.43% 32.84% 43.78% 55.29% 67.37% 80.08% 93.44% 107.48%
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,113) £1,621 £6,402 £11,232 £16,114 £21,053 £26,052 £31,114 £36,243 £41,443 £46,717
Real Return on Investment %   (5.85%) 3.05% 12.03% 21.11% 30.29% 39.58% 48.97% 58.49% 68.13% 77.91% 87.82%