LL29 Colwyn Bay, Llanelian, Llysfaen, Old Colwyn cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £212,576
Input Equity (£53,144)
Total Input Equity (£53,144)
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 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576 £212,576
Finance Amount £159,432 £159,432 £154,669 £149,663 £144,400 £138,869 £133,054 £126,941 £120,516 £113,763 £106,663 £99,201
Monthly Mortgage   (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052) (£1,052)
Monthly Rental   £555 £555 £555 £555 £555 £555 £555 £555 £555 £555 £555
Yield to Purchase Price %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Yield to Property Value %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Gross Monthly Cashflow   (£497) (£497) (£497) (£497) (£497) (£497) (£497) (£497) (£497) (£497) (£497)
Gross Annual Cashflow   (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962) (£5,962)
Gross Annual Expenses                        
Annual Management Expenses   (£373) (£373) (£373) (£373) (£373) (£373) (£373) (£373) (£373) (£373) (£373)
Gross Annual Cashflow less Expenses   (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296)
Vacancy Expenses                        
Net Annual Cashflow   (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296) (£6,296)
Net Yield %   (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £53,144 £53,144 £57,907 £62,913 £68,176 £73,707 £79,522 £85,635 £92,060 £98,813 £105,913 £113,375
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   (£6,336) (£1,573) £3,434 £8,696 £14,228 £20,043 £26,155 £32,580 £39,334 £46,433 £53,895
Return on Investment %   (11.92%) (2.96%) 6.46% 16.36% 26.77% 37.71% 49.22% 61.31% 74.01% 87.37% 101.41%
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   (£6,336) (£1,541) £3,298 £8,185 £13,123 £18,117 £23,169 £28,284 £33,464 £38,713 £44,037
Real Return on Investment %   (11.92%) (2.90%) 6.21% 15.40% 24.69% 34.09% 43.60% 53.22% 62.97% 72.85% 82.86%