ME20 Aylesford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £312,447
Input Equity (£78,112)
Total Input Equity (£78,112)
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 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447 £312,447
Finance Amount £234,335 £234,335 £227,335 £219,976 £212,242 £204,111 £195,564 £186,580 £177,137 £167,210 £156,775 £145,807
Monthly Mortgage   (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547) (£1,547)
Monthly Rental   £897 £897 £897 £897 £897 £897 £897 £897 £897 £897 £897
Yield to Purchase Price %   3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45%
Yield to Property Value %   3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45% 3.45%
Gross Monthly Cashflow   (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649)
Gross Annual Cashflow   (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790) (£7,790)
Gross Annual Expenses                        
Annual Management Expenses   (£603) (£603) (£603) (£603) (£603) (£603) (£603) (£603) (£603) (£603) (£603)
Gross Annual Cashflow less Expenses   (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328)
Vacancy Expenses                        
Net Annual Cashflow   (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328) (£8,328)
Net Yield %   (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £78,112 £78,112 £85,112 £92,471 £100,205 £108,336 £116,883 £125,867 £135,310 £145,237 £155,672 £166,640
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   (£8,393) (£1,392) £5,966 £13,701 £21,832 £30,378 £39,362 £48,806 £58,733 £69,167 £80,136
Return on Investment %   (10.74%) (1.78%) 7.64% 17.54% 27.95% 38.89% 50.39% 62.48% 75.19% 88.55% 102.59%
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   (£8,393) (£1,365) £5,730 £12,895 £20,137 £27,460 £34,869 £42,370 £49,968 £57,668 £65,477
Real Return on Investment %   (10.74%) (1.75%) 7.34% 16.51% 25.78% 35.15% 44.64% 54.24% 63.97% 73.83% 83.82%