MK8 Crownhill, Grange Farm, Great Holm, Hazeley, Loughton, Loughton Lodge, Two Mile Ash, Wymbush cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £255,449
Input Equity (£63,862)
Input Equity FX (£63,862)
Total Input Equity (£63,862)
Total Input Equity FX (£63,862)
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 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449 £255,449
Finance Amount £191,587 £191,587 £185,863 £179,847 £173,523 £166,876 £159,888 £152,543 £144,823 £136,707 £128,176 £119,208
Monthly Mortgage   (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264) (£1,264)
Monthly Rental   £966 £966 £966 £966 £966 £966 £966 £966 £966 £966 £966
Yield to Purchase Price %   4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54%
Yield to Property Value %   4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54% 4.54%
Gross Monthly Cashflow   (£299) (£299) (£299) (£299) (£299) (£299) (£299) (£299) (£299) (£299) (£299)
Gross Annual Cashflow   (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583) (£3,583)
Gross Annual Expenses                        
Annual Management Expenses   (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649)
Gross Annual Cashflow less Expenses   (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163)
Vacancy Expenses                        
Net Annual Cashflow   (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163) (£4,163)
Net Yield %   (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%) (1.63%)
Debt Coverage Ratio (1:x)   0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73 0.73
Personal Equity £63,862 £63,862 £69,586 £75,602 £81,926 £88,573 £95,561 £102,906 £110,626 £118,742 £127,273 £136,241
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   (£4,232) £1,491 £7,507 £13,831 £20,479 £27,466 £34,811 £42,532 £50,648 £59,179 £68,146
Return on Investment %   (6.63%) 2.34% 11.76% 21.66% 32.07% 43.01% 54.51% 66.60% 79.31% 92.67% 106.71%
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   (£4,232) £1,461 £7,210 £13,018 £18,889 £24,827 £30,837 £36,923 £43,089 £49,340 £55,681
Real Return on Investment %   (6.63%) 2.29% 11.29% 20.38% 29.58% 38.88% 48.29% 57.82% 67.47% 77.26% 87.19%