NG15 Hucknall, Ravenshead, Newstead cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £193,759
Input Equity (£48,440)
Total Input Equity (£48,440)
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 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759 £193,759
Finance Amount £145,319 £145,319 £140,978 £136,415 £131,618 £126,576 £121,276 £115,705 £109,848 £103,693 £97,222 £90,420
Monthly Mortgage   (£959) (£959) (£959) (£959) (£959) (£959) (£959) (£959) (£959) (£959) (£959)
Monthly Rental   £578 £578 £578 £578 £578 £578 £578 £578 £578 £578 £578
Yield to Purchase Price %   3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58%
Yield to Property Value %   3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58% 3.58%
Gross Monthly Cashflow   (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382)
Gross Annual Cashflow   (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579) (£4,579)
Gross Annual Expenses                        
Annual Management Expenses   (£388) (£388) (£388) (£388) (£388) (£388) (£388) (£388) (£388) (£388) (£388)
Gross Annual Cashflow less Expenses   (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925)
Vacancy Expenses                        
Net Annual Cashflow   (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925) (£4,925)
Net Yield %   (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%) (2.54%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £48,440 £48,440 £52,781 £57,344 £62,141 £67,183 £72,483 £78,054 £83,911 £90,066 £96,537 £103,339
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   (£4,967) (£625) £3,938 £8,734 £13,777 £19,077 £24,648 £30,504 £36,660 £43,131 £49,933
Return on Investment %   (10.25%) (1.29%) 8.13% 18.03% 28.44% 39.38% 50.88% 62.97% 75.68% 89.04% 103.08%
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   (£4,967) (£613) £3,782 £8,221 £12,707 £17,244 £21,834 £26,481 £31,189 £35,960 £40,799
Real Return on Investment %   (10.25%) (1.27%) 7.81% 16.97% 26.23% 35.60% 45.07% 54.67% 64.39% 74.24% 84.23%