LD1 Llandrindod Wells cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £261,648
Input Equity (£65,412)
Total Input Equity (£65,412)
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 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648 £261,648
Finance Amount £196,236 £196,236 £190,374 £184,212 £177,734 £170,926 £163,768 £156,245 £148,337 £140,024 £131,286 £122,101
Monthly Mortgage   (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295) (£1,295)
Monthly Rental   £365 £365 £365 £365 £365 £365 £365 £365 £365 £365 £365
Yield to Purchase Price %   1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68%
Yield to Property Value %   1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68% 1.68%
Gross Monthly Cashflow   (£930) (£930) (£930) (£930) (£930) (£930) (£930) (£930) (£930) (£930) (£930)
Gross Annual Cashflow   (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157) (£11,157)
Gross Annual Expenses                        
Annual Management Expenses   (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245)
Gross Annual Cashflow less Expenses   (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376)
Vacancy Expenses                        
Net Annual Cashflow   (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376) (£11,376)
Net Yield %   (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%) (4.35%)
Debt Coverage Ratio (1:x)   0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27 0.27
Personal Equity £65,412 £65,412 £71,274 £77,436 £83,914 £90,722 £97,880 £105,403 £113,311 £121,624 £130,362 £139,547
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,403) (£5,540) £622 £7,099 £13,908 £21,065 £28,588 £36,496 £44,809 £53,547 £62,732
Return on Investment %   (17.43%) (8.47%) 0.95% 10.85% 21.26% 32.20% 43.70% 55.79% 68.50% 81.86% 95.90%
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,403) (£5,430) £597 £6,682 £12,828 £19,041 £25,325 £31,684 £38,122 £44,645 £51,257
Real Return on Investment %   (17.43%) (8.30%) 0.91% 10.21% 19.61% 29.11% 38.72% 48.44% 58.28% 68.25% 78.36%