LD6 Rhayader cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £288,896
Input Equity (£72,224)
Total Input Equity (£72,224)
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 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896 £288,896
Finance Amount £216,672 £216,672 £210,199 £203,396 £196,244 £188,726 £180,823 £172,517 £163,785 £154,606 £144,958 £134,817
Monthly Mortgage   (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430) (£1,430)
Monthly Rental   £362 £362 £362 £362 £362 £362 £362 £362 £362 £362 £362
Yield to Purchase Price %   1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50%
Yield to Property Value %   1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50%
Gross Monthly Cashflow   (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068) (£1,068)
Gross Annual Cashflow   (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819) (£12,819)
Gross Annual Expenses                        
Annual Management Expenses   (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243) (£243)
Gross Annual Cashflow less Expenses   (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036)
Vacancy Expenses                        
Net Annual Cashflow   (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036) (£13,036)
Net Yield %   (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%) (4.51%)
Debt Coverage Ratio (1:x)   0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24 0.24
Personal Equity £72,224 £72,224 £78,697 £85,500 £92,652 £100,170 £108,073 £116,379 £125,111 £134,290 £143,938 £154,079
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   (£13,062) (£6,589) £215 £7,366 £14,884 £22,787 £31,093 £39,825 £49,004 £58,652 £68,793
Return on Investment %   (18.09%) (9.12%) 0.30% 10.20% 20.61% 31.55% 43.05% 55.14% 67.85% 81.21% 95.25%
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   (£13,062) (£6,457) £206 £6,933 £13,729 £20,597 £27,544 £34,573 £41,691 £48,901 £56,209
Real Return on Investment %   (18.09%) (8.94%) 0.29% 9.60% 19.01% 28.52% 38.14% 47.87% 57.72% 67.71% 77.83%