LL71 Llanerchymedd cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £231,265
Input Equity (£57,816)
Input Equity FX (£57,816)
Total Input Equity (£57,816)
Total Input Equity FX (£57,816)
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 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265 £231,265
Finance Amount £173,449 £173,449 £168,267 £162,821 £157,096 £151,077 £144,751 £138,102 £131,112 £123,764 £116,041 £107,922
Monthly Mortgage   (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145) (£1,145)
Monthly Rental   £702 £702 £702 £702 £702 £702 £702 £702 £702 £702 £702
Yield to Purchase Price %   3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64%
Yield to Property Value %   3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64% 3.64%
Gross Monthly Cashflow   (£443) (£443) (£443) (£443) (£443) (£443) (£443) (£443) (£443) (£443) (£443)
Gross Annual Cashflow   (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318) (£5,318)
Gross Annual Expenses                        
Annual Management Expenses   (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471)
Gross Annual Cashflow less Expenses   (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739)
Vacancy Expenses                        
Net Annual Cashflow   (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739) (£5,739)
Net Yield %   (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%) (2.48%)
Debt Coverage Ratio (1:x)   0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58
Personal Equity £57,816 £57,816 £62,998 £68,444 £74,169 £80,188 £86,514 £93,163 £100,153 £107,501 £115,224 £123,343
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   (£5,789) (£608) £4,839 £10,564 £16,582 £22,908 £29,558 £36,547 £43,895 £51,618 £59,737
Return on Investment %   (10.01%) (1.05%) 8.37% 18.27% 28.68% 39.62% 51.12% 63.21% 75.92% 89.28% 103.32%
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   (£5,789) (£596) £4,647 £9,943 £15,295 £20,707 £26,183 £31,728 £37,344 £43,037 £48,809
Real Return on Investment %   (10.01%) (1.03%) 8.04% 17.20% 26.45% 35.82% 45.29% 54.88% 64.59% 74.44% 84.42%