LL25 Dolwyddelan cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £291,425
Input Equity (£72,856)
Total Input Equity (£72,856)
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 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425 £291,425
Finance Amount £218,569 £218,569 £212,039 £205,176 £197,962 £190,378 £182,406 £174,027 £165,219 £155,960 £146,227 £135,997
Monthly Mortgage   (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442) (£1,442)
Monthly Rental   £509 £509 £509 £509 £509 £509 £509 £509 £509 £509 £509
Yield to Purchase Price %   2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10%
Yield to Property Value %   2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10% 2.10%
Gross Monthly Cashflow   (£933) (£933) (£933) (£933) (£933) (£933) (£933) (£933) (£933) (£933) (£933)
Gross Annual Cashflow   (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196) (£11,196)
Gross Annual Expenses                        
Annual Management Expenses   (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342)
Gross Annual Cashflow less Expenses   (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501)
Vacancy Expenses                        
Net Annual Cashflow   (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501) (£11,501)
Net Yield %   (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%) (3.95%)
Debt Coverage Ratio (1:x)   0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34
Personal Equity £72,856 £72,856 £79,386 £86,249 £93,463 £101,047 £109,019 £117,398 £126,206 £135,465 £145,198 £155,428
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   (£11,538) (£5,009) £1,855 £9,069 £16,653 £24,624 £33,004 £41,812 £51,071 £60,803 £71,034
Return on Investment %   (15.84%) (6.87%) 2.55% 12.45% 22.86% 33.80% 45.30% 57.39% 70.10% 83.46% 97.50%
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   (£11,538) (£4,909) £1,781 £8,536 £15,360 £22,259 £29,236 £36,298 £43,449 £50,695 £58,040
Real Return on Investment %   (15.84%) (6.74%) 2.44% 11.72% 21.08% 30.55% 40.13% 49.82% 59.64% 69.58% 79.66%