LN4 Branston, Canwick, Coningsby, Dunston, Heighington, Nocton, Washingborough, Timberland, Martin cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £202,173
Input Equity (£50,543)
Total Input Equity (£50,543)
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 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173 £202,173
Finance Amount £151,630 £151,630 £147,100 £142,339 £137,334 £132,073 £126,542 £120,729 £114,619 £108,195 £101,444 £94,346
Monthly Mortgage   (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001) (£1,001)
Monthly Rental   £579 £579 £579 £579 £579 £579 £579 £579 £579 £579 £579
Yield to Purchase Price %   3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44%
Yield to Property Value %   3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44%
Gross Monthly Cashflow   (£422) (£422) (£422) (£422) (£422) (£422) (£422) (£422) (£422) (£422) (£422)
Gross Annual Cashflow   (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063) (£5,063)
Gross Annual Expenses                        
Annual Management Expenses   (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389) (£389)
Gross Annual Cashflow less Expenses   (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410)
Vacancy Expenses                        
Net Annual Cashflow   (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410) (£5,410)
Net Yield %   (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%) (2.68%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £50,543 £50,543 £55,073 £59,834 £64,839 £70,100 £75,631 £81,444 £87,554 £93,978 £100,729 £107,827
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   (£5,452) (£922) £3,839 £8,844 £14,105 £19,635 £25,449 £31,559 £37,982 £44,734 £51,831
Return on Investment %   (10.79%) (1.82%) 7.60% 17.50% 27.91% 38.85% 50.35% 62.44% 75.15% 88.51% 102.55%
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   (£5,452) (£904) £3,687 £8,324 £13,010 £17,749 £22,543 £27,397 £32,314 £37,297 £42,350
Real Return on Investment %   (10.79%) (1.79%) 7.29% 16.47% 25.74% 35.12% 44.60% 54.21% 63.93% 73.79% 83.79%