NE38 Washington Town Centre, Oxclose, Fatfield cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £143,267
Input Equity (£35,817)
Total Input Equity (£35,817)
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 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267 £143,267
Finance Amount £107,450 £107,450 £104,240 £100,866 £97,320 £93,591 £89,672 £85,553 £81,223 £76,671 £71,887 £66,857
Monthly Mortgage   (£709) (£709) (£709) (£709) (£709) (£709) (£709) (£709) (£709) (£709) (£709)
Monthly Rental   £569 £569 £569 £569 £569 £569 £569 £569 £569 £569 £569
Yield to Purchase Price %   4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77%
Yield to Property Value %   4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77% 4.77%
Gross Monthly Cashflow   (£140) (£140) (£140) (£140) (£140) (£140) (£140) (£140) (£140) (£140) (£140)
Gross Annual Cashflow   (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682) (£1,682)
Gross Annual Expenses                        
Annual Management Expenses   (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382) (£382)
Gross Annual Cashflow less Expenses   (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023)
Vacancy Expenses                        
Net Annual Cashflow   (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023) (£2,023)
Net Yield %   (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%) (1.41%)
Debt Coverage Ratio (1:x)   0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76
Personal Equity £35,817 £35,817 £39,027 £42,401 £45,947 £49,676 £53,595 £57,714 £62,044 £66,596 £71,380 £76,410
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   (£2,064) £1,146 £4,520 £8,067 £11,795 £15,714 £19,833 £24,163 £28,715 £33,500 £38,529
Return on Investment %   (5.76%) 3.20% 12.62% 22.52% 32.93% 43.87% 55.37% 67.46% 80.17% 93.53% 107.57%
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   (£2,064) £1,123 £4,341 £7,592 £10,879 £14,204 £17,569 £20,977 £24,430 £27,930 £31,481
Real Return on Investment %   (5.76%) 3.14% 12.12% 21.20% 30.37% 39.66% 49.05% 58.57% 68.21% 77.98% 87.89%