LE19 Narborough, Enderby cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £216,554
Input Equity (£54,139)
Total Input Equity (£54,139)
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 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554 £216,554
Finance Amount £162,416 £162,416 £157,564 £152,464 £147,103 £141,467 £135,544 £129,317 £122,772 £115,892 £108,660 £101,057
Monthly Mortgage   (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072) (£1,072)
Monthly Rental   £719 £719 £719 £719 £719 £719 £719 £719 £719 £719 £719
Yield to Purchase Price %   3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98%
Yield to Property Value %   3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98%
Gross Monthly Cashflow   (£353) (£353) (£353) (£353) (£353) (£353) (£353) (£353) (£353) (£353) (£353)
Gross Annual Cashflow   (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239) (£4,239)
Gross Annual Expenses                        
Annual Management Expenses   (£483) (£483) (£483) (£483) (£483) (£483) (£483) (£483) (£483) (£483) (£483)
Gross Annual Cashflow less Expenses   (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670)
Vacancy Expenses                        
Net Annual Cashflow   (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670) (£4,670)
Net Yield %   (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%)
Debt Coverage Ratio (1:x)   0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64
Personal Equity £54,139 £54,139 £58,990 £64,090 £69,451 £75,087 £81,010 £87,237 £93,782 £100,662 £107,894 £115,497
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,722) £130 £5,230 £10,591 £16,226 £22,150 £28,376 £34,922 £41,802 £49,034 £56,636
Return on Investment %   (8.72%) 0.24% 9.66% 19.56% 29.97% 40.91% 52.41% 64.50% 77.21% 90.57% 104.61%
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,722) £127 £5,023 £9,968 £14,966 £20,022 £25,137 £30,316 £35,563 £40,882 £46,276
Real Return on Investment %   (8.72%) 0.23% 9.28% 18.41% 27.64% 36.98% 46.43% 56.00% 65.69% 75.51% 85.48%