LE67 Coalville, Ibstock, Markfield cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £223,117
Input Equity (£55,779)
Total Input Equity (£55,779)
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 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117 £223,117
Finance Amount £167,338 £167,338 £162,339 £157,084 £151,561 £145,755 £139,651 £133,236 £126,493 £119,404 £111,953 £104,120
Monthly Mortgage   (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104) (£1,104)
Monthly Rental   £637 £637 £637 £637 £637 £637 £637 £637 £637 £637 £637
Yield to Purchase Price %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Yield to Property Value %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Gross Monthly Cashflow   (£468) (£468) (£468) (£468) (£468) (£468) (£468) (£468) (£468) (£468) (£468)
Gross Annual Cashflow   (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613) (£5,613)
Gross Annual Expenses                        
Annual Management Expenses   (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428)
Gross Annual Cashflow less Expenses   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Vacancy Expenses                        
Net Annual Cashflow   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Net Yield %   (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £55,779 £55,779 £60,778 £66,033 £71,556 £77,362 £83,466 £89,881 £96,625 £103,713 £111,164 £118,997
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   (£6,041) (£1,042) £4,213 £9,736 £15,542 £21,645 £28,061 £34,804 £41,893 £49,344 £57,177
Return on Investment %   (10.83%) (1.87%) 7.55% 17.45% 27.86% 38.81% 50.31% 62.40% 75.11% 88.46% 102.51%
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   (£6,041) (£1,021) £4,046 £9,164 £14,336 £19,566 £24,857 £30,215 £35,641 £41,141 £46,718
Real Return on Investment %   (10.83%) (1.83%) 7.25% 16.43% 25.70% 35.08% 44.56% 54.17% 63.90% 73.76% 83.75%