LL62 Bodorgan, Bethel, Hermon, Llangristiolus, Malltraeth, Trefdraeth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £273,859
Input Equity (£68,465)
Total Input Equity (£68,465)
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 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859 £273,859
Finance Amount £205,394 £205,394 £199,258 £192,809 £186,029 £178,903 £171,411 £163,537 £155,260 £146,559 £137,413 £127,799
Monthly Mortgage   (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356) (£1,356)
Monthly Rental   £438 £438 £438 £438 £438 £438 £438 £438 £438 £438 £438
Yield to Purchase Price %   1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92%
Yield to Property Value %   1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92% 1.92%
Gross Monthly Cashflow   (£917) (£917) (£917) (£917) (£917) (£917) (£917) (£917) (£917) (£917) (£917)
Gross Annual Cashflow   (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009) (£11,009)
Gross Annual Expenses                        
Annual Management Expenses   (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294)
Gross Annual Cashflow less Expenses   (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272)
Vacancy Expenses                        
Net Annual Cashflow   (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272) (£11,272)
Net Yield %   (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%) (4.12%)
Debt Coverage Ratio (1:x)   0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31 0.31
Personal Equity £68,465 £68,465 £74,601 £81,050 £87,830 £94,956 £102,448 £110,322 £118,599 £127,300 £136,446 £146,060
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   (£11,304) (£5,168) £1,282 £8,062 £15,188 £22,679 £30,554 £38,831 £47,532 £56,677 £66,291
Return on Investment %   (16.51%) (7.55%) 1.87% 11.77% 22.18% 33.13% 44.63% 56.72% 69.42% 82.78% 96.83%
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   (£11,304) (£5,064) £1,231 £7,587 £14,009 £20,500 £27,066 £33,710 £40,438 £47,255 £54,165
Real Return on Investment %   (16.51%) (7.40%) 1.80% 11.08% 20.46% 29.94% 39.53% 49.24% 59.06% 69.02% 79.11%