LL34 Penmaenmawr, Dwygyfylchi cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £209,244
Input Equity (£52,311)
Total Input Equity (£52,311)
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,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244 £209,244
Finance Amount £156,933 £156,933 £152,245 £147,317 £142,137 £136,692 £130,968 £124,952 £118,627 £111,980 £104,992 £97,646
Monthly Mortgage   (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036) (£1,036)
Monthly Rental   £617 £617 £617 £617 £617 £617 £617 £617 £617 £617 £617
Yield to Purchase Price %   3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54%
Yield to Property Value %   3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54% 3.54%
Gross Monthly Cashflow   (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418)
Gross Annual Cashflow   (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020) (£5,020)
Gross Annual Expenses                        
Annual Management Expenses   (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415) (£415)
Gross Annual Cashflow less Expenses   (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390)
Vacancy Expenses                        
Net Annual Cashflow   (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390) (£5,390)
Net Yield %   (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%) (2.58%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £52,311 £52,311 £56,999 £61,927 £67,107 £72,552 £78,276 £84,292 £90,617 £97,264 £104,252 £111,598
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,435) (£747) £4,181 £9,361 £14,806 £20,530 £26,546 £32,871 £39,519 £46,507 £53,852
Return on Investment %   (10.39%) (1.43%) 7.99% 17.90% 28.30% 39.25% 50.75% 62.84% 75.55% 88.90% 102.95%
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,435) (£732) £4,016 £8,811 £13,657 £18,557 £23,516 £28,536 £33,621 £38,775 £44,001
Real Return on Investment %   (10.39%) (1.40%) 7.68% 16.84% 26.11% 35.48% 44.95% 54.55% 64.27% 74.12% 84.11%