NE45 Corbridge, Dilston, Aydon, Halton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £479,855
Input Equity (£119,964)
Input Equity FX (£119,964)
Total Input Equity (£119,964)
Total Input Equity FX (£119,964)
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 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855 £479,855
Finance Amount £359,891 £359,891 £349,140 £337,839 £325,960 £313,473 £300,347 £286,549 £272,046 £256,800 £240,775 £223,930
Monthly Mortgage   (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375) (£2,375)
Monthly Rental   £829 £829 £829 £829 £829 £829 £829 £829 £829 £829 £829
Yield to Purchase Price %   2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07%
Yield to Property Value %   2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07% 2.07%
Gross Monthly Cashflow   (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546) (£1,546)
Gross Annual Cashflow   (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549) (£18,549)
Gross Annual Expenses                        
Annual Management Expenses   (£557) (£557) (£557) (£557) (£557) (£557) (£557) (£557) (£557) (£557) (£557)
Gross Annual Cashflow less Expenses   (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047)
Vacancy Expenses                        
Net Annual Cashflow   (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047) (£19,047)
Net Yield %   (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%) (3.97%)
Debt Coverage Ratio (1:x)   0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33
Personal Equity £119,964 £119,964 £130,715 £142,016 £153,895 £166,382 £179,508 £193,306 £207,809 £223,055 £239,080 £255,925
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   (£19,106) (£8,355) £2,946 £14,825 £27,312 £40,438 £54,236 £68,739 £83,984 £100,010 £116,855
Return on Investment %   (15.93%) (6.96%) 2.46% 12.36% 22.77% 33.71% 45.21% 57.30% 70.01% 83.37% 97.41%
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   (£19,106) (£8,188) £2,829 £13,953 £25,192 £36,553 £48,044 £59,674 £71,451 £83,383 £95,479
Real Return on Investment %   (15.93%) (6.83%) 2.36% 11.63% 21.00% 30.47% 40.05% 49.74% 59.56% 69.51% 79.59%