LN11 Louth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £236,116
Input Equity (£59,029)
Input Equity FX (£59,029)
Total Input Equity (£59,029)
Total Input Equity FX (£59,029)
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 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116 £236,116
Finance Amount £177,087 £177,087 £171,797 £166,236 £160,391 £154,246 £147,788 £140,999 £133,862 £126,360 £118,475 £110,186
Monthly Mortgage   (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169) (£1,169)
Monthly Rental   £531 £531 £531 £531 £531 £531 £531 £531 £531 £531 £531
Yield to Purchase Price %   2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70%
Yield to Property Value %   2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70% 2.70%
Gross Monthly Cashflow   (£638) (£638) (£638) (£638) (£638) (£638) (£638) (£638) (£638) (£638) (£638)
Gross Annual Cashflow   (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651) (£7,651)
Gross Annual Expenses                        
Annual Management Expenses   (£357) (£357) (£357) (£357) (£357) (£357) (£357) (£357) (£357) (£357) (£357)
Gross Annual Cashflow less Expenses   (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969)
Vacancy Expenses                        
Net Annual Cashflow   (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969) (£7,969)
Net Yield %   (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%) (3.38%)
Debt Coverage Ratio (1:x)   0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43 0.43
Personal Equity £59,029 £59,029 £64,319 £69,880 £75,725 £81,870 £88,328 £95,117 £102,254 £109,756 £117,641 £125,930
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   (£8,007) (£2,717) £2,843 £8,689 £14,833 £21,292 £28,081 £35,217 £42,719 £50,604 £58,893
Return on Investment %   (13.57%) (4.60%) 4.82% 14.72% 25.13% 36.07% 47.57% 59.66% 72.37% 85.73% 99.77%
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   (£8,007) (£2,663) £2,731 £8,178 £13,682 £19,246 £24,875 £30,573 £36,344 £42,191 £48,120
Real Return on Investment %   (13.57%) (4.51%) 4.63% 13.85% 23.18% 32.60% 42.14% 51.79% 61.57% 71.48% 81.52%