NE13 Airport, Wideopen, Dinnington cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £230,035
Input Equity (£57,509)
Total Input Equity (£57,509)
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 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035 £230,035
Finance Amount £172,526 £172,526 £167,372 £161,955 £156,260 £150,274 £143,982 £137,367 £130,415 £123,106 £115,424 £107,348
Monthly Mortgage   (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139)
Monthly Rental   £630 £630 £630 £630 £630 £630 £630 £630 £630 £630 £630
Yield to Purchase Price %   3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29%
Yield to Property Value %   3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29% 3.29%
Gross Monthly Cashflow   (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508) (£508)
Gross Annual Cashflow   (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100) (£6,100)
Gross Annual Expenses                        
Annual Management Expenses   (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424)
Gross Annual Cashflow less Expenses   (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478)
Vacancy Expenses                        
Net Annual Cashflow   (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478) (£6,478)
Net Yield %   (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%) (2.82%)
Debt Coverage Ratio (1:x)   0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
Personal Equity £57,509 £57,509 £62,663 £68,080 £73,775 £79,761 £86,053 £92,668 £99,620 £106,929 £114,611 £122,687
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   (£6,523) (£1,370) £4,048 £9,743 £15,729 £22,021 £28,636 £35,588 £42,897 £50,579 £58,654
Return on Investment %   (11.34%) (2.38%) 7.04% 16.94% 27.35% 38.29% 49.79% 61.88% 74.59% 87.95% 101.99%
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   (£6,523) (£1,342) £3,888 £9,170 £14,508 £19,905 £25,367 £30,895 £36,495 £42,170 £47,925
Real Return on Investment %   (11.34%) (2.33%) 6.76% 15.95% 25.23% 34.61% 44.11% 53.72% 63.46% 73.33% 83.33%