ME12 Isle of Sheppey cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £179,768
Input Equity (£44,942)
Total Input Equity (£44,942)
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 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768 £179,768
Finance Amount £134,826 £134,826 £130,798 £126,565 £122,114 £117,436 £112,519 £107,350 £101,917 £96,205 £90,202 £83,891
Monthly Mortgage   (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890)
Monthly Rental   £856 £856 £856 £856 £856 £856 £856 £856 £856 £856 £856
Yield to Purchase Price %   5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71%
Yield to Property Value %   5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71% 5.71%
Gross Monthly Cashflow   (£34) (£34) (£34) (£34) (£34) (£34) (£34) (£34) (£34) (£34) (£34)
Gross Annual Cashflow   (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409)
Gross Annual Expenses                        
Annual Management Expenses   (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575)
Gross Annual Cashflow less Expenses   (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923)
Vacancy Expenses                        
Net Annual Cashflow   (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923) (£923)
Net Yield %   (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%) (0.51%)
Debt Coverage Ratio (1:x)   0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91 0.91
Personal Equity £44,942 £44,942 £48,970 £53,203 £57,654 £62,332 £67,249 £72,418 £77,852 £83,563 £89,566 £95,877
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   (£984) £3,043 £7,277 £11,727 £16,405 £21,323 £26,492 £31,925 £37,637 £43,640 £49,951
Return on Investment %   (2.19%) 6.77% 16.19% 26.09% 36.50% 47.45% 58.95% 71.04% 83.74% 97.10% 111.15%
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   (£984) £2,982 £6,989 £11,038 £15,132 £19,274 £23,467 £27,715 £32,020 £36,385 £40,813
Real Return on Investment %   (2.19%) 6.64% 15.55% 24.56% 33.67% 42.89% 52.22% 61.67% 71.25% 80.96% 90.81%