LD4 Llangammarch Wells cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £182,599
Input Equity (£45,650)
Total Input Equity (£45,650)
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 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599 £182,599
Finance Amount £136,949 £136,949 £132,858 £128,558 £124,037 £119,286 £114,291 £109,040 £103,521 £97,720 £91,622 £85,212
Monthly Mortgage   (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904)
Monthly Rental   £396 £396 £396 £396 £396 £396 £396 £396 £396 £396 £396
Yield to Purchase Price %   2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60%
Yield to Property Value %   2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60% 2.60%
Gross Monthly Cashflow   (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508)
Gross Annual Cashflow   (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096) (£6,096)
Gross Annual Expenses                        
Annual Management Expenses   (£266) (£266) (£266) (£266) (£266) (£266) (£266) (£266) (£266) (£266) (£266)
Gross Annual Cashflow less Expenses   (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334)
Vacancy Expenses                        
Net Annual Cashflow   (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334) (£6,334)
Net Yield %   (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%) (3.47%)
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 £45,650 £45,650 £49,741 £54,041 £58,562 £63,313 £68,308 £73,559 £79,078 £84,879 £90,977 £97,387
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,362) (£2,271) £2,029 £6,550 £11,302 £16,296 £21,547 £27,066 £32,867 £38,965 £45,375
Return on Investment %   (13.94%) (4.97%) 4.45% 14.35% 24.76% 35.70% 47.20% 59.29% 72.00% 85.36% 99.40%
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,362) (£2,226) £1,949 £6,165 £10,424 £14,731 £19,087 £23,496 £27,962 £32,487 £37,075
Real Return on Investment %   (13.94%) (4.88%) 4.27% 13.50% 22.84% 32.27% 41.81% 51.47% 61.25% 71.17% 81.22%