ME19 West Malling cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £389,147
Input Equity (£97,287)
Total Input Equity (£97,287)
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 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147 £389,147
Finance Amount £291,860 £291,860 £283,141 £273,977 £264,343 £254,216 £243,572 £232,382 £220,620 £208,257 £195,261 £181,600
Monthly Mortgage   (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926) (£1,926)
Monthly Rental   £1,038 £1,038 £1,038 £1,038 £1,038 £1,038 £1,038 £1,038 £1,038 £1,038 £1,038
Yield to Purchase Price %   3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20%
Yield to Property Value %   3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20% 3.20%
Gross Monthly Cashflow   (£889) (£889) (£889) (£889) (£889) (£889) (£889) (£889) (£889) (£889) (£889)
Gross Annual Cashflow   (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664) (£10,664)
Gross Annual Expenses                        
Annual Management Expenses   (£697) (£697) (£697) (£697) (£697) (£697) (£697) (£697) (£697) (£697) (£697)
Gross Annual Cashflow less Expenses   (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286)
Vacancy Expenses                        
Net Annual Cashflow   (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286) (£11,286)
Net Yield %   (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%) (2.90%)
Debt Coverage Ratio (1:x)   0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51
Personal Equity £97,287 £97,287 £106,006 £115,170 £124,804 £134,931 £145,575 £156,765 £168,527 £180,890 £193,886 £207,547
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   (£11,361) (£2,642) £6,523 £16,156 £26,283 £36,928 £48,117 £59,879 £72,242 £85,239 £98,900
Return on Investment %   (11.68%) (2.72%) 6.70% 16.61% 27.02% 37.96% 49.46% 61.55% 74.26% 87.62% 101.66%
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   (£11,361) (£2,589) £6,264 £15,206 £24,243 £33,380 £42,624 £51,982 £61,461 £71,067 £80,808
Real Return on Investment %   (11.68%) (2.66%) 6.44% 15.63% 24.92% 34.31% 43.81% 53.43% 63.18% 73.05% 83.06%