M35 Failsworth, Castle Industrial Estate cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £114,869
Input Equity (£28,717)
Input Equity FX (£28,717)
Total Input Equity (£28,717)
Total Input Equity FX (£28,717)
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 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869 £114,869
Finance Amount £86,152 £86,152 £83,578 £80,873 £78,029 £75,040 £71,898 £68,595 £65,123 £61,474 £57,637 £53,605
Monthly Mortgage   (£569) (£569) (£569) (£569) (£569) (£569) (£569) (£569) (£569) (£569) (£569)
Monthly Rental   £552 £552 £552 £552 £552 £552 £552 £552 £552 £552 £552
Yield to Purchase Price %   5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77%
Yield to Property Value %   5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77% 5.77%
Gross Monthly Cashflow   (£16) (£16) (£16) (£16) (£16) (£16) (£16) (£16) (£16) (£16) (£16)
Gross Annual Cashflow   (£194) (£194) (£194) (£194) (£194) (£194) (£194) (£194) (£194) (£194) (£194)
Gross Annual Expenses                        
Annual Management Expenses   (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371)
Gross Annual Cashflow less Expenses   (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525)
Vacancy Expenses                        
Net Annual Cashflow   (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525)
Net Yield %   (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%) (0.46%)
Debt Coverage Ratio (1:x)   0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92
Personal Equity £28,717 £28,717 £31,291 £33,996 £36,840 £39,829 £42,971 £46,274 £49,746 £53,395 £57,232 £61,264
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   (£565) £2,009 £4,714 £7,558 £10,547 £13,689 £16,992 £20,464 £24,113 £27,950 £31,982
Return on Investment %   (1.97%) 7.00% 16.42% 26.32% 36.73% 47.67% 59.17% 71.26% 83.97% 97.33% 111.37%
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   (£565) £1,969 £4,527 £7,113 £9,728 £12,374 £15,052 £17,765 £20,515 £23,303 £26,132
Real Return on Investment %   (1.97%) 6.86% 15.77% 24.77% 33.88% 43.09% 52.42% 61.86% 71.44% 81.15% 91.00%