LD5 Llanwrtyd Wells cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £270,743
Input Equity (£67,686)
Total Input Equity (£67,686)
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 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743 £270,743
Finance Amount £203,057 £203,057 £196,991 £190,615 £183,912 £176,867 £169,461 £161,676 £153,493 £144,892 £135,850 £126,345
Monthly Mortgage   (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340) (£1,340)
Monthly Rental   £325 £325 £325 £325 £325 £325 £325 £325 £325 £325 £325
Yield to Purchase Price %   1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44%
Yield to Property Value %   1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44% 1.44%
Gross Monthly Cashflow   (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015)
Gross Annual Cashflow   (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181)
Gross Annual Expenses                        
Annual Management Expenses   (£218) (£218) (£218) (£218) (£218) (£218) (£218) (£218) (£218) (£218) (£218)
Gross Annual Cashflow less Expenses   (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376)
Vacancy Expenses                        
Net Annual Cashflow   (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376) (£12,376)
Net Yield %   (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%) (4.57%)
Debt Coverage Ratio (1:x)   0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23 0.23
Personal Equity £67,686 £67,686 £73,752 £80,128 £86,831 £93,876 £101,282 £109,067 £117,250 £125,851 £134,893 £144,398
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   (£12,399) (£6,334) £43 £6,745 £13,791 £21,197 £28,981 £37,165 £45,766 £54,808 £64,312
Return on Investment %   (18.32%) (9.36%) 0.06% 9.97% 20.37% 31.32% 42.82% 54.91% 67.62% 80.97% 95.02%
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   (£12,399) (£6,207) £41 £6,349 £12,720 £19,160 £25,673 £32,263 £38,936 £45,696 £52,548
Real Return on Investment %   (18.32%) (9.17%) 0.06% 9.38% 18.79% 28.31% 37.93% 47.67% 57.53% 67.51% 77.64%