NG11 Clifton, Ruddington, Gotham cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £221,644
Input Equity (£55,411)
Total Input Equity (£55,411)
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 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644 £221,644
Finance Amount £166,233 £166,233 £161,267 £156,047 £150,560 £144,792 £138,730 £132,357 £125,657 £118,616 £111,214 £103,433
Monthly Mortgage   (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097)
Monthly Rental   £694 £694 £694 £694 £694 £694 £694 £694 £694 £694 £694
Yield to Purchase Price %   3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76%
Yield to Property Value %   3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76% 3.76%
Gross Monthly Cashflow   (£403) (£403) (£403) (£403) (£403) (£403) (£403) (£403) (£403) (£403) (£403)
Gross Annual Cashflow   (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837) (£4,837)
Gross Annual Expenses                        
Annual Management Expenses   (£466) (£466) (£466) (£466) (£466) (£466) (£466) (£466) (£466) (£466) (£466)
Gross Annual Cashflow less Expenses   (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253)
Vacancy Expenses                        
Net Annual Cashflow   (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253) (£5,253)
Net Yield %   (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%) (2.37%)
Debt Coverage Ratio (1:x)   0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60
Personal Equity £55,411 £55,411 £60,377 £65,597 £71,084 £76,852 £82,914 £89,288 £95,987 £103,028 £110,431 £118,211
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   (£5,303) (£337) £4,882 £10,370 £16,137 £22,200 £28,573 £35,272 £42,314 £49,716 £57,497
Return on Investment %   (9.57%) (0.61%) 8.81% 18.71% 29.12% 40.06% 51.57% 63.66% 76.36% 89.72% 103.76%
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   (£5,303) (£331) £4,689 £9,760 £14,885 £20,067 £25,311 £30,621 £35,999 £41,451 £46,979
Real Return on Investment %   (9.57%) (0.60%) 8.46% 17.61% 26.86% 36.22% 45.68% 55.26% 64.97% 74.81% 84.78%