LL19 Prestatyn, Gronant cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £159,567
Input Equity (£39,892)
Total Input Equity (£39,892)
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 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567 £159,567
Finance Amount £119,675 £119,675 £116,100 £112,342 £108,392 £104,240 £99,875 £95,287 £90,464 £85,394 £80,065 £74,464
Monthly Mortgage   (£790) (£790) (£790) (£790) (£790) (£790) (£790) (£790) (£790) (£790) (£790)
Monthly Rental   £602 £602 £602 £602 £602 £602 £602 £602 £602 £602 £602
Yield to Purchase Price %   4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53%
Yield to Property Value %   4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53% 4.53%
Gross Monthly Cashflow   (£188) (£188) (£188) (£188) (£188) (£188) (£188) (£188) (£188) (£188) (£188)
Gross Annual Cashflow   (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251) (£2,251)
Gross Annual Expenses                        
Annual Management Expenses   (£405) (£405) (£405) (£405) (£405) (£405) (£405) (£405) (£405) (£405) (£405)
Gross Annual Cashflow less Expenses   (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613)
Vacancy Expenses                        
Net Annual Cashflow   (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613) (£2,613)
Net Yield %   (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%) (1.64%)
Debt Coverage Ratio (1:x)   0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72 0.72
Personal Equity £39,892 £39,892 £43,467 £47,225 £51,175 £55,327 £59,692 £64,280 £69,103 £74,173 £79,502 £85,103
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   (£2,656) £919 £4,677 £8,627 £12,780 £17,144 £21,732 £26,555 £31,625 £36,954 £42,555
Return on Investment %   (6.66%) 2.30% 11.72% 21.63% 32.04% 42.98% 54.48% 66.57% 79.28% 92.64% 106.68%
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   (£2,656) £901 £4,492 £8,120 £11,787 £15,497 £19,252 £23,053 £26,905 £30,810 £34,771
Real Return on Investment %   (6.66%) 2.26% 11.26% 20.35% 29.55% 38.85% 48.26% 57.79% 67.45% 77.23% 87.16%