LL58 Beaumaris, Llanddona, Llanfaes, Llangoed, Penmon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £286,872
Input Equity (£71,718)
Total Input Equity (£71,718)
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 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872 £286,872
Finance Amount £215,154 £215,154 £208,727 £201,971 £194,869 £187,404 £179,556 £171,308 £162,637 £153,523 £143,943 £133,872
Monthly Mortgage   (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420)
Monthly Rental   £545 £545 £545 £545 £545 £545 £545 £545 £545 £545 £545
Yield to Purchase Price %   2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28%
Yield to Property Value %   2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28% 2.28%
Gross Monthly Cashflow   (£875) (£875) (£875) (£875) (£875) (£875) (£875) (£875) (£875) (£875) (£875)
Gross Annual Cashflow   (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500) (£10,500)
Gross Annual Expenses                        
Annual Management Expenses   (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366)
Gross Annual Cashflow less Expenses   (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827)
Vacancy Expenses                        
Net Annual Cashflow   (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827) (£10,827)
Net Yield %   (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%) (3.77%)
Debt Coverage Ratio (1:x)   0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36 0.36
Personal Equity £71,718 £71,718 £78,145 £84,901 £92,003 £99,468 £107,316 £115,564 £124,235 £133,349 £142,929 £153,000
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   (£10,867) (£4,439) £2,317 £9,419 £16,884 £24,731 £32,980 £41,650 £50,764 £60,345 £70,415
Return on Investment %   (15.15%) (6.19%) 3.23% 13.13% 23.54% 34.48% 45.99% 58.07% 70.78% 84.14% 98.18%
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   (£10,867) (£4,350) £2,225 £8,865 £15,573 £22,355 £29,215 £36,158 £43,188 £50,312 £57,534
Real Return on Investment %   (15.15%) (6.07%) 3.10% 12.36% 21.71% 31.17% 40.74% 50.42% 60.22% 70.15% 80.22%