L40 Burscough, Scarisbrick cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £268,615
Input Equity (£67,154)
Total Input Equity (£67,154)
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 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615 £268,615
Finance Amount £201,461 £201,461 £195,443 £189,117 £182,467 £175,477 £168,129 £160,406 £152,287 £143,753 £134,782 £125,352
Monthly Mortgage   (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330) (£1,330)
Monthly Rental   £778 £778 £778 £778 £778 £778 £778 £778 £778 £778 £778
Yield to Purchase Price %   3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47%
Yield to Property Value %   3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47% 3.47%
Gross Monthly Cashflow   (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552)
Gross Annual Cashflow   (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621) (£6,621)
Gross Annual Expenses                        
Annual Management Expenses   (£523) (£523) (£523) (£523) (£523) (£523) (£523) (£523) (£523) (£523) (£523)
Gross Annual Cashflow less Expenses   (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087)
Vacancy Expenses                        
Net Annual Cashflow   (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087)
Net Yield %   (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%) (2.64%)
Debt Coverage Ratio (1:x)   0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56
Personal Equity £67,154 £67,154 £73,172 £79,498 £86,148 £93,138 £100,486 £108,209 £116,328 £124,862 £133,833 £143,263
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   (£7,143) (£1,125) £5,201 £11,851 £18,841 £26,189 £33,912 £42,031 £50,565 £59,536 £68,966
Return on Investment %   (10.64%) (1.68%) 7.75% 17.65% 28.06% 39.00% 50.50% 62.59% 75.30% 88.66% 102.70%
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   (£7,143) (£1,103) £4,995 £11,154 £17,378 £23,673 £30,041 £36,488 £43,019 £49,638 £56,350
Real Return on Investment %   (10.64%) (1.64%) 7.44% 16.61% 25.88% 35.25% 44.73% 54.34% 64.06% 73.92% 83.91%