M43 Droylsden cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £122,781
Input Equity (£30,695)
Input Equity FX (£30,695)
Total Input Equity (£30,695)
Total Input Equity FX (£30,695)
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 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781 £122,781
Finance Amount £92,086 £92,086 £89,335 £86,443 £83,404 £80,209 £76,850 £73,320 £69,609 £65,708 £61,607 £57,297
Monthly Mortgage   (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608)
Monthly Rental   £570 £570 £570 £570 £570 £570 £570 £570 £570 £570 £570
Yield to Purchase Price %   5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57%
Yield to Property Value %   5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57% 5.57%
Gross Monthly Cashflow   (£38) (£38) (£38) (£38) (£38) (£38) (£38) (£38) (£38) (£38) (£38)
Gross Annual Cashflow   (£454) (£454) (£454) (£454) (£454) (£454) (£454) (£454) (£454) (£454) (£454)
Gross Annual Expenses                        
Annual Management Expenses   (£383) (£383) (£383) (£383) (£383) (£383) (£383) (£383) (£383) (£383) (£383)
Gross Annual Cashflow less Expenses   (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796)
Vacancy Expenses                        
Net Annual Cashflow   (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796) (£796)
Net Yield %   (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%) (0.65%)
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 £30,695 £30,695 £33,446 £36,338 £39,377 £42,572 £45,931 £49,461 £53,172 £57,073 £61,174 £65,484
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   (£837) £1,914 £4,806 £7,845 £11,041 £14,399 £17,929 £21,640 £25,541 £29,642 £33,952
Return on Investment %   (2.73%) 6.24% 15.66% 25.56% 35.97% 46.91% 58.41% 70.50% 83.21% 96.57% 110.61%
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   (£837) £1,876 £4,616 £7,384 £10,183 £13,016 £15,883 £18,787 £21,730 £24,714 £27,741
Real Return on Investment %   (2.73%) 6.11% 15.04% 24.06% 33.18% 42.40% 51.74% 61.20% 70.79% 80.51% 90.38%