LE18 Wigston cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £189,742
Input Equity (£47,436)
Total Input Equity (£47,436)
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 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742 £189,742
Finance Amount £142,307 £142,307 £138,055 £133,587 £128,889 £123,952 £118,762 £113,306 £107,571 £101,543 £95,206 £88,545
Monthly Mortgage   (£939) (£939) (£939) (£939) (£939) (£939) (£939) (£939) (£939) (£939) (£939)
Monthly Rental   £605 £605 £605 £605 £605 £605 £605 £605 £605 £605 £605
Yield to Purchase Price %   3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83%
Yield to Property Value %   3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83% 3.83%
Gross Monthly Cashflow   (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334)
Gross Annual Cashflow   (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005) (£4,005)
Gross Annual Expenses                        
Annual Management Expenses   (£407) (£407) (£407) (£407) (£407) (£407) (£407) (£407) (£407) (£407) (£407)
Gross Annual Cashflow less Expenses   (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369)
Vacancy Expenses                        
Net Annual Cashflow   (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369) (£4,369)
Net Yield %   (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%) (2.30%)
Debt Coverage Ratio (1:x)   0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61
Personal Equity £47,436 £47,436 £51,687 £56,155 £60,853 £65,790 £70,980 £76,436 £82,171 £88,199 £94,536 £101,197
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,412) (£161) £4,307 £9,005 £13,942 £19,133 £24,588 £30,323 £36,351 £42,688 £49,349
Return on Investment %   (9.30%) (0.34%) 9.08% 18.98% 29.39% 40.33% 51.84% 63.92% 76.63% 89.99% 104.03%
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,412) (£158) £4,137 £8,475 £12,860 £17,294 £21,781 £26,324 £30,926 £35,591 £40,322
Real Return on Investment %   (9.30%) (0.33%) 8.72% 17.87% 27.11% 36.46% 45.92% 55.49% 65.20% 75.03% 85.00%