LL70 Dulas cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £251,700
Input Equity (£62,925)
Input Equity FX (£62,925)
Total Input Equity (£62,925)
Total Input Equity FX (£62,925)
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 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700 £251,700
Finance Amount £188,775 £188,775 £183,136 £177,208 £170,977 £164,427 £157,542 £150,305 £142,697 £134,700 £126,295 £117,459
Monthly Mortgage   (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246) (£1,246)
Monthly Rental   £1,075 £1,075 £1,075 £1,075 £1,075 £1,075 £1,075 £1,075 £1,075 £1,075 £1,075
Yield to Purchase Price %   5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13%
Yield to Property Value %   5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13% 5.13%
Gross Monthly Cashflow   (£170) (£170) (£170) (£170) (£170) (£170) (£170) (£170) (£170) (£170) (£170)
Gross Annual Cashflow   (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045) (£2,045)
Gross Annual Expenses                        
Annual Management Expenses   (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723)
Gross Annual Cashflow less Expenses   (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691)
Vacancy Expenses                        
Net Annual Cashflow   (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691) (£2,691)
Net Yield %   (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%) (1.07%)
Debt Coverage Ratio (1:x)   0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82
Personal Equity £62,925 £62,925 £68,564 £74,492 £80,723 £87,273 £94,158 £101,395 £109,003 £117,000 £125,405 £134,241
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   (£2,768) £2,871 £8,799 £15,030 £21,580 £28,465 £35,702 £43,310 £51,306 £59,712 £68,548
Return on Investment %   (4.40%) 4.56% 13.98% 23.89% 34.29% 45.24% 56.74% 68.83% 81.54% 94.89% 108.94%
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   (£2,768) £2,814 £8,451 £14,146 £19,905 £25,730 £31,627 £37,598 £43,650 £49,785 £56,009
Real Return on Investment %   (4.40%) 4.47% 13.43% 22.48% 31.63% 40.89% 50.26% 59.75% 69.37% 79.12% 89.01%