LL16 Denbigh, Bodfari, Llandyrnog, Llanrhaeadr, Bylchau, Groes, Henllan, Llannefydd, Llansannan, Nantglyn, The Green, Trefnant cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £244,382
Input Equity (£61,096)
Input Equity FX (£61,096)
Total Input Equity (£61,096)
Total Input Equity FX (£61,096)
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 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382 £244,382
Finance Amount £183,287 £183,287 £177,811 £172,056 £166,006 £159,646 £152,962 £145,935 £138,548 £130,784 £122,623 £114,044
Monthly Mortgage   (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210)
Monthly Rental   £578 £578 £578 £578 £578 £578 £578 £578 £578 £578 £578
Yield to Purchase Price %   2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84%
Yield to Property Value %   2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84% 2.84%
Gross Monthly Cashflow   (£631) (£631) (£631) (£631) (£631) (£631) (£631) (£631) (£631) (£631) (£631)
Gross Annual Cashflow   (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577) (£7,577)
Gross Annual Expenses                        
Annual Management Expenses   (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389)
Gross Annual Cashflow less Expenses   (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924)
Vacancy Expenses                        
Net Annual Cashflow   (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924) (£7,924)
Net Yield %   (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%) (3.24%)
Debt Coverage Ratio (1:x)   0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45
Personal Equity £61,096 £61,096 £66,571 £72,326 £78,376 £84,736 £91,421 £98,447 £105,834 £113,598 £121,759 £130,338
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,966) (£2,490) £3,265 £9,315 £15,674 £22,359 £29,386 £36,772 £44,537 £52,698 £61,277
Return on Investment %   (13.04%) (4.08%) 5.34% 15.25% 25.66% 36.60% 48.10% 60.19% 72.90% 86.26% 100.30%
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,966) (£2,441) £3,136 £8,767 £14,458 £20,211 £26,031 £31,923 £37,890 £43,937 £50,068
Real Return on Investment %   (13.04%) (3.99%) 5.13% 14.35% 23.66% 33.08% 42.61% 52.25% 62.02% 71.92% 81.95%