NE32 Jarrow, Fellgate, South Tyne Tunnel cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £106,022
Input Equity (£26,506)
Total Input Equity (£26,506)
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 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022 £106,022
Finance Amount £79,517 £79,517 £77,141 £74,644 £72,019 £69,261 £66,360 £63,312 £60,107 £56,739 £53,198 £49,476
Monthly Mortgage   (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525)
Monthly Rental   £446 £446 £446 £446 £446 £446 £446 £446 £446 £446 £446
Yield to Purchase Price %   5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05%
Yield to Property Value %   5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05%
Gross Monthly Cashflow   (£79) (£79) (£79) (£79) (£79) (£79) (£79) (£79) (£79) (£79) (£79)
Gross Annual Cashflow   (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942) (£942)
Gross Annual Expenses                        
Annual Management Expenses   (£300) (£300) (£300) (£300) (£300) (£300) (£300) (£300) (£300) (£300) (£300)
Gross Annual Cashflow less Expenses   (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210)
Vacancy Expenses                        
Net Annual Cashflow   (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210) (£1,210)
Net Yield %   (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%)
Debt Coverage Ratio (1:x)   0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81
Personal Equity £26,506 £26,506 £28,881 £31,378 £34,003 £36,761 £39,662 £42,710 £45,915 £49,283 £52,824 £56,546
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,242) £1,133 £3,630 £6,255 £9,014 £11,914 £14,962 £18,167 £21,535 £25,076 £28,798
Return on Investment %   (4.69%) 4.28% 13.70% 23.60% 34.01% 44.95% 56.45% 68.54% 81.25% 94.61% 108.65%
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,242) £1,111 £3,486 £5,887 £8,314 £10,769 £13,254 £15,771 £18,321 £20,907 £23,530
Real Return on Investment %   (4.69%) 4.19% 13.15% 22.21% 31.37% 40.63% 50.01% 59.50% 69.12% 78.88% 88.77%