LL63 Ty Croes, Aberffraw, Llanfaelog cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £185,515
Input Equity (£46,379)
Total Input Equity (£46,379)
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 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515 £185,515
Finance Amount £139,136 £139,136 £134,980 £130,611 £126,018 £121,191 £116,116 £110,782 £105,175 £99,281 £93,085 £86,573
Monthly Mortgage   (£918) (£918) (£918) (£918) (£918) (£918) (£918) (£918) (£918) (£918) (£918)
Monthly Rental   £669 £669 £669 £669 £669 £669 £669 £669 £669 £669 £669
Yield to Purchase Price %   4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33%
Yield to Property Value %   4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33% 4.33%
Gross Monthly Cashflow   (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249)
Gross Annual Cashflow   (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989) (£2,989)
Gross Annual Expenses                        
Annual Management Expenses   (£450) (£450) (£450) (£450) (£450) (£450) (£450) (£450) (£450) (£450) (£450)
Gross Annual Cashflow less Expenses   (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391)
Vacancy Expenses                        
Net Annual Cashflow   (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391) (£3,391)
Net Yield %   (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%) (1.83%)
Debt Coverage Ratio (1:x)   0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69
Personal Equity £46,379 £46,379 £50,535 £54,904 £59,497 £64,324 £69,399 £74,733 £80,340 £86,234 £92,430 £98,942
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   (£3,439) £717 £5,086 £9,679 £14,507 £19,581 £24,915 £30,523 £36,416 £42,612 £49,124
Return on Investment %   (7.42%) 1.55% 10.97% 20.87% 31.28% 42.22% 53.72% 65.81% 78.52% 91.88% 105.92%
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   (£3,439) £703 £4,885 £9,110 £13,380 £17,700 £22,071 £26,497 £30,982 £35,528 £40,138
Real Return on Investment %   (7.42%) 1.52% 10.53% 19.64% 28.85% 38.16% 47.59% 57.13% 66.80% 76.60% 86.54%