ME7 Gillingham cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £220,897
Input Equity (£55,224)
Total Input Equity (£55,224)
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 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897 £220,897
Finance Amount £165,673 £165,673 £160,724 £155,521 £150,053 £144,304 £138,262 £131,910 £125,234 £118,216 £110,839 £103,084
Monthly Mortgage   (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093) (£1,093)
Monthly Rental   £754 £754 £754 £754 £754 £754 £754 £754 £754 £754 £754
Yield to Purchase Price %   4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10%
Yield to Property Value %   4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10% 4.10%
Gross Monthly Cashflow   (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339)
Gross Annual Cashflow   (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074) (£4,074)
Gross Annual Expenses                        
Annual Management Expenses   (£507) (£507) (£507) (£507) (£507) (£507) (£507) (£507) (£507) (£507) (£507)
Gross Annual Cashflow less Expenses   (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526)
Vacancy Expenses                        
Net Annual Cashflow   (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526) (£4,526)
Net Yield %   (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%) (2.05%)
Debt Coverage Ratio (1:x)   0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66
Personal Equity £55,224 £55,224 £60,173 £65,376 £70,844 £76,593 £82,635 £88,987 £95,663 £102,681 £110,058 £117,813
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   (£4,581) £369 £5,571 £11,039 £16,788 £22,830 £29,182 £35,858 £42,876 £50,254 £58,008
Return on Investment %   (8.29%) 0.67% 10.09% 19.99% 30.40% 41.34% 52.84% 64.93% 77.64% 91.00% 105.04%
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   (£4,581) £361 £5,350 £10,390 £15,485 £20,637 £25,850 £31,129 £36,478 £41,899 £47,397
Real Return on Investment %   (8.29%) 0.65% 9.69% 18.81% 28.04% 37.37% 46.81% 56.37% 66.05% 75.87% 85.83%