LL44 Dyffryn Ardudwy cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £232,526
Input Equity (£58,132)
Input Equity FX (£58,132)
Total Input Equity (£58,132)
Total Input Equity FX (£58,132)
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 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526 £232,526
Finance Amount £174,395 £174,395 £169,185 £163,709 £157,952 £151,901 £145,541 £138,855 £131,827 £124,439 £116,674 £108,511
Monthly Mortgage   (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151) (£1,151)
Monthly Rental   £575 £575 £575 £575 £575 £575 £575 £575 £575 £575 £575
Yield to Purchase Price %   2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97%
Yield to Property Value %   2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97% 2.97%
Gross Monthly Cashflow   (£576) (£576) (£576) (£576) (£576) (£576) (£576) (£576) (£576) (£576) (£576)
Gross Annual Cashflow   (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911) (£6,911)
Gross Annual Expenses                        
Annual Management Expenses   (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386)
Gross Annual Cashflow less Expenses   (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256)
Vacancy Expenses                        
Net Annual Cashflow   (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256) (£7,256)
Net Yield %   (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%) (3.12%)
Debt Coverage Ratio (1:x)   0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47
Personal Equity £58,132 £58,132 £63,341 £68,817 £74,574 £80,625 £86,985 £93,671 £100,699 £108,087 £115,852 £124,015
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,298) (£2,088) £3,388 £9,145 £15,196 £21,556 £28,242 £35,270 £42,658 £50,423 £58,586
Return on Investment %   (12.55%) (3.59%) 5.83% 15.73% 26.14% 37.08% 48.58% 60.67% 73.38% 86.74% 100.78%
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,298) (£2,046) £3,254 £8,607 £14,016 £19,485 £25,018 £30,619 £36,292 £42,040 £47,869
Real Return on Investment %   (12.55%) (3.52%) 5.60% 14.81% 24.11% 33.52% 43.04% 52.67% 62.43% 72.32% 82.35%