M7 Higher Broughton, Cheetwood, Lower Broughton, Kersal cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £126,979
Input Equity (£31,745)
Input Equity FX (£31,745)
Total Input Equity (£31,745)
Total Input Equity FX (£31,745)
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 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979 £126,979
Finance Amount £95,234 £95,234 £92,389 £89,399 £86,255 £82,951 £79,478 £75,827 £71,989 £67,954 £63,714 £59,256
Monthly Mortgage   (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629)
Monthly Rental   £638 £638 £638 £638 £638 £638 £638 £638 £638 £638 £638
Yield to Purchase Price %   6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03%
Yield to Property Value %   6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03% 6.03%
Gross Monthly Cashflow   £10 £10 £10 £10 £10 £10 £10 £10 £10 £10 £10
Gross Annual Cashflow   £115 £115 £115 £115 £115 £115 £115 £115 £115 £115 £115
Gross Annual Expenses                        
Annual Management Expenses   (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429)
Gross Annual Cashflow less Expenses   (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268)
Vacancy Expenses                        
Net Annual Cashflow   (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268)
Taxable Income   £115 £115 £115 £115 £115 £115 £115 £115 £115 £115 £115
Tax Payable                        
Net Annual Cashflow Less Tax   (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268) (£268)
Net Yield %   (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%) (0.21%)
Debt Coverage Ratio (1:x)   0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96
Personal Equity £31,745 £31,745 £34,590 £37,580 £40,724 £44,028 £47,501 £51,152 £54,990 £59,025 £63,265 £67,723
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   (£314) £2,531 £5,521 £8,665 £11,969 £15,443 £19,094 £22,931 £26,966 £31,206 £35,664
Return on Investment %   (0.99%) 7.97% 17.39% 27.30% 37.70% 48.65% 60.15% 72.24% 84.95% 98.30% 112.35%
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   (£314) £2,480 £5,303 £8,155 £11,040 £13,959 £16,914 £19,907 £22,941 £26,018 £29,140
Real Return on Investment %   (0.99%) 7.81% 16.70% 25.69% 34.78% 43.97% 53.28% 62.71% 72.27% 81.96% 91.79%