LL68 Amlwch, Bull Bay, Carreglefn, Llanfechell, Rhosybol cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £208,731
Input Equity (£52,183)
Total Input Equity (£52,183)
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 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731 £208,731
Finance Amount £156,548 £156,548 £151,872 £146,956 £141,788 £136,357 £130,647 £124,645 £118,337 £111,705 £104,734 £97,407
Monthly Mortgage   (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033) (£1,033)
Monthly Rental   £593 £593 £593 £593 £593 £593 £593 £593 £593 £593 £593
Yield to Purchase Price %   3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41%
Yield to Property Value %   3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41%
Gross Monthly Cashflow   (£440) (£440) (£440) (£440) (£440) (£440) (£440) (£440) (£440) (£440) (£440)
Gross Annual Cashflow   (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280) (£5,280)
Gross Annual Expenses                        
Annual Management Expenses   (£399) (£399) (£399) (£399) (£399) (£399) (£399) (£399) (£399) (£399) (£399)
Gross Annual Cashflow less Expenses   (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636)
Vacancy Expenses                        
Net Annual Cashflow   (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636) (£5,636)
Net Yield %   (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £52,183 £52,183 £56,859 £61,775 £66,943 £72,374 £78,084 £84,086 £90,394 £97,026 £103,997 £111,324
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,679) (£1,002) £3,914 £9,081 £14,513 £20,222 £26,224 £32,533 £39,164 £46,135 £53,463
Return on Investment %   (10.88%) (1.92%) 7.50% 17.40% 27.81% 38.75% 50.25% 62.34% 75.05% 88.41% 102.45%
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,679) (£982) £3,759 £8,547 £13,386 £18,279 £23,230 £28,242 £33,320 £38,465 £43,683
Real Return on Investment %   (10.88%) (1.88%) 7.20% 16.38% 25.65% 35.03% 44.52% 54.12% 63.85% 73.71% 83.71%