N21 Winchmore Hill, Bush Hill, Grange Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £528,541
Input Equity (£132,135)
Total Input Equity (£132,135)
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,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541 £528,541
Finance Amount £396,406 £396,406 £384,564 £372,116 £359,032 £345,278 £330,820 £315,623 £299,648 £282,855 £265,204 £246,650
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,267 £1,267 £1,267 £1,267 £1,267 £1,267 £1,267 £1,267 £1,267 £1,267 £1,267
Yield to Purchase Price %   2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88%
Yield to Property Value %   2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88% 2.88%
Gross Monthly Cashflow   (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350) (£1,350)
Gross Annual Cashflow   (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194) (£16,194)
Gross Annual Expenses                        
Annual Management Expenses   (£851) (£851) (£851) (£851) (£851) (£851) (£851) (£851) (£851) (£851) (£851)
Gross Annual Cashflow less Expenses   (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954)
Vacancy Expenses                        
Net Annual Cashflow   (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954) (£16,954)
Net Yield %   (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £132,135 £132,135 £143,977 £156,425 £169,509 £183,263 £197,721 £212,919 £228,893 £245,686 £263,337 £281,891
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   (£17,045) (£5,204) £7,244 £20,329 £34,083 £48,540 £63,738 £79,713 £96,505 £114,156 £132,711
Return on Investment %   (12.90%) (3.94%) 5.48% 15.38% 25.79% 36.74% 48.24% 60.33% 73.03% 86.39% 100.44%
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   (£17,045) (£5,099) £6,957 £19,133 £31,437 £43,877 £56,462 £69,201 £82,103 £95,178 £108,434
Real Return on Investment %   (12.90%) (3.86%) 5.27% 14.48% 23.79% 33.21% 42.73% 52.37% 62.14% 72.03% 82.06%