LL12 Wrexham, Caergwrle, Cefn-y-Bedd, Cymau, Gresford, Hope, Llay, Marford, Rossett cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £239,601
Input Equity (£59,900)
Input Equity FX (£59,900)
Total Input Equity (£59,900)
Total Input Equity FX (£59,900)
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 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601 £239,601
Finance Amount £179,701 £179,701 £174,333 £168,690 £162,758 £156,523 £149,969 £143,080 £135,838 £128,226 £120,224 £111,813
Monthly Mortgage   (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186) (£1,186)
Monthly Rental   £666 £666 £666 £666 £666 £666 £666 £666 £666 £666 £666
Yield to Purchase Price %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Yield to Property Value %   3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33% 3.33%
Gross Monthly Cashflow   (£520) (£520) (£520) (£520) (£520) (£520) (£520) (£520) (£520) (£520) (£520)
Gross Annual Cashflow   (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242) (£6,242)
Gross Annual Expenses                        
Annual Management Expenses   (£447) (£447) (£447) (£447) (£447) (£447) (£447) (£447) (£447) (£447) (£447)
Gross Annual Cashflow less Expenses   (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642)
Vacancy Expenses                        
Net Annual Cashflow   (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642) (£6,642)
Net Yield %   (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%) (2.77%)
Debt Coverage Ratio (1:x)   0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
Personal Equity £59,900 £59,900 £65,268 £70,911 £76,843 £83,078 £89,632 £96,521 £103,763 £111,375 £119,377 £127,788
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,690) (£1,322) £4,321 £10,253 £16,488 £23,042 £29,931 £37,173 £44,785 £52,787 £61,198
Return on Investment %   (11.17%) (2.21%) 7.21% 17.12% 27.53% 38.47% 49.97% 62.06% 74.77% 88.13% 102.17%
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,690) (£1,295) £4,150 £9,650 £15,208 £20,828 £26,514 £32,271 £38,102 £44,011 £50,004
Real Return on Investment %   (11.17%) (2.16%) 6.93% 16.11% 25.39% 34.77% 44.26% 53.87% 63.61% 73.47% 83.48%