MK10 Brinklow, Broughton, Kingston, Middleton (Milton Keynes Village), Monkston, Oakgrove cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £209,839
Input Equity (£52,460)
Total Input Equity (£52,460)
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 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839 £209,839
Finance Amount £157,379 £157,379 £152,678 £147,736 £142,541 £137,081 £131,341 £125,307 £118,965 £112,298 £105,290 £97,924
Monthly Mortgage   (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039)
Monthly Rental   £979 £979 £979 £979 £979 £979 £979 £979 £979 £979 £979
Yield to Purchase Price %   5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60%
Yield to Property Value %   5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60% 5.60%
Gross Monthly Cashflow   (£59) (£59) (£59) (£59) (£59) (£59) (£59) (£59) (£59) (£59) (£59)
Gross Annual Cashflow   (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710)
Gross Annual Expenses                        
Annual Management Expenses   (£658) (£658) (£658) (£658) (£658) (£658) (£658) (£658) (£658) (£658) (£658)
Gross Annual Cashflow less Expenses   (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298)
Vacancy Expenses                        
Net Annual Cashflow   (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298) (£1,298)
Net Yield %   (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%) (0.62%)
Debt Coverage Ratio (1:x)   0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90 0.90
Personal Equity £52,460 £52,460 £57,161 £62,103 £67,298 £72,758 £78,498 £84,532 £90,874 £97,541 £104,549 £111,915
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   (£1,368) £3,333 £8,275 £13,470 £18,930 £24,670 £30,704 £37,046 £43,713 £50,721 £58,087
Return on Investment %   (2.61%) 6.35% 15.77% 25.68% 36.09% 47.03% 58.53% 70.62% 83.33% 96.69% 110.73%
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   (£1,368) £3,266 £7,947 £12,678 £17,461 £22,300 £27,199 £32,161 £37,189 £42,288 £47,461
Real Return on Investment %   (2.61%) 6.23% 15.15% 24.17% 33.28% 42.51% 51.85% 61.31% 70.89% 80.61% 90.47%