LL35 Aberdovey cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £275,284
Input Equity (£68,821)
Total Input Equity (£68,821)
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 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284 £275,284
Finance Amount £206,463 £206,463 £200,295 £193,812 £186,997 £179,834 £172,303 £164,388 £156,068 £147,322 £138,128 £128,464
Monthly Mortgage   (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363) (£1,363)
Monthly Rental   £450 £450 £450 £450 £450 £450 £450 £450 £450 £450 £450
Yield to Purchase Price %   1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96%
Yield to Property Value %   1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96% 1.96%
Gross Monthly Cashflow   (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913) (£913)
Gross Annual Cashflow   (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955) (£10,955)
Gross Annual Expenses                        
Annual Management Expenses   (£302) (£302) (£302) (£302) (£302) (£302) (£302) (£302) (£302) (£302) (£302)
Gross Annual Cashflow less Expenses   (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225)
Vacancy Expenses                        
Net Annual Cashflow   (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225) (£11,225)
Net Yield %   (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%) (4.08%)
Debt Coverage Ratio (1:x)   0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31
Personal Equity £68,821 £68,821 £74,989 £81,472 £88,287 £95,450 £102,981 £110,896 £119,216 £127,962 £137,156 £146,820
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   (£11,257) (£5,090) £1,393 £8,208 £15,372 £22,902 £30,817 £39,138 £47,884 £57,077 £66,741
Return on Investment %   (16.36%) (7.40%) 2.02% 11.93% 22.34% 33.28% 44.78% 56.87% 69.58% 82.94% 96.98%
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   (£11,257) (£4,988) £1,338 £7,726 £14,179 £20,702 £27,299 £33,977 £40,738 £47,588 £54,532
Real Return on Investment %   (16.36%) (7.25%) 1.94% 11.23% 20.60% 30.08% 39.67% 49.37% 59.19% 69.15% 79.24%