LE16 East Langton, Hallaton, Market Harborough, Medbourne, Braybrooke cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £309,568
Input Equity (£77,392)
Total Input Equity (£77,392)
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 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568 £309,568
Finance Amount £232,176 £232,176 £225,240 £217,950 £210,286 £202,230 £193,762 £184,861 £175,504 £165,669 £155,331 £144,463
Monthly Mortgage   (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532) (£1,532)
Monthly Rental   £701 £701 £701 £701 £701 £701 £701 £701 £701 £701 £701
Yield to Purchase Price %   2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72%
Yield to Property Value %   2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72% 2.72%
Gross Monthly Cashflow   (£831) (£831) (£831) (£831) (£831) (£831) (£831) (£831) (£831) (£831) (£831)
Gross Annual Cashflow   (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974) (£9,974)
Gross Annual Expenses                        
Annual Management Expenses   (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471) (£471)
Gross Annual Cashflow less Expenses   (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395)
Vacancy Expenses                        
Net Annual Cashflow   (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395) (£10,395)
Net Yield %   (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%) (3.36%)
Debt Coverage Ratio (1:x)   0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43
Personal Equity £77,392 £77,392 £84,328 £91,618 £99,282 £107,338 £115,806 £124,707 £134,064 £143,899 £154,237 £165,105
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   (£10,445) (£3,509) £3,781 £11,445 £19,501 £27,969 £36,870 £46,226 £56,062 £66,400 £77,268
Return on Investment %   (13.50%) (4.53%) 4.89% 14.79% 25.20% 36.14% 47.64% 59.73% 72.44% 85.80% 99.84%
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   (£10,445) (£3,439) £3,632 £10,772 £17,987 £25,282 £32,661 £40,130 £47,695 £55,361 £63,133
Real Return on Investment %   (13.50%) (4.44%) 4.69% 13.92% 23.24% 32.67% 42.20% 51.85% 61.63% 71.53% 81.58%