M23 Baguley, Roundthorn Industrial Estate cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £146,511
Input Equity (£36,628)
Total Input Equity (£36,628)
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 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511 £146,511
Finance Amount £109,883 £109,883 £106,601 £103,150 £99,523 £95,711 £91,703 £87,490 £83,062 £78,407 £73,514 £68,371
Monthly Mortgage   (£725) (£725) (£725) (£725) (£725) (£725) (£725) (£725) (£725) (£725) (£725)
Monthly Rental   £679 £679 £679 £679 £679 £679 £679 £679 £679 £679 £679
Yield to Purchase Price %   5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56%
Yield to Property Value %   5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56% 5.56%
Gross Monthly Cashflow   (£46) (£46) (£46) (£46) (£46) (£46) (£46) (£46) (£46) (£46) (£46)
Gross Annual Cashflow   (£556) (£556) (£556) (£556) (£556) (£556) (£556) (£556) (£556) (£556) (£556)
Gross Annual Expenses                        
Annual Management Expenses   (£456) (£456) (£456) (£456) (£456) (£456) (£456) (£456) (£456) (£456) (£456)
Gross Annual Cashflow less Expenses   (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964)
Vacancy Expenses                        
Net Annual Cashflow   (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964) (£964)
Net Yield %   (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%)
Debt Coverage Ratio (1:x)   0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89
Personal Equity £36,628 £36,628 £39,910 £43,361 £46,988 £50,800 £54,808 £59,021 £63,449 £68,104 £72,997 £78,140
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,012) £2,270 £5,721 £9,348 £13,160 £17,168 £21,381 £25,809 £30,464 £35,357 £40,500
Return on Investment %   (2.76%) 6.20% 15.62% 25.52% 35.93% 46.87% 58.37% 70.46% 83.17% 96.53% 110.57%
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,012) £2,225 £5,494 £8,798 £12,139 £15,518 £18,940 £22,405 £25,917 £29,478 £33,091
Real Return on Investment %   (2.76%) 6.07% 15.00% 24.02% 33.14% 42.37% 51.71% 61.17% 70.76% 80.48% 90.34%