LL61 Llanfairpwllgwyngyll, Brynsiencyn, Dwyran, Newborough cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £211,836
Input Equity (£52,959)
Total Input Equity (£52,959)
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 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836 £211,836
Finance Amount £158,877 £158,877 £154,131 £149,142 £143,898 £138,385 £132,591 £126,500 £120,097 £113,367 £106,292 £98,856
Monthly Mortgage   (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049) (£1,049)
Monthly Rental   £707 £707 £707 £707 £707 £707 £707 £707 £707 £707 £707
Yield to Purchase Price %   4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01%
Yield to Property Value %   4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01% 4.01%
Gross Monthly Cashflow   (£341) (£341) (£341) (£341) (£341) (£341) (£341) (£341) (£341) (£341) (£341)
Gross Annual Cashflow   (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093) (£4,093)
Gross Annual Expenses                        
Annual Management Expenses   (£475) (£475) (£475) (£475) (£475) (£475) (£475) (£475) (£475) (£475) (£475)
Gross Annual Cashflow less Expenses   (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517)
Vacancy Expenses                        
Net Annual Cashflow   (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517)
Net Yield %   (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%) (2.13%)
Debt Coverage Ratio (1:x)   0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64
Personal Equity £52,959 £52,959 £57,705 £62,694 £67,938 £73,451 £79,245 £85,336 £91,739 £98,469 £105,544 £112,980
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   (£4,568) £178 £5,167 £10,411 £15,924 £21,718 £27,809 £34,212 £40,942 £48,017 £55,453
Return on Investment %   (8.63%) 0.34% 9.76% 19.66% 30.07% 41.01% 52.51% 64.60% 77.31% 90.67% 104.71%
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   (£4,568) £174 £4,962 £9,799 £14,687 £19,632 £24,635 £29,700 £34,832 £40,034 £45,309
Real Return on Investment %   (8.63%) 0.33% 9.37% 18.50% 27.73% 37.07% 46.52% 56.08% 65.77% 75.59% 85.56%