N16 Stoke Newington, Stamford Hill, Shacklewell, Dalston, Newington Green cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £528,579
Input Equity (£132,145)
Total Input Equity (£132,145)
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 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579 £528,579
Finance Amount £396,434 £396,434 £384,592 £372,143 £359,057 £345,302 £330,844 £315,645 £299,669 £282,876 £265,223 £246,667
Monthly Mortgage   (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616) (£2,616)
Monthly Rental   £1,627 £1,627 £1,627 £1,627 £1,627 £1,627 £1,627 £1,627 £1,627 £1,627 £1,627
Yield to Purchase Price %   3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69%
Yield to Property Value %   3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69% 3.69%
Gross Monthly Cashflow   (£989) (£989) (£989) (£989) (£989) (£989) (£989) (£989) (£989) (£989) (£989)
Gross Annual Cashflow   (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869) (£11,869)
Gross Annual Expenses                        
Annual Management Expenses   (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093)
Gross Annual Cashflow less Expenses   (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845)
Vacancy Expenses                        
Net Annual Cashflow   (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845) (£12,845)
Net Yield %   (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%) (2.43%)
Debt Coverage Ratio (1:x)   0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59
Personal Equity £132,145 £132,145 £143,987 £156,436 £169,522 £183,277 £197,735 £212,934 £228,910 £245,703 £263,356 £281,912
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   (£12,962) (£1,120) £11,329 £24,414 £38,169 £52,628 £67,827 £83,803 £100,596 £118,249 £136,804
Return on Investment %   (9.81%) (0.85%) 8.57% 18.48% 28.88% 39.83% 51.33% 63.42% 76.13% 89.48% 103.53%
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   (£12,962) (£1,097) £10,880 £22,979 £35,206 £47,572 £60,084 £72,751 £85,583 £98,590 £111,779
Real Return on Investment %   (9.81%) (0.83%) 8.23% 17.39% 26.64% 36.00% 45.47% 55.05% 64.76% 74.61% 84.59%