LD3 Brecon, Talgarth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £303,375
Input Equity (£75,844)
Total Input Equity (£75,844)
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 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375 £303,375
Finance Amount £227,531 £227,531 £220,734 £213,589 £206,079 £198,184 £189,886 £181,163 £171,993 £162,355 £152,223 £141,573
Monthly Mortgage   (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502) (£1,502)
Monthly Rental   £614 £614 £614 £614 £614 £614 £614 £614 £614 £614 £614
Yield to Purchase Price %   2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43%
Yield to Property Value %   2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43% 2.43%
Gross Monthly Cashflow   (£888) (£888) (£888) (£888) (£888) (£888) (£888) (£888) (£888) (£888) (£888)
Gross Annual Cashflow   (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655) (£10,655)
Gross Annual Expenses                        
Annual Management Expenses   (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412)
Gross Annual Cashflow less Expenses   (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023)
Vacancy Expenses                        
Net Annual Cashflow   (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023) (£11,023)
Net Yield %   (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%) (3.63%)
Debt Coverage Ratio (1:x)   0.39 0.39 0.39 0.39 0.39 0.39 0.39 0.39 0.39 0.39 0.39
Personal Equity £75,844 £75,844 £82,641 £89,786 £97,296 £105,191 £113,489 £122,212 £131,382 £141,020 £151,152 £161,802
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,067) (£4,270) £2,874 £10,385 £18,279 £26,578 £35,301 £44,470 £54,109 £64,240 £74,890
Return on Investment %   (14.59%) (5.63%) 3.79% 13.69% 24.10% 35.04% 46.54% 58.63% 71.34% 84.70% 98.74%
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,067) (£4,185) £2,761 £9,774 £16,860 £24,024 £31,271 £38,606 £46,034 £53,560 £61,191
Real Return on Investment %   (14.59%) (5.52%) 3.64% 12.89% 22.23% 31.68% 41.23% 50.90% 60.70% 70.62% 80.68%