LN10 Woodhall Spa cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £228,969
Input Equity (£57,242)
Total Input Equity (£57,242)
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 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969 £228,969
Finance Amount £171,727 £171,727 £166,597 £161,204 £155,536 £149,578 £143,314 £136,731 £129,810 £122,536 £114,889 £106,851
Monthly Mortgage   (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133) (£1,133)
Monthly Rental   £653 £653 £653 £653 £653 £653 £653 £653 £653 £653 £653
Yield to Purchase Price %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Yield to Property Value %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Gross Monthly Cashflow   (£481) (£481) (£481) (£481) (£481) (£481) (£481) (£481) (£481) (£481) (£481)
Gross Annual Cashflow   (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769) (£5,769)
Gross Annual Expenses                        
Annual Management Expenses   (£439) (£439) (£439) (£439) (£439) (£439) (£439) (£439) (£439) (£439) (£439)
Gross Annual Cashflow less Expenses   (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161)
Vacancy Expenses                        
Net Annual Cashflow   (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161) (£6,161)
Net Yield %   (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £57,242 £57,242 £62,372 £67,765 £73,433 £79,391 £85,655 £92,238 £99,159 £106,433 £114,080 £122,118
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   (£6,208) (£1,078) £4,315 £9,983 £15,941 £22,205 £28,788 £35,709 £42,983 £50,630 £58,668
Return on Investment %   (10.84%) (1.88%) 7.54% 17.44% 27.85% 38.79% 50.29% 62.38% 75.09% 88.45% 102.49%
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   (£6,208) (£1,056) £4,144 £9,396 £14,704 £20,071 £25,502 £31,000 £36,569 £42,213 £47,936
Real Return on Investment %   (10.84%) (1.85%) 7.24% 16.41% 25.69% 35.06% 44.55% 54.16% 63.88% 73.74% 83.74%