LL67 Cemaes Bay, Tregele cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £209,879
Input Equity (£52,470)
Total Input Equity (£52,470)
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 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879 £209,879
Finance Amount £157,409 £157,409 £152,707 £147,764 £142,568 £137,107 £131,366 £125,331 £118,987 £112,319 £105,310 £97,942
Monthly Mortgage   (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039)
Monthly Rental   £642 £642 £642 £642 £642 £642 £642 £642 £642 £642 £642
Yield to Purchase Price %   3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67%
Yield to Property Value %   3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67% 3.67%
Gross Monthly Cashflow   (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397) (£397)
Gross Annual Cashflow   (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761) (£4,761)
Gross Annual Expenses                        
Annual Management Expenses   (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431) (£431)
Gross Annual Cashflow less Expenses   (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146)
Vacancy Expenses                        
Net Annual Cashflow   (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146) (£5,146)
Net Yield %   (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%) (2.45%)
Debt Coverage Ratio (1:x)   0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59 0.59
Personal Equity £52,470 £52,470 £57,172 £62,115 £67,311 £72,772 £78,513 £84,548 £90,892 £97,560 £104,569 £111,937
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   (£5,192) (£490) £4,453 £9,649 £15,110 £20,851 £26,886 £33,229 £39,897 £46,907 £54,274
Return on Investment %   (9.90%) (0.93%) 8.49% 18.39% 28.80% 39.74% 51.24% 63.33% 76.04% 89.40% 103.44%
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   (£5,192) (£480) £4,276 £9,081 £13,937 £18,848 £23,817 £28,847 £33,943 £39,108 £44,346
Real Return on Investment %   (9.90%) (0.92%) 8.15% 17.31% 26.56% 35.92% 45.39% 54.98% 64.69% 74.53% 84.52%