LL47 Talsarnau, Soar, Ynys cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £184,294
Input Equity (£46,074)
Total Input Equity (£46,074)
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 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294 £184,294
Finance Amount £138,221 £138,221 £134,091 £129,751 £125,189 £120,393 £115,352 £110,053 £104,482 £98,627 £92,473 £86,003
Monthly Mortgage   (£912) (£912) (£912) (£912) (£912) (£912) (£912) (£912) (£912) (£912) (£912)
Monthly Rental   £511 £511 £511 £511 £511 £511 £511 £511 £511 £511 £511
Yield to Purchase Price %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Yield to Property Value %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Gross Monthly Cashflow   (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401) (£401)
Gross Annual Cashflow   (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809) (£4,809)
Gross Annual Expenses                        
Annual Management Expenses   (£344) (£344) (£344) (£344) (£344) (£344) (£344) (£344) (£344) (£344) (£344)
Gross Annual Cashflow less Expenses   (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116)
Vacancy Expenses                        
Net Annual Cashflow   (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116) (£5,116)
Net Yield %   (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%)
Debt Coverage Ratio (1:x)   0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
Personal Equity £46,074 £46,074 £50,203 £54,543 £59,105 £63,901 £68,942 £74,241 £79,812 £85,667 £91,821 £98,291
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   (£5,152) (£1,023) £3,317 £7,879 £12,675 £17,716 £23,015 £28,586 £34,441 £40,596 £47,065
Return on Investment %   (11.18%) (2.22%) 7.20% 17.10% 27.51% 38.45% 49.95% 62.04% 74.75% 88.11% 102.15%
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   (£5,152) (£1,003) £3,186 £7,416 £11,691 £16,014 £20,388 £24,816 £29,301 £33,846 £38,456
Real Return on Investment %   (11.18%) (2.18%) 6.91% 16.10% 25.38% 34.76% 44.25% 53.86% 63.60% 73.46% 83.47%