NE29 North Shields, Royal Quays, Billy Mill, New York cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £105,371
Input Equity (£26,343)
Total Input Equity (£26,343)
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 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371 £105,371
Finance Amount £79,028 £79,028 £76,667 £74,186 £71,577 £68,835 £65,953 £62,923 £59,738 £56,391 £52,872 £49,173
Monthly Mortgage   (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522)
Monthly Rental   £470 £470 £470 £470 £470 £470 £470 £470 £470 £470 £470
Yield to Purchase Price %   5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35%
Yield to Property Value %   5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35% 5.35%
Gross Monthly Cashflow   (£52) (£52) (£52) (£52) (£52) (£52) (£52) (£52) (£52) (£52) (£52)
Gross Annual Cashflow   (£622) (£622) (£622) (£622) (£622) (£622) (£622) (£622) (£622) (£622) (£622)
Gross Annual Expenses                        
Annual Management Expenses   (£316) (£316) (£316) (£316) (£316) (£316) (£316) (£316) (£316) (£316) (£316)
Gross Annual Cashflow less Expenses   (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904)
Vacancy Expenses                        
Net Annual Cashflow   (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904) (£904)
Net Yield %   (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%) (0.86%)
Debt Coverage Ratio (1:x)   0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86
Personal Equity £26,343 £26,343 £28,704 £31,185 £33,794 £36,536 £39,418 £42,448 £45,633 £48,980 £52,499 £56,198
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   (£938) £1,423 £3,905 £6,513 £9,256 £12,138 £15,168 £18,352 £21,700 £25,219 £28,918
Return on Investment %   (3.56%) 5.40% 14.82% 24.73% 35.13% 46.08% 57.58% 69.67% 82.38% 95.73% 109.78%
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   (£938) £1,395 £3,750 £6,130 £8,537 £10,972 £13,436 £15,932 £18,462 £21,026 £23,628
Real Return on Investment %   (3.56%) 5.29% 14.24% 23.27% 32.41% 41.65% 51.00% 60.48% 70.08% 79.82% 89.70%