LE12 East Leake, West Leake, Sutton Bonington, Mountsorrel, Shepshed, Belton, Quorn, Sileby, Wymeswold cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £276,440
Input Equity (£69,110)
Total Input Equity (£69,110)
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 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440 £276,440
Finance Amount £207,330 £207,330 £201,136 £194,626 £187,782 £180,589 £173,027 £165,078 £156,723 £147,940 £138,708 £129,004
Monthly Mortgage   (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368) (£1,368)
Monthly Rental   £677 £677 £677 £677 £677 £677 £677 £677 £677 £677 £677
Yield to Purchase Price %   2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94%
Yield to Property Value %   2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94% 2.94%
Gross Monthly Cashflow   (£691) (£691) (£691) (£691) (£691) (£691) (£691) (£691) (£691) (£691) (£691)
Gross Annual Cashflow   (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294) (£8,294)
Gross Annual Expenses                        
Annual Management Expenses   (£455) (£455) (£455) (£455) (£455) (£455) (£455) (£455) (£455) (£455) (£455)
Gross Annual Cashflow less Expenses   (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700)
Vacancy Expenses                        
Net Annual Cashflow   (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700) (£8,700)
Net Yield %   (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%) (3.15%)
Debt Coverage Ratio (1:x)   0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47 0.47
Personal Equity £69,110 £69,110 £75,304 £81,814 £88,658 £95,851 £103,413 £111,362 £119,717 £128,500 £137,732 £147,436
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   (£8,749) (£2,556) £3,955 £10,798 £17,992 £25,554 £33,502 £41,858 £50,640 £59,872 £69,577
Return on Investment %   (12.66%) (3.70%) 5.72% 15.62% 26.03% 36.98% 48.48% 60.57% 73.28% 86.63% 100.68%
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   (£8,749) (£2,505) £3,798 £10,163 £16,595 £23,099 £29,678 £36,338 £43,083 £49,919 £56,849
Real Return on Investment %   (12.66%) (3.62%) 5.50% 14.71% 24.01% 33.42% 42.94% 52.58% 62.34% 72.23% 82.26%