NG20 Shirebrook, Market Warsop cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £127,016
Input Equity (£31,754)
Total Input Equity (£31,754)
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 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016 £127,016
Finance Amount £95,262 £95,262 £92,416 £89,425 £86,280 £82,975 £79,501 £75,849 £72,010 £67,974 £63,732 £59,273
Monthly Mortgage   (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629)
Monthly Rental   £498 £498 £498 £498 £498 £498 £498 £498 £498 £498 £498
Yield to Purchase Price %   4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71%
Yield to Property Value %   4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71%
Gross Monthly Cashflow   (£131) (£131) (£131) (£131) (£131) (£131) (£131) (£131) (£131) (£131) (£131)
Gross Annual Cashflow   (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567) (£1,567)
Gross Annual Expenses                        
Annual Management Expenses   (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335) (£335)
Gross Annual Cashflow less Expenses   (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865)
Vacancy Expenses                        
Net Annual Cashflow   (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865) (£1,865)
Net Yield %   (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%)
Debt Coverage Ratio (1:x)   0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75
Personal Equity £31,754 £31,754 £34,600 £37,591 £40,736 £44,041 £47,515 £51,167 £55,006 £59,042 £63,284 £67,743
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   (£1,901) £944 £3,936 £7,080 £10,386 £13,860 £17,512 £21,351 £25,386 £29,628 £34,087
Return on Investment %   (5.99%) 2.97% 12.39% 22.30% 32.71% 43.65% 55.15% 67.24% 79.95% 93.31% 107.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   (£1,901) £926 £3,780 £6,664 £9,579 £12,528 £15,513 £18,535 £21,598 £24,703 £27,852
Real Return on Investment %   (5.99%) 2.91% 11.90% 20.99% 30.17% 39.45% 48.85% 58.37% 68.02% 77.79% 87.71%