LE10 Hinckley cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £287,821
Input Equity (£71,955)
Total Input Equity (£71,955)
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 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821 £287,821
Finance Amount £215,866 £215,866 £209,417 £202,639 £195,513 £188,024 £180,150 £171,875 £163,175 £154,031 £144,419 £134,315
Monthly Mortgage   (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425) (£1,425)
Monthly Rental   £661 £661 £661 £661 £661 £661 £661 £661 £661 £661 £661
Yield to Purchase Price %   2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76%
Yield to Property Value %   2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76% 2.76%
Gross Monthly Cashflow   (£763) (£763) (£763) (£763) (£763) (£763) (£763) (£763) (£763) (£763) (£763)
Gross Annual Cashflow   (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162) (£9,162)
Gross Annual Expenses                        
Annual Management Expenses   (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444)
Gross Annual Cashflow less Expenses   (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558)
Vacancy Expenses                        
Net Annual Cashflow   (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558) (£9,558)
Net Yield %   (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%) (3.32%)
Debt Coverage Ratio (1:x)   0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44
Personal Equity £71,955 £71,955 £78,404 £85,182 £92,308 £99,797 £107,671 £115,946 £124,646 £133,790 £143,402 £153,506
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   (£9,606) (£3,157) £3,621 £10,746 £18,236 £26,109 £34,385 £43,084 £52,229 £61,841 £71,945
Return on Investment %   (13.35%) (4.39%) 5.03% 14.93% 25.34% 36.29% 47.79% 59.88% 72.58% 85.94% 99.99%
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   (£9,606) (£3,094) £3,478 £10,114 £16,821 £23,601 £30,460 £37,403 £44,434 £51,560 £58,784
Real Return on Investment %   (13.35%) (4.30%) 4.83% 14.06% 23.38% 32.80% 42.33% 51.98% 61.75% 71.66% 81.70%