LL43 Talybont cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £207,586
Input Equity (£51,897)
Total Input Equity (£51,897)
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 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586 £207,586
Finance Amount £155,690 £155,690 £151,039 £146,150 £141,011 £135,609 £129,930 £123,962 £117,687 £111,092 £104,160 £96,872
Monthly Mortgage   (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027) (£1,027)
Monthly Rental   £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550
Yield to Purchase Price %   3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18%
Yield to Property Value %   3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18% 3.18%
Gross Monthly Cashflow   (£477) (£477) (£477) (£477) (£477) (£477) (£477) (£477) (£477) (£477) (£477)
Gross Annual Cashflow   (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730) (£5,730)
Gross Annual Expenses                        
Annual Management Expenses   (£370) (£370) (£370) (£370) (£370) (£370) (£370) (£370) (£370) (£370) (£370)
Gross Annual Cashflow less Expenses   (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060)
Vacancy Expenses                        
Net Annual Cashflow   (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060) (£6,060)
Net Yield %   (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%) (2.92%)
Debt Coverage Ratio (1:x)   0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51
Personal Equity £51,897 £51,897 £56,547 £61,436 £66,575 £71,977 £77,656 £83,624 £89,899 £96,494 £103,426 £110,714
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,099) (£1,448) £3,440 £8,579 £13,981 £19,660 £25,628 £31,903 £38,498 £45,430 £52,718
Return on Investment %   (11.75%) (2.79%) 6.63% 16.53% 26.94% 37.88% 49.38% 61.47% 74.18% 87.54% 101.58%
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,099) (£1,419) £3,304 £8,075 £12,896 £17,771 £22,703 £27,696 £32,753 £37,878 £43,074
Real Return on Investment %   (11.75%) (2.74%) 6.37% 15.56% 24.85% 34.24% 43.75% 53.37% 63.11% 72.99% 83.00%