LL40 Dolgellau, Brithdir, Drws Y Nant, Ganllwyd, Llanelltyd, Llanfachreth, Rhydymain, Tabor cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £233,822
Input Equity (£58,456)
Total Input Equity (£58,456)
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 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822 £233,822
Finance Amount £175,367 £175,367 £170,128 £164,621 £158,832 £152,748 £146,352 £139,629 £132,562 £125,133 £117,324 £109,116
Monthly Mortgage   (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157) (£1,157)
Monthly Rental   £517 £517 £517 £517 £517 £517 £517 £517 £517 £517 £517
Yield to Purchase Price %   2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65%
Yield to Property Value %   2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65% 2.65%
Gross Monthly Cashflow   (£640) (£640) (£640) (£640) (£640) (£640) (£640) (£640) (£640) (£640) (£640)
Gross Annual Cashflow   (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684) (£7,684)
Gross Annual Expenses                        
Annual Management Expenses   (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347)
Gross Annual Cashflow less Expenses   (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994)
Vacancy Expenses                        
Net Annual Cashflow   (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994) (£7,994)
Net Yield %   (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%) (3.42%)
Debt Coverage Ratio (1:x)   0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42
Personal Equity £58,456 £58,456 £63,694 £69,201 £74,990 £81,074 £87,470 £94,193 £101,260 £108,689 £116,498 £124,706
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,031) (£2,793) £2,714 £8,503 £14,587 £20,983 £27,706 £34,774 £42,202 £50,011 £58,219
Return on Investment %   (13.74%) (4.78%) 4.64% 14.55% 24.95% 35.90% 47.40% 59.49% 72.20% 85.55% 99.60%
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,031) (£2,737) £2,607 £8,003 £13,455 £18,967 £24,544 £30,188 £35,904 £41,697 £47,569
Real Return on Investment %   (13.74%) (4.68%) 4.46% 13.69% 23.02% 32.45% 41.99% 51.64% 61.42% 71.33% 81.38%