LL42 Barmouth, Llanaber cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £312,733
Input Equity (£78,183)
Total Input Equity (£78,183)
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 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733 £312,733
Finance Amount £234,550 £234,550 £227,543 £220,178 £212,436 £204,298 £195,743 £186,751 £177,299 £167,363 £156,919 £145,940
Monthly Mortgage   (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548) (£1,548)
Monthly Rental   £468 £468 £468 £468 £468 £468 £468 £468 £468 £468 £468
Yield to Purchase Price %   1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80%
Yield to Property Value %   1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80% 1.80%
Gross Monthly Cashflow   (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080) (£1,080)
Gross Annual Cashflow   (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954) (£12,954)
Gross Annual Expenses                        
Annual Management Expenses   (£315) (£315) (£315) (£315) (£315) (£315) (£315) (£315) (£315) (£315) (£315)
Gross Annual Cashflow less Expenses   (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235)
Vacancy Expenses                        
Net Annual Cashflow   (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235) (£13,235)
Net Yield %   (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%) (4.23%)
Debt Coverage Ratio (1:x)   0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29 0.29
Personal Equity £78,183 £78,183 £85,190 £92,555 £100,297 £108,435 £116,990 £125,982 £135,434 £145,370 £155,814 £166,793
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   (£13,269) (£6,262) £1,103 £8,845 £16,983 £25,538 £34,530 £43,982 £53,918 £64,362 £75,340
Return on Investment %   (16.97%) (8.01%) 1.41% 11.31% 21.72% 32.66% 44.17% 56.25% 68.96% 82.32% 96.36%
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   (£13,269) (£6,137) £1,059 £8,325 £15,665 £23,084 £30,588 £38,182 £45,871 £53,662 £61,558
Real Return on Investment %   (16.97%) (7.85%) 1.35% 10.65% 20.04% 29.53% 39.12% 48.84% 58.67% 68.64% 78.74%