MK3 Church Green, Far Bletchley, Old Bletchley, West Bletchley cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £234,360
Input Equity (£58,590)
Input Equity FX (£58,590)
Total Input Equity (£58,590)
Total Input Equity FX (£58,590)
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 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360 £234,360
Finance Amount £175,770 £175,770 £170,519 £165,000 £159,198 £153,099 £146,689 £139,950 £132,867 £125,421 £117,594 £109,367
Monthly Mortgage   (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160) (£1,160)
Monthly Rental   £916 £916 £916 £916 £916 £916 £916 £916 £916 £916 £916
Yield to Purchase Price %   4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69%
Yield to Property Value %   4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69% 4.69%
Gross Monthly Cashflow   (£244) (£244) (£244) (£244) (£244) (£244) (£244) (£244) (£244) (£244) (£244)
Gross Annual Cashflow   (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925) (£2,925)
Gross Annual Expenses                        
Annual Management Expenses   (£616) (£616) (£616) (£616) (£616) (£616) (£616) (£616) (£616) (£616) (£616)
Gross Annual Cashflow less Expenses   (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475)
Vacancy Expenses                        
Net Annual Cashflow   (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475) (£3,475)
Net Yield %   (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%) (1.48%)
Debt Coverage Ratio (1:x)   0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75
Personal Equity £58,590 £58,590 £63,841 £69,360 £75,162 £81,261 £87,671 £94,410 £101,493 £108,939 £116,766 £124,993
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   (£3,541) £1,710 £7,229 £13,031 £19,130 £25,541 £32,279 £39,363 £46,809 £54,635 £62,862
Return on Investment %   (6.04%) 2.92% 12.34% 22.24% 32.65% 43.59% 55.09% 67.18% 79.89% 93.25% 107.29%
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   (£3,541) £1,676 £6,943 £12,265 £17,645 £23,087 £28,594 £34,172 £39,823 £45,552 £51,363
Real Return on Investment %   (6.04%) 2.86% 11.85% 20.93% 30.12% 39.40% 48.80% 58.32% 67.97% 77.75% 87.67%