NE31 Hebburn cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £106,616
Input Equity (£26,654)
Total Input Equity (£26,654)
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,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616 £106,616
Finance Amount £79,962 £79,962 £77,573 £75,062 £72,423 £69,649 £66,732 £63,667 £60,444 £57,057 £53,496 £49,754
Monthly Mortgage   (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528)
Monthly Rental   £436 £436 £436 £436 £436 £436 £436 £436 £436 £436 £436
Yield to Purchase Price %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Yield to Property Value %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Gross Monthly Cashflow   (£91) (£91) (£91) (£91) (£91) (£91) (£91) (£91) (£91) (£91) (£91)
Gross Annual Cashflow   (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097) (£1,097)
Gross Annual Expenses                        
Annual Management Expenses   (£293) (£293) (£293) (£293) (£293) (£293) (£293) (£293) (£293) (£293) (£293)
Gross Annual Cashflow less Expenses   (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359)
Vacancy Expenses                        
Net Annual Cashflow   (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359) (£1,359)
Net Yield %   (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%) (1.27%)
Debt Coverage Ratio (1:x)   0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79
Personal Equity £26,654 £26,654 £29,043 £31,554 £34,193 £36,967 £39,884 £42,949 £46,172 £49,559 £53,120 £56,862
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,390) £998 £3,509 £6,149 £8,923 £11,840 £14,905 £18,128 £21,515 £25,075 £28,818
Return on Investment %   (5.22%) 3.75% 13.17% 23.07% 33.48% 44.42% 55.92% 68.01% 80.72% 94.08% 108.12%
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,390) £978 £3,370 £5,787 £8,230 £10,702 £13,204 £15,737 £18,304 £20,907 £23,547
Real Return on Investment %   (5.22%) 3.67% 12.64% 21.71% 30.88% 40.15% 49.54% 59.04% 68.67% 78.44% 88.34%