M50 Salford Quays cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £147,733
Input Equity (£36,933)
Total Input Equity (£36,933)
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 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733 £147,733
Finance Amount £110,800 £110,800 £107,490 £104,011 £100,353 £96,509 £92,468 £88,220 £83,755 £79,061 £74,127 £68,941
Monthly Mortgage   (£731) (£731) (£731) (£731) (£731) (£731) (£731) (£731) (£731) (£731) (£731)
Monthly Rental   £651 £651 £651 £651 £651 £651 £651 £651 £651 £651 £651
Yield to Purchase Price %   5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29%
Yield to Property Value %   5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29% 5.29%
Gross Monthly Cashflow   (£80) (£80) (£80) (£80) (£80) (£80) (£80) (£80) (£80) (£80) (£80)
Gross Annual Cashflow   (£960) (£960) (£960) (£960) (£960) (£960) (£960) (£960) (£960) (£960) (£960)
Gross Annual Expenses                        
Annual Management Expenses   (£438) (£438) (£438) (£438) (£438) (£438) (£438) (£438) (£438) (£438) (£438)
Gross Annual Cashflow less Expenses   (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351)
Vacancy Expenses                        
Net Annual Cashflow   (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351) (£1,351)
Net Yield %   (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%) (0.91%)
Debt Coverage Ratio (1:x)   0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85 0.85
Personal Equity £36,933 £36,933 £40,243 £43,722 £47,380 £51,224 £55,265 £59,513 £63,978 £68,672 £73,606 £78,792
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,398) £1,912 £5,391 £9,049 £12,893 £16,934 £21,182 £25,647 £30,341 £35,275 £40,461
Return on Investment %   (3.78%) 5.18% 14.60% 24.50% 34.91% 45.85% 57.35% 69.44% 82.15% 95.51% 109.55%
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,398) £1,874 £5,178 £8,517 £11,892 £15,307 £18,764 £22,265 £25,813 £29,410 £33,059
Real Return on Investment %   (3.78%) 5.07% 14.02% 23.06% 32.20% 41.45% 50.81% 60.28% 69.89% 79.63% 89.51%