NE61 Morpeth, Tranwell, Clifton Hepscott cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £292,830
Input Equity (£73,208)
Total Input Equity (£73,208)
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 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830 £292,830
Finance Amount £219,623 £219,623 £213,062 £206,165 £198,916 £191,296 £183,286 £174,866 £166,015 £156,712 £146,932 £136,652
Monthly Mortgage   (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449)
Monthly Rental   £517 £517 £517 £517 £517 £517 £517 £517 £517 £517 £517
Yield to Purchase Price %   2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12%
Yield to Property Value %   2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12% 2.12%
Gross Monthly Cashflow   (£932) (£932) (£932) (£932) (£932) (£932) (£932) (£932) (£932) (£932) (£932)
Gross Annual Cashflow   (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187) (£11,187)
Gross Annual Expenses                        
Annual Management Expenses   (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348)
Gross Annual Cashflow less Expenses   (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498)
Vacancy Expenses                        
Net Annual Cashflow   (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498) (£11,498)
Net Yield %   (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%) (3.93%)
Debt Coverage Ratio (1:x)   0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34 0.34
Personal Equity £73,208 £73,208 £79,768 £86,665 £93,914 £101,534 £109,544 £117,964 £126,815 £136,118 £145,898 £156,178
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,535) (£4,974) £1,922 £9,172 £16,792 £24,802 £33,222 £42,072 £51,376 £61,155 £71,435
Return on Investment %   (15.76%) (6.79%) 2.63% 12.53% 22.94% 33.88% 45.38% 57.47% 70.18% 83.54% 97.58%
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,535) (£4,875) £1,846 £8,632 £15,488 £22,419 £29,429 £36,524 £43,709 £50,988 £58,368
Real Return on Investment %   (15.76%) (6.66%) 2.52% 11.79% 21.16% 30.62% 40.20% 49.89% 59.71% 69.65% 79.73%