LS20 Guiseley cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £273,446
Input Equity (£68,362)
Total Input Equity (£68,362)
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 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446 £273,446
Finance Amount £205,085 £205,085 £198,958 £192,518 £185,749 £178,633 £171,153 £163,290 £155,026 £146,338 £137,206 £127,607
Monthly Mortgage   (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353) (£1,353)
Monthly Rental   £669 £669 £669 £669 £669 £669 £669 £669 £669 £669 £669
Yield to Purchase Price %   2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93%
Yield to Property Value %   2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93% 2.93%
Gross Monthly Cashflow   (£685) (£685) (£685) (£685) (£685) (£685) (£685) (£685) (£685) (£685) (£685)
Gross Annual Cashflow   (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217) (£8,217)
Gross Annual Expenses                        
Annual Management Expenses   (£449) (£449) (£449) (£449) (£449) (£449) (£449) (£449) (£449) (£449) (£449)
Gross Annual Cashflow less Expenses   (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618)
Vacancy Expenses                        
Net Annual Cashflow   (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618) (£8,618)
Net Yield %   (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%)
Debt Coverage Ratio (1:x)   0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47
Personal Equity £68,362 £68,362 £74,488 £80,928 £87,697 £94,813 £102,293 £110,156 £118,420 £127,108 £136,240 £145,839
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   (£8,666) (£2,540) £3,900 £10,670 £17,786 £25,265 £33,128 £41,393 £50,080 £59,212 £68,812
Return on Investment %   (12.68%) (3.71%) 5.71% 15.61% 26.02% 36.96% 48.46% 60.55% 73.26% 86.62% 100.66%
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   (£8,666) (£2,489) £3,746 £10,042 £16,405 £22,838 £29,346 £35,934 £42,606 £49,368 £56,224
Real Return on Investment %   (12.68%) (3.64%) 5.48% 14.69% 24.00% 33.41% 42.93% 52.56% 62.33% 72.22% 82.25%