LL37 Llwyngwril cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £242,788
Input Equity (£60,697)
Total Input Equity (£60,697)
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 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788 £242,788
Finance Amount £182,091 £182,091 £176,651 £170,933 £164,923 £158,605 £151,964 £144,983 £137,645 £129,931 £121,823 £113,300
Monthly Mortgage   (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202) (£1,202)
Monthly Rental   £585 £585 £585 £585 £585 £585 £585 £585 £585 £585 £585
Yield to Purchase Price %   2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89%
Yield to Property Value %   2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89% 2.89%
Gross Monthly Cashflow   (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617) (£617)
Gross Annual Cashflow   (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399) (£7,399)
Gross Annual Expenses                        
Annual Management Expenses   (£393) (£393) (£393) (£393) (£393) (£393) (£393) (£393) (£393) (£393) (£393)
Gross Annual Cashflow less Expenses   (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750)
Vacancy Expenses                        
Net Annual Cashflow   (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750) (£7,750)
Net Yield %   (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%) (3.19%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £60,697 £60,697 £66,137 £71,855 £77,865 £84,183 £90,824 £97,805 £105,143 £112,857 £120,965 £129,488
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,792) (£2,353) £3,365 £9,376 £15,694 £22,335 £29,316 £36,654 £44,368 £52,476 £60,999
Return on Investment %   (12.84%) (3.88%) 5.54% 15.45% 25.86% 36.80% 48.30% 60.39% 73.10% 86.46% 100.50%
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,792) (£2,306) £3,232 £8,824 £14,475 £20,189 £25,969 £31,820 £37,746 £43,752 £49,841
Real Return on Investment %   (12.84%) (3.80%) 5.32% 14.54% 23.85% 33.26% 42.79% 52.42% 62.19% 72.08% 82.11%