LU7 Leighton Buzzard, Bragenham, Briggington, Burcott, Cheddington, Chelmscote, Clipstone, Crafton, Cublington, Eggington, Great Billington, Grove, Heath and Reach, Hockliffe, Horton, Hollingdon, Ivinghoe, Ivinghoe Aston, Ledburn, Leedon, Little Billington, M cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £462,947
Input Equity (£115,737)
Total Input Equity (£115,737)
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 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947 £462,947
Finance Amount £347,210 £347,210 £336,838 £325,935 £314,474 £302,427 £289,764 £276,453 £262,460 £247,752 £232,291 £216,039
Monthly Mortgage   (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291) (£2,291)
Monthly Rental   £1,118 £1,118 £1,118 £1,118 £1,118 £1,118 £1,118 £1,118 £1,118 £1,118 £1,118
Yield to Purchase Price %   2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90%
Yield to Property Value %   2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90% 2.90%
Gross Monthly Cashflow   (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173) (£1,173)
Gross Annual Cashflow   (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077) (£14,077)
Gross Annual Expenses                        
Annual Management Expenses   (£752) (£752) (£752) (£752) (£752) (£752) (£752) (£752) (£752) (£752) (£752)
Gross Annual Cashflow less Expenses   (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748)
Vacancy Expenses                        
Net Annual Cashflow   (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748) (£14,748)
Net Yield %   (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £115,737 £115,737 £126,109 £137,012 £148,473 £160,520 £173,183 £186,494 £200,487 £215,195 £230,656 £246,908
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   (£14,828) (£4,456) £6,447 £17,908 £29,955 £42,618 £55,930 £69,922 £84,630 £100,091 £116,343
Return on Investment %   (12.81%) (3.85%) 5.57% 15.47% 25.88% 36.82% 48.32% 60.41% 73.12% 86.48% 100.52%
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   (£14,828) (£4,367) £6,192 £16,855 £27,629 £38,524 £49,545 £60,701 £72,000 £83,451 £95,060
Real Return on Investment %   (12.81%) (3.77%) 5.35% 14.56% 23.87% 33.29% 42.81% 52.45% 62.21% 72.10% 82.14%