M24 Middleton, Alkrington cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £133,541
Input Equity (£33,385)
Total Input Equity (£33,385)
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 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541 £133,541
Finance Amount £100,156 £100,156 £97,164 £94,019 £90,713 £87,238 £83,585 £79,745 £75,709 £71,466 £67,006 £62,318
Monthly Mortgage   (£661) (£661) (£661) (£661) (£661) (£661) (£661) (£661) (£661) (£661) (£661)
Monthly Rental   £528 £528 £528 £528 £528 £528 £528 £528 £528 £528 £528
Yield to Purchase Price %   4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74%
Yield to Property Value %   4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74% 4.74%
Gross Monthly Cashflow   (£133) (£133) (£133) (£133) (£133) (£133) (£133) (£133) (£133) (£133) (£133)
Gross Annual Cashflow   (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600) (£1,600)
Gross Annual Expenses                        
Annual Management Expenses   (£355) (£355) (£355) (£355) (£355) (£355) (£355) (£355) (£355) (£355) (£355)
Gross Annual Cashflow less Expenses   (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917)
Vacancy Expenses                        
Net Annual Cashflow   (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917) (£1,917)
Net Yield %   (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%) (1.44%)
Debt Coverage Ratio (1:x)   0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76
Personal Equity £33,385 £33,385 £36,377 £39,522 £42,828 £46,303 £49,956 £53,796 £57,832 £62,075 £66,535 £71,223
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,955) £1,037 £4,182 £7,488 £10,963 £14,616 £18,456 £22,492 £26,735 £31,195 £35,883
Return on Investment %   (5.85%) 3.11% 12.53% 22.43% 32.84% 43.78% 55.28% 67.37% 80.08% 93.44% 107.48%
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,955) £1,017 £4,017 £7,048 £10,112 £13,212 £16,349 £19,526 £22,745 £26,009 £29,319
Real Return on Investment %   (5.85%) 3.05% 12.03% 21.11% 30.29% 39.57% 48.97% 58.49% 68.13% 77.90% 87.82%