NE67 Benthall cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £321,621
Input Equity (£80,405)
Total Input Equity (£80,405)
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 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621 £321,621
Finance Amount £241,216 £241,216 £234,010 £226,435 £218,473 £210,104 £201,306 £192,059 £182,338 £172,120 £161,379 £150,088
Monthly Mortgage   (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592)
Monthly Rental   £892 £892 £892 £892 £892 £892 £892 £892 £892 £892 £892
Yield to Purchase Price %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Yield to Property Value %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Gross Monthly Cashflow   (£699) (£699) (£699) (£699) (£699) (£699) (£699) (£699) (£699) (£699) (£699)
Gross Annual Cashflow   (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393) (£8,393)
Gross Annual Expenses                        
Annual Management Expenses   (£600) (£600) (£600) (£600) (£600) (£600) (£600) (£600) (£600) (£600) (£600)
Gross Annual Cashflow less Expenses   (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929)
Vacancy Expenses                        
Net Annual Cashflow   (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929) (£8,929)
Net Yield %   (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%) (2.78%)
Debt Coverage Ratio (1:x)   0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
Personal Equity £80,405 £80,405 £87,611 £95,186 £103,148 £111,517 £120,315 £129,562 £139,283 £149,501 £160,242 £171,533
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   (£8,993) (£1,787) £5,787 £13,749 £22,119 £30,916 £40,164 £49,885 £60,103 £70,844 £82,135
Return on Investment %   (11.18%) (2.22%) 7.20% 17.10% 27.51% 38.45% 49.95% 62.04% 74.75% 88.11% 102.15%
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   (£8,993) (£1,751) £5,558 £12,941 £20,402 £27,946 £35,579 £43,306 £51,133 £59,066 £67,110
Real Return on Investment %   (11.18%) (2.18%) 6.91% 16.09% 25.37% 34.76% 44.25% 53.86% 63.59% 73.46% 83.46%