LL39 Arthog cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £179,021
Input Equity (£44,755)
Total Input Equity (£44,755)
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 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021 £179,021
Finance Amount £134,266 £134,266 £130,255 £126,039 £121,607 £116,948 £112,051 £106,904 £101,493 £95,805 £89,827 £83,542
Monthly Mortgage   (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886) (£886)
Monthly Rental   £660 £660 £660 £660 £660 £660 £660 £660 £660 £660 £660
Yield to Purchase Price %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Yield to Property Value %   4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43% 4.43%
Gross Monthly Cashflow   (£226) (£226) (£226) (£226) (£226) (£226) (£226) (£226) (£226) (£226) (£226)
Gross Annual Cashflow   (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709) (£2,709)
Gross Annual Expenses                        
Annual Management Expenses   (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444)
Gross Annual Cashflow less Expenses   (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105)
Vacancy Expenses                        
Net Annual Cashflow   (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105) (£3,105)
Net Yield %   (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%) (1.73%)
Debt Coverage Ratio (1:x)   0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71 0.71
Personal Equity £44,755 £44,755 £48,766 £52,982 £57,414 £62,073 £66,970 £72,117 £77,528 £83,216 £89,194 £95,479
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   (£3,153) £858 £5,074 £9,506 £14,164 £19,061 £24,209 £29,620 £35,307 £41,286 £47,571
Return on Investment %   (7.05%) 1.92% 11.34% 21.24% 31.65% 42.59% 54.09% 66.18% 78.89% 92.25% 106.29%
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   (£3,153) £841 £4,873 £8,947 £13,065 £17,230 £21,445 £25,714 £30,038 £34,422 £38,869
Real Return on Investment %   (7.05%) 1.88% 10.89% 19.99% 29.19% 38.50% 47.92% 57.45% 67.12% 76.91% 86.85%