LA14 Barrow-in-Furness, Walney Island cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £114,133
Input Equity (£28,533)
Input Equity FX (£28,533)
Total Input Equity (£28,533)
Total Input Equity FX (£28,533)
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 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133 £114,133
Finance Amount £85,600 £85,600 £83,043 £80,355 £77,529 £74,559 £71,437 £68,155 £64,706 £61,080 £57,268 £53,261
Monthly Mortgage   (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565) (£565)
Monthly Rental   £565 £565 £565 £565 £565 £565 £565 £565 £565 £565 £565
Yield to Purchase Price %   5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94%
Yield to Property Value %   5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94% 5.94%
Gross Monthly Cashflow   £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Gross Annual Cashflow   £6 £6 £6 £6 £6 £6 £6 £6 £6 £6 £6
Gross Annual Expenses                        
Annual Management Expenses   (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380)
Gross Annual Cashflow less Expenses   (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333)
Vacancy Expenses                        
Net Annual Cashflow   (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333)
Taxable Income   £6 £6 £6 £6 £6 £6 £6 £6 £6 £6 £6
Tax Payable                        
Net Annual Cashflow Less Tax   (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333) (£333)
Net Yield %   (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%) (0.29%)
Debt Coverage Ratio (1:x)   0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95 0.95
Personal Equity £28,533 £28,533 £31,090 £33,778 £36,604 £39,574 £42,696 £45,978 £49,427 £53,053 £56,865 £60,872
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   (£374) £2,183 £4,871 £7,696 £10,666 £13,788 £17,070 £20,520 £24,146 £27,957 £31,964
Return on Investment %   (1.31%) 7.65% 17.07% 26.97% 37.38% 48.32% 59.83% 71.92% 84.62% 97.98% 112.02%
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   (£374) £2,139 £4,678 £7,244 £9,838 £12,464 £15,121 £17,814 £20,542 £23,309 £26,117
Real Return on Investment %   (1.31%) 7.50% 16.39% 25.39% 34.48% 43.68% 53.00% 62.43% 71.99% 81.69% 91.53%