LE6 Ratby, Groby, Newtown Linford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £259,360
Input Equity (£64,840)
Input Equity FX (£64,840)
Total Input Equity (£64,840)
Total Input Equity FX (£64,840)
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 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360 £259,360
Finance Amount £194,520 £194,520 £188,709 £182,601 £176,180 £169,431 £162,336 £154,879 £147,040 £138,800 £130,138 £121,033
Monthly Mortgage   (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284) (£1,284)
Monthly Rental   £637 £637 £637 £637 £637 £637 £637 £637 £637 £637 £637
Yield to Purchase Price %   2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95%
Yield to Property Value %   2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95% 2.95%
Gross Monthly Cashflow   (£646) (£646) (£646) (£646) (£646) (£646) (£646) (£646) (£646) (£646) (£646)
Gross Annual Cashflow   (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757) (£7,757)
Gross Annual Expenses                        
Annual Management Expenses   (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428) (£428)
Gross Annual Cashflow less Expenses   (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140)
Vacancy Expenses                        
Net Annual Cashflow   (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140) (£8,140)
Net Yield %   (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%) (3.14%)
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 £64,840 £64,840 £70,651 £76,759 £83,180 £89,929 £97,024 £104,481 £112,320 £120,560 £129,222 £138,327
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,186) (£2,375) £3,734 £10,154 £16,903 £23,998 £31,455 £39,295 £47,535 £56,196 £65,301
Return on Investment %   (12.62%) (3.66%) 5.76% 15.66% 26.07% 37.01% 48.51% 60.60% 73.31% 86.67% 100.71%
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,186) (£2,327) £3,586 £9,557 £15,591 £21,692 £27,865 £34,113 £40,441 £46,854 £53,356
Real Return on Investment %   (12.62%) (3.59%) 5.53% 14.74% 24.05% 33.46% 42.97% 52.61% 62.37% 72.26% 82.29%