NG1 Nottingham City Centre cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £116,090
Input Equity (£29,023)
Total Input Equity (£29,023)
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 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090 £116,090
Finance Amount £87,068 £87,068 £84,467 £81,732 £78,859 £75,838 £72,662 £69,324 £65,815 £62,127 £58,250 £54,175
Monthly Mortgage   (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575)
Monthly Rental   £583 £583 £583 £583 £583 £583 £583 £583 £583 £583 £583
Yield to Purchase Price %   6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02%
Yield to Property Value %   6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02% 6.02%
Gross Monthly Cashflow   £8 £8 £8 £8 £8 £8 £8 £8 £8 £8 £8
Gross Annual Cashflow   £99 £99 £99 £99 £99 £99 £99 £99 £99 £99 £99
Gross Annual Expenses                        
Annual Management Expenses   (£392) (£392) (£392) (£392) (£392) (£392) (£392) (£392) (£392) (£392) (£392)
Gross Annual Cashflow less Expenses   (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251)
Vacancy Expenses                        
Net Annual Cashflow   (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251)
Taxable Income   £99 £99 £99 £99 £99 £99 £99 £99 £99 £99 £99
Tax Payable                        
Net Annual Cashflow Less Tax   (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251) (£251)
Net Yield %   (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%) (0.22%)
Debt Coverage Ratio (1:x)   0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96 0.96
Personal Equity £29,023 £29,023 £31,623 £34,358 £37,231 £40,252 £43,428 £46,766 £50,275 £53,963 £57,840 £61,915
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   (£293) £2,308 £5,042 £7,916 £10,937 £14,113 £17,451 £20,959 £24,648 £28,525 £32,600
Return on Investment %   (1.01%) 7.95% 17.37% 27.28% 37.68% 48.63% 60.13% 72.22% 84.93% 98.28% 112.33%
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   (£293) £2,262 £4,842 £7,451 £10,088 £12,757 £15,458 £18,195 £20,969 £23,782 £26,636
Real Return on Investment %   (1.01%) 7.79% 16.69% 25.67% 34.76% 43.95% 53.26% 62.69% 72.25% 81.94% 91.78%