LN8 Market Rasen cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £235,002
Input Equity (£58,751)
Total Input Equity (£58,751)
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 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002 £235,002
Finance Amount £176,252 £176,252 £170,986 £165,452 £159,634 £153,519 £147,090 £140,333 £133,231 £125,764 £117,916 £109,666
Monthly Mortgage   (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163) (£1,163)
Monthly Rental   £612 £612 £612 £612 £612 £612 £612 £612 £612 £612 £612
Yield to Purchase Price %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Yield to Property Value %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Gross Monthly Cashflow   (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551)
Gross Annual Cashflow   (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611) (£6,611)
Gross Annual Expenses                        
Annual Management Expenses   (£411) (£411) (£411) (£411) (£411) (£411) (£411) (£411) (£411) (£411) (£411)
Gross Annual Cashflow less Expenses   (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978)
Vacancy Expenses                        
Net Annual Cashflow   (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978) (£6,978)
Net Yield %   (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%)
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 £58,751 £58,751 £64,016 £69,550 £75,368 £81,483 £87,912 £94,669 £101,771 £109,238 £117,086 £125,336
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   (£7,022) (£1,757) £3,777 £9,595 £15,711 £22,139 £28,896 £35,999 £43,465 £51,313 £59,563
Return on Investment %   (11.95%) (2.99%) 6.43% 16.33% 26.74% 37.68% 49.18% 61.27% 73.98% 87.34% 101.38%
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   (£7,022) (£1,722) £3,628 £9,031 £14,491 £20,012 £25,597 £31,251 £36,978 £42,782 £48,667
Real Return on Investment %   (11.95%) (2.93%) 6.18% 15.37% 24.67% 34.06% 43.57% 53.19% 62.94% 72.82% 82.84%