LL74 Tyn-y-Gongl, Benllech cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £207,366
Input Equity (£51,842)
Total Input Equity (£51,842)
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 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366 £207,366
Finance Amount £155,525 £155,525 £150,879 £145,995 £140,861 £135,465 £129,793 £123,830 £117,563 £110,975 £104,049 £96,770
Monthly Mortgage   (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026) (£1,026)
Monthly Rental   £1,774 £1,774 £1,774 £1,774 £1,774 £1,774 £1,774 £1,774 £1,774 £1,774 £1,774
Yield to Purchase Price %   10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26%
Yield to Property Value %   10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26% 10.26%
Gross Monthly Cashflow   £747 £747 £747 £747 £747 £747 £747 £747 £747 £747 £747
Gross Annual Cashflow   £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969
Gross Annual Expenses                        
Annual Management Expenses   (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192)
Gross Annual Cashflow less Expenses   £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905
Vacancy Expenses                        
Net Annual Cashflow   £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905
Taxable Income   £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969 £8,969
Tax Payable                        
Net Annual Cashflow Less Tax   £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905 £7,905
Net Yield %   3.81% 3.81% 3.81% 3.81% 3.81% 3.81% 3.81% 3.81% 3.81% 3.81% 3.81%
Debt Coverage Ratio (1:x)   1.64 1.64 1.64 1.64 1.64 1.64 1.64 1.64 1.64 1.64 1.64
Personal Equity £51,842 £51,842 £56,488 £61,371 £66,505 £71,901 £77,573 £83,536 £89,803 £96,391 £103,317 £110,596
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   £7,777 £12,423 £17,307 £22,441 £27,837 £33,509 £39,472 £45,739 £52,327 £59,253 £66,532
Return on Investment %   15.00% 23.96% 33.38% 43.29% 53.70% 64.64% 76.14% 88.23% 100.94% 114.30% 128.34%
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   £7,777 £12,175 £16,622 £21,121 £25,676 £30,290 £34,966 £39,707 £44,518 £49,402 £54,362
Real Return on Investment %   15.00% 23.48% 32.06% 40.74% 49.53% 58.43% 67.45% 76.59% 85.87% 95.29% 104.86%