LS3 Woodhouse cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £101,712
Input Equity (£25,428)
Total Input Equity (£25,428)
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 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712 £101,712
Finance Amount £76,284 £76,284 £74,005 £71,610 £69,092 £66,445 £63,663 £60,738 £57,664 £54,432 £51,036 £47,465
Monthly Mortgage   (£503) (£503) (£503) (£503) (£503) (£503) (£503) (£503) (£503) (£503) (£503)
Monthly Rental   £734 £734 £734 £734 £734 £734 £734 £734 £734 £734 £734
Yield to Purchase Price %   8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66%
Yield to Property Value %   8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66% 8.66%
Gross Monthly Cashflow   £231 £231 £231 £231 £231 £231 £231 £231 £231 £231 £231
Gross Annual Cashflow   £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769
Gross Annual Expenses                        
Annual Management Expenses   (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493) (£493)
Gross Annual Cashflow less Expenses   £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329
Vacancy Expenses                        
Net Annual Cashflow   £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329
Taxable Income   £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769 £2,769
Tax Payable                        
Net Annual Cashflow Less Tax   £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329 £2,329
Net Yield %   2.29% 2.29% 2.29% 2.29% 2.29% 2.29% 2.29% 2.29% 2.29% 2.29% 2.29%
Debt Coverage Ratio (1:x)   1.39 1.39 1.39 1.39 1.39 1.39 1.39 1.39 1.39 1.39 1.39
Personal Equity £25,428 £25,428 £27,707 £30,102 £32,620 £35,267 £38,049 £40,974 £44,048 £47,280 £50,676 £54,247
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   £2,276 £4,555 £6,950 £9,468 £12,115 £14,897 £17,822 £20,896 £24,127 £27,524 £31,095
Return on Investment %   8.95% 17.91% 27.33% 37.23% 47.64% 58.59% 70.09% 82.18% 94.88% 108.24% 122.29%
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   £2,276 £4,463 £6,675 £8,911 £11,174 £13,466 £15,787 £18,140 £20,527 £22,948 £25,407
Real Return on Investment %   8.95% 17.55% 26.25% 35.04% 43.94% 52.96% 62.09% 71.34% 80.72% 90.25% 99.92%