NG13 Bingham, Whatton, Bottesford, Aslockton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £321,542
Input Equity (£80,386)
Total Input Equity (£80,386)
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 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542 £321,542
Finance Amount £241,157 £241,157 £233,952 £226,380 £218,420 £210,052 £201,257 £192,011 £182,293 £172,077 £161,339 £150,051
Monthly Mortgage   (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592)
Monthly Rental   £764 £764 £764 £764 £764 £764 £764 £764 £764 £764 £764
Yield to Purchase Price %   2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85%
Yield to Property Value %   2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85% 2.85%
Gross Monthly Cashflow   (£828) (£828) (£828) (£828) (£828) (£828) (£828) (£828) (£828) (£828) (£828)
Gross Annual Cashflow   (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934) (£9,934)
Gross Annual Expenses                        
Annual Management Expenses   (£513) (£513) (£513) (£513) (£513) (£513) (£513) (£513) (£513) (£513) (£513)
Gross Annual Cashflow less Expenses   (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392)
Vacancy Expenses                        
Net Annual Cashflow   (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392) (£10,392)
Net Yield %   (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%) (3.23%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £80,386 £80,386 £87,590 £95,162 £103,122 £111,490 £120,285 £129,531 £139,249 £149,465 £160,203 £171,491
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   (£10,447) (£3,243) £4,330 £12,290 £20,657 £29,453 £38,698 £48,417 £58,632 £69,371 £80,658
Return on Investment %   (13.00%) (4.03%) 5.39% 15.29% 25.70% 36.64% 48.14% 60.23% 72.94% 86.30% 100.34%
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   (£10,447) (£3,178) £4,158 £11,567 £19,054 £26,623 £34,280 £42,032 £49,882 £57,838 £65,904
Real Return on Investment %   (13.00%) (3.95%) 5.17% 14.39% 23.70% 33.12% 42.65% 52.29% 62.05% 71.95% 81.98%