ME11 Queenborough, Rushenden cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £147,037
Input Equity (£36,759)
Total Input Equity (£36,759)
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,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037 £147,037
Finance Amount £110,278 £110,278 £106,983 £103,521 £99,880 £96,054 £92,032 £87,804 £83,360 £78,689 £73,778 £68,616
Monthly Mortgage   (£728) (£728) (£728) (£728) (£728) (£728) (£728) (£728) (£728) (£728) (£728)
Monthly Rental   £845 £845 £845 £845 £845 £845 £845 £845 £845 £845 £845
Yield to Purchase Price %   6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89%
Yield to Property Value %   6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89% 6.89%
Gross Monthly Cashflow   £117 £117 £117 £117 £117 £117 £117 £117 £117 £117 £117
Gross Annual Cashflow   £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401
Gross Annual Expenses                        
Annual Management Expenses   (£568) (£568) (£568) (£568) (£568) (£568) (£568) (£568) (£568) (£568) (£568)
Gross Annual Cashflow less Expenses   £895 £895 £895 £895 £895 £895 £895 £895 £895 £895 £895
Vacancy Expenses                        
Net Annual Cashflow   £895 £895 £895 £895 £895 £895 £895 £895 £895 £895 £895
Taxable Income   £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401 £1,401
Tax Payable                        
Net Annual Cashflow Less Tax   £895 £895 £895 £895 £895 £895 £895 £895 £895 £895 £895
Net Yield %   0.61% 0.61% 0.61% 0.61% 0.61% 0.61% 0.61% 0.61% 0.61% 0.61% 0.61%
Debt Coverage Ratio (1:x)   1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10 1.10
Personal Equity £36,759 £36,759 £40,054 £43,516 £47,157 £50,983 £55,005 £59,233 £63,677 £68,348 £73,259 £78,421
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   £834 £4,128 £7,591 £11,231 £15,057 £19,079 £23,307 £27,751 £32,423 £37,333 £42,495
Return on Investment %   2.27% 11.23% 20.65% 30.55% 40.96% 51.90% 63.40% 75.49% 88.20% 101.56% 115.60%
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   £834 £4,046 £7,290 £10,571 £13,888 £17,246 £20,646 £24,092 £27,584 £31,127 £34,722
Real Return on Investment %   2.27% 11.01% 19.83% 28.76% 37.78% 46.92% 56.17% 65.54% 75.04% 84.68% 94.46%