M28 Worsley, Walkden, Boothstown, Mosley Common, Wardley Industrial Estate cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £176,470
Input Equity (£44,118)
Total Input Equity (£44,118)
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 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470 £176,470
Finance Amount £132,353 £132,353 £128,399 £124,243 £119,874 £115,282 £110,455 £105,380 £100,047 £94,440 £88,547 £82,352
Monthly Mortgage   (£873) (£873) (£873) (£873) (£873) (£873) (£873) (£873) (£873) (£873) (£873)
Monthly Rental   £660 £660 £660 £660 £660 £660 £660 £660 £660 £660 £660
Yield to Purchase Price %   4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49%
Yield to Property Value %   4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49% 4.49%
Gross Monthly Cashflow   (£213) (£213) (£213) (£213) (£213) (£213) (£213) (£213) (£213) (£213) (£213)
Gross Annual Cashflow   (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560) (£2,560)
Gross Annual Expenses                        
Annual Management Expenses   (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444)
Gross Annual Cashflow less Expenses   (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956)
Vacancy Expenses                        
Net Annual Cashflow   (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956) (£2,956)
Net Yield %   (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%) (1.68%)
Debt Coverage Ratio (1:x)   0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72
Personal Equity £44,118 £44,118 £48,071 £52,227 £56,596 £61,188 £66,015 £71,090 £76,423 £82,030 £87,923 £94,118
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   (£3,003) £950 £5,106 £9,475 £14,067 £18,894 £23,969 £29,302 £34,909 £40,802 £46,997
Return on Investment %   (6.81%) 2.15% 11.57% 21.48% 31.89% 42.83% 54.33% 66.42% 79.13% 92.49% 106.53%
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   (£3,003) £931 £4,904 £8,918 £12,975 £17,079 £21,232 £25,438 £29,699 £34,019 £38,400
Real Return on Investment %   (6.81%) 2.11% 11.12% 20.21% 29.41% 38.71% 48.13% 57.66% 67.32% 77.11% 87.04%