ME10 Sittingbourne cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £214,051
Input Equity (£53,513)
Total Input Equity (£53,513)
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 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051 £214,051
Finance Amount £160,538 £160,538 £155,742 £150,701 £145,402 £139,832 £133,977 £127,822 £121,353 £114,552 £107,404 £99,889
Monthly Mortgage   (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059)
Monthly Rental   £791 £791 £791 £791 £791 £791 £791 £791 £791 £791 £791
Yield to Purchase Price %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Yield to Property Value %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Gross Monthly Cashflow   (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269) (£269)
Gross Annual Cashflow   (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224) (£3,224)
Gross Annual Expenses                        
Annual Management Expenses   (£531) (£531) (£531) (£531) (£531) (£531) (£531) (£531) (£531) (£531) (£531)
Gross Annual Cashflow less Expenses   (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698)
Vacancy Expenses                        
Net Annual Cashflow   (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698) (£3,698)
Net Yield %   (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%)
Debt Coverage Ratio (1:x)   0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71
Personal Equity £53,513 £53,513 £58,309 £63,350 £68,649 £74,219 £80,074 £86,229 £92,698 £99,499 £106,647 £114,162
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,755) £1,041 £6,082 £11,381 £16,951 £22,806 £28,961 £35,430 £42,231 £49,379 £56,894
Return on Investment %   (7.02%) 1.94% 11.36% 21.27% 31.68% 42.62% 54.12% 66.21% 78.92% 92.28% 106.32%
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,755) £1,020 £5,841 £10,711 £15,635 £20,615 £25,655 £30,758 £35,928 £41,170 £46,486
Real Return on Investment %   (7.02%) 1.91% 10.91% 20.02% 29.22% 38.52% 47.94% 57.48% 67.14% 76.93% 86.87%