LD2 Builth Wells cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £281,611
Input Equity (£70,403)
Total Input Equity (£70,403)
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 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611 £281,611
Finance Amount £211,208 £211,208 £204,899 £198,267 £191,295 £183,967 £176,264 £168,166 £159,655 £150,708 £141,303 £131,417
Monthly Mortgage   (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394) (£1,394)
Monthly Rental   £456 £456 £456 £456 £456 £456 £456 £456 £456 £456 £456
Yield to Purchase Price %   1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94%
Yield to Property Value %   1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94% 1.94%
Gross Monthly Cashflow   (£937) (£937) (£937) (£937) (£937) (£937) (£937) (£937) (£937) (£937) (£937)
Gross Annual Cashflow   (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249) (£11,249)
Gross Annual Expenses                        
Annual Management Expenses   (£307) (£307) (£307) (£307) (£307) (£307) (£307) (£307) (£307) (£307) (£307)
Gross Annual Cashflow less Expenses   (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523)
Vacancy Expenses                        
Net Annual Cashflow   (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523) (£11,523)
Net Yield %   (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%) (4.09%)
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 £70,403 £70,403 £76,712 £83,344 £90,316 £97,644 £105,347 £113,445 £121,956 £130,903 £140,308 £150,194
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,556) (£5,247) £1,386 £8,357 £15,686 £23,389 £31,486 £39,998 £48,945 £58,349 £68,235
Return on Investment %   (16.41%) (7.45%) 1.97% 11.87% 22.28% 33.22% 44.72% 56.81% 69.52% 82.88% 96.92%
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,556) (£5,142) £1,331 £7,866 £14,468 £21,142 £27,892 £34,723 £41,640 £48,649 £55,753
Real Return on Investment %   (16.41%) (7.30%) 1.89% 11.17% 20.55% 30.03% 39.62% 49.32% 59.15% 69.10% 79.19%