LL17 St. Asaph, Allt Goch, Rhuallt, Tremeirchion, Waen cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £221,386
Input Equity (£55,347)
Total Input Equity (£55,347)
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 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386 £221,386
Finance Amount £166,040 £166,040 £161,079 £155,866 £150,385 £144,624 £138,568 £132,202 £125,511 £118,478 £111,084 £103,312
Monthly Mortgage   (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096) (£1,096)
Monthly Rental   £535 £535 £535 £535 £535 £535 £535 £535 £535 £535 £535
Yield to Purchase Price %   2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90%
Yield to Property Value %   2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90%
Gross Monthly Cashflow   (£561) (£561) (£561) (£561) (£561) (£561) (£561) (£561) (£561) (£561) (£561)
Gross Annual Cashflow   (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733) (£6,733)
Gross Annual Expenses                        
Annual Management Expenses   (£359) (£359) (£359) (£359) (£359) (£359) (£359) (£359) (£359) (£359) (£359)
Gross Annual Cashflow less Expenses   (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053)
Vacancy Expenses                        
Net Annual Cashflow   (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053) (£7,053)
Net Yield %   (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £55,347 £55,347 £60,307 £65,521 £71,001 £76,762 £82,818 £89,184 £95,875 £102,908 £110,302 £118,074
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,092) (£2,132) £3,082 £8,563 £14,324 £20,380 £26,745 £33,436 £40,470 £47,864 £55,635
Return on Investment %   (12.81%) (3.85%) 5.57% 15.47% 25.88% 36.82% 48.32% 60.41% 73.12% 86.48% 100.52%
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,092) (£2,089) £2,960 £8,059 £13,212 £18,421 £23,692 £29,027 £34,430 £39,906 £45,458
Real Return on Investment %   (12.81%) (3.77%) 5.35% 14.56% 23.87% 33.28% 42.81% 52.45% 62.21% 72.10% 82.13%