MK7 Caldecotte, Kents Hill, Tilbrook, Walton, Walton Hall, Wavendon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £290,164
Input Equity (£72,541)
Total Input Equity (£72,541)
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 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164 £290,164
Finance Amount £217,623 £217,623 £211,122 £204,288 £197,105 £189,554 £181,617 £173,274 £164,504 £155,285 £145,595 £135,408
Monthly Mortgage   (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436) (£1,436)
Monthly Rental   £1,011 £1,011 £1,011 £1,011 £1,011 £1,011 £1,011 £1,011 £1,011 £1,011 £1,011
Yield to Purchase Price %   4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18%
Yield to Property Value %   4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18% 4.18%
Gross Monthly Cashflow   (£426) (£426) (£426) (£426) (£426) (£426) (£426) (£426) (£426) (£426) (£426)
Gross Annual Cashflow   (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109) (£5,109)
Gross Annual Expenses                        
Annual Management Expenses   (£679) (£679) (£679) (£679) (£679) (£679) (£679) (£679) (£679) (£679) (£679)
Gross Annual Cashflow less Expenses   (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715)
Vacancy Expenses                        
Net Annual Cashflow   (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715) (£5,715)
Net Yield %   (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%) (1.97%)
Debt Coverage Ratio (1:x)   0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
Personal Equity £72,541 £72,541 £79,042 £85,876 £93,059 £100,610 £108,547 £116,890 £125,660 £134,879 £144,569 £154,756
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,788) £713 £7,547 £14,730 £22,281 £30,218 £38,562 £47,332 £56,550 £66,241 £76,427
Return on Investment %   (7.98%) 0.98% 10.40% 20.31% 30.72% 41.66% 53.16% 65.25% 77.96% 91.32% 105.36%
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,788) £699 £7,248 £13,864 £20,552 £27,315 £34,159 £41,090 £48,111 £55,228 £62,446
Real Return on Investment %   (7.98%) 0.96% 9.99% 19.11% 28.33% 37.65% 47.09% 56.64% 66.32% 76.13% 86.08%