MK9 Central Milton Keynes, Campbell Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £197,503
Input Equity (£49,376)
Total Input Equity (£49,376)
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 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503 £197,503
Finance Amount £148,127 £148,127 £143,702 £139,051 £134,161 £129,022 £123,619 £117,941 £111,971 £105,696 £99,100 £92,167
Monthly Mortgage   (£978) (£978) (£978) (£978) (£978) (£978) (£978) (£978) (£978) (£978) (£978)
Monthly Rental   £996 £996 £996 £996 £996 £996 £996 £996 £996 £996 £996
Yield to Purchase Price %   6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05%
Yield to Property Value %   6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05%
Gross Monthly Cashflow   £18 £18 £18 £18 £18 £18 £18 £18 £18 £18 £18
Gross Annual Cashflow   £217 £217 £217 £217 £217 £217 £217 £217 £217 £217 £217
Gross Annual Expenses                        
Annual Management Expenses   (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669)
Gross Annual Cashflow less Expenses   (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380)
Vacancy Expenses                        
Net Annual Cashflow   (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380)
Taxable Income   £217 £217 £217 £217 £217 £217 £217 £217 £217 £217 £217
Tax Payable                        
Net Annual Cashflow Less Tax   (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380)
Net Yield %   (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%)
Debt Coverage Ratio (1:x)   0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97
Personal Equity £49,376 £49,376 £53,801 £58,452 £63,342 £68,481 £73,884 £79,563 £85,532 £91,807 £98,403 £105,336
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   (£452) £3,973 £8,624 £13,514 £18,653 £24,056 £29,735 £35,704 £41,979 £48,575 £55,508
Return on Investment %   (0.92%) 8.05% 17.47% 27.37% 37.78% 48.72% 60.22% 72.31% 85.02% 98.38% 112.42%
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   (£452) £3,894 £8,283 £12,719 £17,205 £21,745 £26,340 £30,996 £35,714 £40,499 £45,354
Real Return on Investment %   (0.92%) 7.89% 16.78% 25.76% 34.85% 44.04% 53.35% 62.78% 72.33% 82.02% 91.86%