LE8 Great Glen, Fleckney, Kibworth, Peatling Magna, Countesthorpe cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £246,445
Input Equity (£61,611)
Total Input Equity (£61,611)
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 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445 £246,445
Finance Amount £184,834 £184,834 £179,312 £173,508 £167,407 £160,994 £154,253 £147,167 £139,718 £131,888 £123,658 £115,006
Monthly Mortgage   (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220) (£1,220)
Monthly Rental   £720 £720 £720 £720 £720 £720 £720 £720 £720 £720 £720
Yield to Purchase Price %   3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51%
Yield to Property Value %   3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51%
Gross Monthly Cashflow   (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500)
Gross Annual Cashflow   (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999) (£5,999)
Gross Annual Expenses                        
Annual Management Expenses   (£484) (£484) (£484) (£484) (£484) (£484) (£484) (£484) (£484) (£484) (£484)
Gross Annual Cashflow less Expenses   (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431)
Vacancy Expenses                        
Net Annual Cashflow   (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431) (£6,431)
Net Yield %   (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%) (2.61%)
Debt Coverage Ratio (1:x)   0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56
Personal Equity £61,611 £61,611 £67,133 £72,937 £79,038 £85,451 £92,192 £99,278 £106,727 £114,557 £122,787 £131,439
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   (£6,483) (£961) £4,843 £10,944 £17,357 £24,098 £31,184 £38,633 £46,463 £54,693 £63,345
Return on Investment %   (10.52%) (1.56%) 7.86% 17.76% 28.17% 39.11% 50.61% 62.70% 75.41% 88.77% 102.81%
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   (£6,483) (£942) £4,651 £10,300 £16,009 £21,783 £27,624 £33,538 £39,529 £45,600 £51,757
Real Return on Investment %   (10.52%) (1.53%) 7.55% 16.72% 25.98% 35.36% 44.84% 54.44% 64.16% 74.01% 84.01%