MK42 Cauldwell, Elstow, Harrowden, Kempston, Kingsbrook, Shortstown, Wixams cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £239,325
Input Equity (£59,831)
Total Input Equity (£59,831)
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 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325 £239,325
Finance Amount £179,494 £179,494 £174,132 £168,495 £162,571 £156,343 £149,796 £142,915 £135,681 £128,078 £120,085 £111,684
Monthly Mortgage   (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185) (£1,185)
Monthly Rental   £798 £798 £798 £798 £798 £798 £798 £798 £798 £798 £798
Yield to Purchase Price %   4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Yield to Property Value %   4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00%
Gross Monthly Cashflow   (£387) (£387) (£387) (£387) (£387) (£387) (£387) (£387) (£387) (£387) (£387)
Gross Annual Cashflow   (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639) (£4,639)
Gross Annual Expenses                        
Annual Management Expenses   (£536) (£536) (£536) (£536) (£536) (£536) (£536) (£536) (£536) (£536) (£536)
Gross Annual Cashflow less Expenses   (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118)
Vacancy Expenses                        
Net Annual Cashflow   (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118) (£5,118)
Net Yield %   (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%) (2.14%)
Debt Coverage Ratio (1:x)   0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64
Personal Equity £59,831 £59,831 £65,193 £70,830 £76,754 £82,982 £89,529 £96,410 £103,644 £111,247 £119,240 £127,641
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,175) £187 £5,823 £11,748 £17,976 £24,522 £31,404 £38,637 £46,241 £54,233 £62,635
Return on Investment %   (8.65%) 0.31% 9.73% 19.63% 30.04% 40.99% 52.49% 64.58% 77.29% 90.64% 104.69%
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,175) £183 £5,592 £11,057 £16,580 £22,166 £27,819 £33,542 £39,340 £45,217 £51,177
Real Return on Investment %   (8.65%) 0.31% 9.35% 18.48% 27.71% 37.05% 46.50% 56.06% 65.75% 75.57% 85.54%