NN5 Duston, New Duston cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £179,062
Input Equity (£44,766)
Total Input Equity (£44,766)
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 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062 £179,062
Finance Amount £134,297 £134,297 £130,285 £126,068 £121,635 £116,975 £112,077 £106,928 £101,516 £95,827 £89,847 £83,561
Monthly Mortgage   (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886)
Monthly Rental   £727 £727 £727 £727 £727 £727 £727 £727 £727 £727 £727
Yield to Purchase Price %   4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87%
Yield to Property Value %   4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87%
Gross Monthly Cashflow   (£159) (£159) (£159) (£159) (£159) (£159) (£159) (£159) (£159) (£159) (£159)
Gross Annual Cashflow   (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912) (£1,912)
Gross Annual Expenses                        
Annual Management Expenses   (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489) (£489)
Gross Annual Cashflow less Expenses   (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348)
Vacancy Expenses                        
Net Annual Cashflow   (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348) (£2,348)
Net Yield %   (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%)
Debt Coverage Ratio (1:x)   0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78
Personal Equity £44,766 £44,766 £48,777 £52,994 £57,427 £62,087 £66,985 £72,134 £77,546 £83,235 £89,215 £95,501
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,400) £1,611 £5,829 £10,261 £14,921 £19,819 £24,968 £30,380 £36,069 £42,049 £48,335
Return on Investment %   (5.36%) 3.60% 13.02% 22.92% 33.33% 44.27% 55.77% 67.86% 80.57% 93.93% 107.97%
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,400) £1,579 £5,598 £9,658 £13,763 £17,915 £22,117 £26,373 £30,686 £35,058 £39,493
Real Return on Investment %   (5.36%) 3.53% 12.50% 21.57% 30.74% 40.02% 49.41% 58.91% 68.55% 78.31% 88.22%