MK2 Brickfields, Central Bletchley, Fenny Stratford, Water Eaton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £200,391
Input Equity (£50,098)
Total Input Equity (£50,098)
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 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391 £200,391
Finance Amount £150,293 £150,293 £145,804 £141,084 £136,123 £130,909 £125,427 £119,665 £113,608 £107,242 £100,549 £93,515
Monthly Mortgage   (£992) (£992) (£992) (£992) (£992) (£992) (£992) (£992) (£992) (£992) (£992)
Monthly Rental   £899 £899 £899 £899 £899 £899 £899 £899 £899 £899 £899
Yield to Purchase Price %   5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38%
Yield to Property Value %   5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38% 5.38%
Gross Monthly Cashflow   (£93) (£93) (£93) (£93) (£93) (£93) (£93) (£93) (£93) (£93) (£93)
Gross Annual Cashflow   (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114) (£1,114)
Gross Annual Expenses                        
Annual Management Expenses   (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604)
Gross Annual Cashflow less Expenses   (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653)
Vacancy Expenses                        
Net Annual Cashflow   (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653) (£1,653)
Net Yield %   (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%) (0.83%)
Debt Coverage Ratio (1:x)   0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86
Personal Equity £50,098 £50,098 £54,587 £59,307 £64,268 £69,482 £74,964 £80,726 £86,783 £93,149 £99,842 £106,876
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,718) £2,772 £7,491 £12,452 £17,667 £23,148 £28,910 £34,967 £41,333 £48,026 £55,061
Return on Investment %   (3.43%) 5.53% 14.95% 24.86% 35.26% 46.21% 57.71% 69.80% 82.51% 95.86% 109.91%
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,718) £2,716 £7,195 £11,720 £16,295 £20,924 £25,610 £30,356 £35,165 £40,041 £44,988
Real Return on Investment %   (3.43%) 5.42% 14.36% 23.39% 32.53% 41.77% 51.12% 60.59% 70.19% 79.93% 89.80%