LA15 Dalton-in-Furness cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £170,667
Input Equity (£42,667)
Total Input Equity (£42,667)
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 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667 £170,667
Finance Amount £128,000 £128,000 £124,176 £120,157 £115,932 £111,491 £106,822 £101,915 £96,757 £91,335 £85,635 £79,644
Monthly Mortgage   (£845) (£845) (£845) (£845) (£845) (£845) (£845) (£845) (£845) (£845) (£845)
Monthly Rental   £563 £563 £563 £563 £563 £563 £563 £563 £563 £563 £563
Yield to Purchase Price %   3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96%
Yield to Property Value %   3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96%
Gross Monthly Cashflow   (£282) (£282) (£282) (£282) (£282) (£282) (£282) (£282) (£282) (£282) (£282)
Gross Annual Cashflow   (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379) (£3,379)
Gross Annual Expenses                        
Annual Management Expenses   (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378)
Gross Annual Cashflow less Expenses   (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717)
Vacancy Expenses                        
Net Annual Cashflow   (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717) (£3,717)
Net Yield %   (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%)
Debt Coverage Ratio (1:x)   0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63
Personal Equity £42,667 £42,667 £46,491 £50,510 £54,735 £59,176 £63,845 £68,752 £73,910 £79,332 £85,032 £91,023
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   (£3,757) £66 £4,086 £8,311 £12,752 £17,420 £22,328 £27,486 £32,908 £38,608 £44,599
Return on Investment %   (8.81%) 0.16% 9.58% 19.48% 29.89% 40.83% 52.33% 64.42% 77.13% 90.49% 104.53%
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   (£3,757) £65 £3,924 £7,822 £11,762 £15,747 £19,779 £23,861 £27,997 £32,189 £36,441
Real Return on Investment %   (8.81%) 0.15% 9.20% 18.33% 27.57% 36.91% 46.36% 55.92% 65.62% 75.44% 85.41%