LE4 Birstall, Belgrave, Beaumont Leys, Thurmaston cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £164,358
Input Equity (£41,090)
Total Input Equity (£41,090)
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 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358 £164,358
Finance Amount £123,269 £123,269 £119,586 £115,715 £111,646 £107,369 £102,874 £98,148 £93,180 £87,958 £82,469 £76,700
Monthly Mortgage   (£814) (£814) (£814) (£814) (£814) (£814) (£814) (£814) (£814) (£814) (£814)
Monthly Rental   £591 £591 £591 £591 £591 £591 £591 £591 £591 £591 £591
Yield to Purchase Price %   4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31%
Yield to Property Value %   4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31% 4.31%
Gross Monthly Cashflow   (£223) (£223) (£223) (£223) (£223) (£223) (£223) (£223) (£223) (£223) (£223)
Gross Annual Cashflow   (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675) (£2,675)
Gross Annual Expenses                        
Annual Management Expenses   (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397)
Gross Annual Cashflow less Expenses   (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029)
Vacancy Expenses                        
Net Annual Cashflow   (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029) (£3,029)
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 £41,090 £41,090 £44,772 £48,643 £52,712 £56,989 £61,484 £66,210 £71,178 £76,400 £81,889 £87,658
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,072) £611 £4,481 £8,550 £12,827 £17,323 £22,049 £27,017 £32,238 £37,727 £43,497
Return on Investment %   (7.48%) 1.49% 10.91% 20.81% 31.22% 42.16% 53.66% 65.75% 78.46% 91.82% 105.86%
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,072) £598 £4,304 £8,047 £11,832 £15,659 £19,532 £23,454 £27,427 £31,455 £35,540
Real Return on Investment %   (7.48%) 1.46% 10.47% 19.59% 28.79% 38.11% 47.54% 57.08% 66.75% 76.55% 86.50%