LL38 Fairbourne, Friog cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £140,698
Input Equity (£35,175)
Total Input Equity (£35,175)
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 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698 £140,698
Finance Amount £105,524 £105,524 £102,371 £99,058 £95,574 £91,913 £88,064 £84,019 £79,766 £75,296 £70,598 £65,658
Monthly Mortgage   (£696) (£696) (£696) (£696) (£696) (£696) (£696) (£696) (£696) (£696) (£696)
Monthly Rental   £459 £459 £459 £459 £459 £459 £459 £459 £459 £459 £459
Yield to Purchase Price %   3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%
Yield to Property Value %   3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91% 3.91%
Gross Monthly Cashflow   (£237) (£237) (£237) (£237) (£237) (£237) (£237) (£237) (£237) (£237) (£237)
Gross Annual Cashflow   (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849) (£2,849)
Gross Annual Expenses                        
Annual Management Expenses   (£308) (£308) (£308) (£308) (£308) (£308) (£308) (£308) (£308) (£308) (£308)
Gross Annual Cashflow less Expenses   (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124)
Vacancy Expenses                        
Net Annual Cashflow   (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124) (£3,124)
Net Yield %   (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%) (2.22%)
Debt Coverage Ratio (1:x)   0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63
Personal Equity £35,175 £35,175 £38,327 £41,640 £45,124 £48,785 £52,634 £56,679 £60,932 £65,402 £70,100 £75,040
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,157) (£5) £3,309 £6,792 £10,453 £14,302 £18,347 £22,600 £27,070 £31,769 £36,708
Return on Investment %   (8.98%) (0.01%) 9.41% 19.31% 29.72% 40.66% 52.16% 64.25% 76.96% 90.32% 104.36%
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,157) (£5) £3,178 £6,392 £9,642 £12,928 £16,253 £19,620 £23,030 £26,487 £29,993
Real Return on Investment %   (8.98%) (0.01%) 9.03% 18.17% 27.41% 36.75% 46.21% 55.78% 65.47% 75.30% 85.27%