LS18 Horsforth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £245,653
Input Equity (£61,413)
Total Input Equity (£61,413)
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 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653 £245,653
Finance Amount £184,240 £184,240 £178,736 £172,951 £166,869 £160,477 £153,757 £146,694 £139,269 £131,464 £123,260 £114,637
Monthly Mortgage   (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216) (£1,216)
Monthly Rental   £690 £690 £690 £690 £690 £690 £690 £690 £690 £690 £690
Yield to Purchase Price %   3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37%
Yield to Property Value %   3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37% 3.37%
Gross Monthly Cashflow   (£526) (£526) (£526) (£526) (£526) (£526) (£526) (£526) (£526) (£526) (£526)
Gross Annual Cashflow   (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314) (£6,314)
Gross Annual Expenses                        
Annual Management Expenses   (£464) (£464) (£464) (£464) (£464) (£464) (£464) (£464) (£464) (£464) (£464)
Gross Annual Cashflow less Expenses   (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727)
Vacancy Expenses                        
Net Annual Cashflow   (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727) (£6,727)
Net Yield %   (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%) (2.74%)
Debt Coverage Ratio (1:x)   0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54
Personal Equity £61,413 £61,413 £66,917 £72,702 £78,784 £85,176 £91,896 £98,959 £106,384 £114,189 £122,393 £131,016
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,777) (£1,273) £4,512 £10,594 £16,986 £23,706 £30,769 £38,194 £45,998 £54,202 £62,826
Return on Investment %   (11.04%) (2.07%) 7.35% 17.25% 27.66% 38.60% 50.10% 62.19% 74.90% 88.26% 102.30%
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,777) (£1,248) £4,333 £9,971 £15,667 £21,428 £27,256 £33,157 £39,134 £45,191 £51,333
Real Return on Investment %   (11.04%) (2.03%) 7.06% 16.24% 25.51% 34.89% 44.38% 53.99% 63.72% 73.59% 83.59%