LA13 Barrow-in-Furness cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £179,725
Input Equity (£44,931)
Total Input Equity (£44,931)
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 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725 £179,725
Finance Amount £134,794 £134,794 £130,767 £126,534 £122,085 £117,408 £112,492 £107,324 £101,892 £96,182 £90,180 £83,871
Monthly Mortgage   (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890)
Monthly Rental   £559 £559 £559 £559 £559 £559 £559 £559 £559 £559 £559
Yield to Purchase Price %   3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73%
Yield to Property Value %   3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73% 3.73%
Gross Monthly Cashflow   (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330) (£330)
Gross Annual Cashflow   (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965) (£3,965)
Gross Annual Expenses                        
Annual Management Expenses   (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376)
Gross Annual Cashflow less Expenses   (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301)
Vacancy Expenses                        
Net Annual Cashflow   (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301) (£4,301)
Net Yield %   (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%) (2.39%)
Debt Coverage Ratio (1:x)   0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60 0.60
Personal Equity £44,931 £44,931 £48,958 £53,191 £57,640 £62,317 £67,233 £72,401 £77,833 £83,543 £89,545 £95,854
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,341) (£314) £3,918 £8,368 £13,045 £17,961 £23,129 £28,561 £34,271 £40,273 £46,582
Return on Investment %   (9.66%) (0.70%) 8.72% 18.62% 29.03% 39.97% 51.48% 63.57% 76.27% 89.63% 103.67%
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,341) (£308) £3,763 £7,876 £12,032 £16,235 £20,488 £24,794 £29,156 £33,577 £38,061
Real Return on Investment %   (9.66%) (0.69%) 8.38% 17.53% 26.78% 36.13% 45.60% 55.18% 64.89% 74.73% 84.71%