LE3 Braunstone, Glenfield, New Parks, Groby Road (A50), Leicester Forest East, Westcotes cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £165,923
Input Equity (£41,481)
Total Input Equity (£41,481)
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 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923 £165,923
Finance Amount £124,442 £124,442 £120,725 £116,817 £112,710 £108,392 £103,853 £99,082 £94,067 £88,796 £83,255 £77,430
Monthly Mortgage   (£821) (£821) (£821) (£821) (£821) (£821) (£821) (£821) (£821) (£821) (£821)
Monthly Rental   £641 £641 £641 £641 £641 £641 £641 £641 £641 £641 £641
Yield to Purchase Price %   4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64%
Yield to Property Value %   4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64% 4.64%
Gross Monthly Cashflow   (£180) (£180) (£180) (£180) (£180) (£180) (£180) (£180) (£180) (£180) (£180)
Gross Annual Cashflow   (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161) (£2,161)
Gross Annual Expenses                        
Annual Management Expenses   (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431)
Gross Annual Cashflow less Expenses   (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545)
Vacancy Expenses                        
Net Annual Cashflow   (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545) (£2,545)
Net Yield %   (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%) (1.53%)
Debt Coverage Ratio (1:x)   0.74 0.74 0.74 0.74 0.74 0.74 0.74 0.74 0.74 0.74 0.74
Personal Equity £41,481 £41,481 £45,198 £49,106 £53,213 £57,531 £62,070 £66,841 £71,856 £77,127 £82,668 £88,493
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,591) £1,126 £5,034 £9,141 £13,459 £17,998 £22,769 £27,784 £33,055 £38,596 £44,421
Return on Investment %   (6.25%) 2.71% 12.14% 22.04% 32.45% 43.39% 54.89% 66.98% 79.69% 93.05% 107.09%
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,591) £1,104 £4,834 £8,604 £12,414 £16,269 £20,169 £24,120 £28,122 £32,180 £36,295
Real Return on Investment %   (6.25%) 2.66% 11.65% 20.74% 29.93% 39.22% 48.62% 58.15% 67.80% 77.58% 87.50%