LD7 Knighton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £283,975
Input Equity (£70,994)
Total Input Equity (£70,994)
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 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975 £283,975
Finance Amount £212,981 £212,981 £206,619 £199,931 £192,901 £185,511 £177,743 £169,578 £160,995 £151,973 £142,489 £132,520
Monthly Mortgage   (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406) (£1,406)
Monthly Rental   £736 £736 £736 £736 £736 £736 £736 £736 £736 £736 £736
Yield to Purchase Price %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Yield to Property Value %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Gross Monthly Cashflow   (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669) (£669)
Gross Annual Cashflow   (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031) (£8,031)
Gross Annual Expenses                        
Annual Management Expenses   (£495) (£495) (£495) (£495) (£495) (£495) (£495) (£495) (£495) (£495) (£495)
Gross Annual Cashflow less Expenses   (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473)
Vacancy Expenses                        
Net Annual Cashflow   (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473) (£8,473)
Net Yield %   (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £70,994 £70,994 £77,356 £84,044 £91,074 £98,464 £106,232 £114,397 £122,980 £132,002 £141,486 £151,455
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,526) (£2,164) £4,524 £11,554 £18,944 £26,712 £34,877 £43,460 £52,482 £61,966 £71,935
Return on Investment %   (12.01%) (3.05%) 6.37% 16.28% 26.68% 37.63% 49.13% 61.22% 73.93% 87.28% 101.33%
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,526) (£2,120) £4,345 £10,875 £17,473 £24,145 £30,896 £37,729 £44,650 £51,664 £58,776
Real Return on Investment %   (12.01%) (2.99%) 6.12% 15.32% 24.61% 34.01% 43.52% 53.14% 62.89% 72.77% 82.79%