LL26 Llanrwst, Capel Garmon, Llanddoged, Melin-y-Coed, Maenan cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £258,693
Input Equity (£64,673)
Total Input Equity (£64,673)
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 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693 £258,693
Finance Amount £194,020 £194,020 £188,224 £182,131 £175,727 £168,995 £161,919 £154,481 £146,662 £138,443 £129,803 £120,722
Monthly Mortgage   (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280) (£1,280)
Monthly Rental   £499 £499 £499 £499 £499 £499 £499 £499 £499 £499 £499
Yield to Purchase Price %   2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31%
Yield to Property Value %   2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31% 2.31%
Gross Monthly Cashflow   (£782) (£782) (£782) (£782) (£782) (£782) (£782) (£782) (£782) (£782) (£782)
Gross Annual Cashflow   (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383) (£9,383)
Gross Annual Expenses                        
Annual Management Expenses   (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335)
Gross Annual Cashflow less Expenses   (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682)
Vacancy Expenses                        
Net Annual Cashflow   (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682) (£9,682)
Net Yield %   (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%) (3.74%)
Debt Coverage Ratio (1:x)   0.37 0.37 0.37 0.37 0.37 0.37 0.37 0.37 0.37 0.37 0.37
Personal Equity £64,673 £64,673 £70,469 £76,562 £82,966 £89,698 £96,774 £104,212 £112,031 £120,250 £128,890 £137,971
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   (£9,718) (£3,922) £2,171 £8,575 £15,307 £22,383 £29,821 £37,640 £45,859 £54,499 £63,580
Return on Investment %   (15.03%) (6.06%) 3.36% 13.26% 23.67% 34.61% 46.11% 58.20% 70.91% 84.27% 98.31%
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   (£9,718) (£3,843) £2,085 £8,071 £14,119 £20,233 £26,417 £32,676 £39,015 £45,438 £51,949
Real Return on Investment %   (15.03%) (5.94%) 3.22% 12.48% 21.83% 31.28% 40.85% 50.53% 60.33% 70.26% 80.33%