LS15 Austhorpe, Barwick-in-Elmet, Colton, Cross Gates, Halton, Halton Moor, Scholes, Whitkirk cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £190,335
Input Equity (£47,584)
Total Input Equity (£47,584)
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 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335 £190,335
Finance Amount £142,751 £142,751 £138,487 £134,004 £129,292 £124,339 £119,133 £113,660 £107,907 £101,860 £95,504 £88,822
Monthly Mortgage   (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942)
Monthly Rental   £685 £685 £685 £685 £685 £685 £685 £685 £685 £685 £685
Yield to Purchase Price %   4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32%
Yield to Property Value %   4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32% 4.32%
Gross Monthly Cashflow   (£257) (£257) (£257) (£257) (£257) (£257) (£257) (£257) (£257) (£257) (£257)
Gross Annual Cashflow   (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080) (£3,080)
Gross Annual Expenses                        
Annual Management Expenses   (£461) (£461) (£461) (£461) (£461) (£461) (£461) (£461) (£461) (£461) (£461)
Gross Annual Cashflow less Expenses   (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491)
Vacancy Expenses                        
Net Annual Cashflow   (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491) (£3,491)
Net Yield %   (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%)
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 £47,584 £47,584 £51,848 £56,331 £61,043 £65,996 £71,202 £76,675 £82,428 £88,475 £94,831 £101,513
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,540) £724 £5,207 £9,919 £14,872 £20,078 £25,551 £31,304 £37,351 £43,707 £50,389
Return on Investment %   (7.44%) 1.52% 10.94% 20.84% 31.25% 42.20% 53.70% 65.79% 78.50% 91.85% 105.90%
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,540) £710 £5,001 £9,336 £13,717 £18,149 £22,634 £27,176 £31,777 £36,441 £41,172
Real Return on Investment %   (7.44%) 1.49% 10.51% 19.62% 28.83% 38.14% 47.57% 57.11% 66.78% 76.58% 86.52%