M90 Manchester Airport cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £134,273
Input Equity (£33,568)
Total Input Equity (£33,568)
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 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273 £134,273
Finance Amount £100,705 £100,705 £97,696 £94,534 £91,210 £87,716 £84,043 £80,182 £76,124 £71,858 £67,374 £62,660
Monthly Mortgage   (£665) (£665) (£665) (£665) (£665) (£665) (£665) (£665) (£665) (£665) (£665)
Monthly Rental   £639 £639 £639 £639 £639 £639 £639 £639 £639 £639 £639
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   (£26) (£26) (£26) (£26) (£26) (£26) (£26) (£26) (£26) (£26) (£26)
Gross Annual Cashflow   (£311) (£311) (£311) (£311) (£311) (£311) (£311) (£311) (£311) (£311) (£311)
Gross Annual Expenses                        
Annual Management Expenses   (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429)
Gross Annual Cashflow less Expenses   (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694)
Vacancy Expenses                        
Net Annual Cashflow   (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694) (£694)
Net Yield %   (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%) (0.52%)
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 £33,568 £33,568 £36,577 £39,739 £43,063 £46,557 £50,230 £54,091 £58,149 £62,415 £66,899 £71,613
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   (£740) £2,268 £5,430 £8,754 £12,248 £15,921 £19,782 £23,840 £28,106 £32,591 £37,304
Return on Investment %   (2.21%) 6.76% 16.18% 26.08% 36.49% 47.43% 58.93% 71.02% 83.73% 97.09% 111.13%
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   (£740) £2,223 £5,215 £8,239 £11,298 £14,392 £17,524 £20,697 £23,912 £27,172 £30,480
Real Return on Investment %   (2.21%) 6.62% 15.54% 24.55% 33.66% 42.87% 52.20% 61.66% 71.23% 80.95% 90.80%