M33 Sale, Brooklands cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £210,648
Input Equity (£52,662)
Total Input Equity (£52,662)
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 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648 £210,648
Finance Amount £157,986 £157,986 £153,266 £148,305 £143,091 £137,609 £131,847 £125,790 £119,423 £112,731 £105,696 £98,301
Monthly Mortgage   (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043) (£1,043)
Monthly Rental   £766 £766 £766 £766 £766 £766 £766 £766 £766 £766 £766
Yield to Purchase Price %   4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36%
Yield to Property Value %   4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36% 4.36%
Gross Monthly Cashflow   (£277) (£277) (£277) (£277) (£277) (£277) (£277) (£277) (£277) (£277) (£277)
Gross Annual Cashflow   (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322) (£3,322)
Gross Annual Expenses                        
Annual Management Expenses   (£515) (£515) (£515) (£515) (£515) (£515) (£515) (£515) (£515) (£515) (£515)
Gross Annual Cashflow less Expenses   (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781)
Vacancy Expenses                        
Net Annual Cashflow   (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781) (£3,781)
Net Yield %   (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%) (1.79%)
Debt Coverage Ratio (1:x)   0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70
Personal Equity £52,662 £52,662 £57,382 £62,343 £67,557 £73,039 £78,801 £84,858 £91,225 £97,917 £104,952 £112,347
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,836) £883 £5,844 £11,059 £16,541 £22,303 £28,360 £34,726 £41,419 £48,454 £55,848
Return on Investment %   (7.28%) 1.68% 11.10% 21.00% 31.41% 42.35% 53.85% 65.94% 78.65% 92.01% 106.05%
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,836) £866 £5,613 £10,409 £15,257 £20,160 £25,122 £30,147 £35,238 £40,398 £45,632
Real Return on Investment %   (7.28%) 1.64% 10.66% 19.77% 28.97% 38.28% 47.70% 57.25% 66.91% 76.71% 86.65%