NE36 East & West Boldon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £111,391
Input Equity (£27,848)
Total Input Equity (£27,848)
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 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391 £111,391
Finance Amount £83,543 £83,543 £81,048 £78,424 £75,667 £72,768 £69,721 £66,518 £63,151 £59,612 £55,892 £51,982
Monthly Mortgage   (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551) (£551)
Monthly Rental   £474 £474 £474 £474 £474 £474 £474 £474 £474 £474 £474
Yield to Purchase Price %   5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11%
Yield to Property Value %   5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11% 5.11%
Gross Monthly Cashflow   (£77) (£77) (£77) (£77) (£77) (£77) (£77) (£77) (£77) (£77) (£77)
Gross Annual Cashflow   (£928) (£928) (£928) (£928) (£928) (£928) (£928) (£928) (£928) (£928) (£928)
Gross Annual Expenses                        
Annual Management Expenses   (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319)
Gross Annual Cashflow less Expenses   (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213)
Vacancy Expenses                        
Net Annual Cashflow   (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213) (£1,213)
Net Yield %   (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%) (1.09%)
Debt Coverage Ratio (1:x)   0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82 0.82
Personal Equity £27,848 £27,848 £30,343 £32,967 £35,724 £38,623 £41,670 £44,873 £48,240 £51,779 £55,499 £59,409
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   (£1,247) £1,249 £3,872 £6,630 £9,529 £12,576 £15,778 £19,145 £22,684 £26,404 £30,315
Return on Investment %   (4.48%) 4.48% 13.91% 23.81% 34.22% 45.16% 56.66% 68.75% 81.46% 94.82% 108.86%
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   (£1,247) £1,224 £3,719 £6,240 £8,789 £11,367 £13,977 £16,620 £19,299 £22,014 £24,769
Real Return on Investment %   (4.48%) 4.39% 13.35% 22.41% 31.56% 40.82% 50.19% 59.68% 69.30% 79.05% 88.95%