NE30 Marden, Tynemouth, Cullercoats cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £146,084
Input Equity (£36,521)
Total Input Equity (£36,521)
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 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084 £146,084
Finance Amount £109,563 £109,563 £106,290 £102,850 £99,233 £95,432 £91,436 £87,235 £82,820 £78,179 £73,300 £68,172
Monthly Mortgage   (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723) (£723)
Monthly Rental   £548 £548 £548 £548 £548 £548 £548 £548 £548 £548 £548
Yield to Purchase Price %   4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50%
Yield to Property Value %   4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50%
Gross Monthly Cashflow   (£175) (£175) (£175) (£175) (£175) (£175) (£175) (£175) (£175) (£175) (£175)
Gross Annual Cashflow   (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104) (£2,104)
Gross Annual Expenses                        
Annual Management Expenses   (£368) (£368) (£368) (£368) (£368) (£368) (£368) (£368) (£368) (£368) (£368)
Gross Annual Cashflow less Expenses   (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432)
Vacancy Expenses                        
Net Annual Cashflow   (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432) (£2,432)
Net Yield %   (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%) (1.67%)
Debt Coverage Ratio (1:x)   0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72
Personal Equity £36,521 £36,521 £39,794 £43,234 £46,851 £50,652 £54,648 £58,849 £63,264 £67,905 £72,784 £77,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   (£2,472) £801 £4,242 £7,858 £11,660 £15,656 £19,856 £24,271 £28,913 £33,791 £38,919
Return on Investment %   (6.77%) 2.19% 11.61% 21.52% 31.93% 42.87% 54.37% 66.46% 79.17% 92.53% 106.57%
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,472) £785 £4,074 £7,396 £10,754 £14,151 £17,589 £21,071 £24,598 £28,173 £31,800
Real Return on Investment %   (6.77%) 2.15% 11.15% 20.25% 29.45% 38.75% 48.16% 57.69% 67.35% 77.14% 87.07%