LL60 Gaerwen, Llanddaniel, Llangaffo, Star cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £237,671
Input Equity (£59,418)
Total Input Equity (£59,418)
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 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671 £237,671
Finance Amount £178,253 £178,253 £172,928 £167,331 £161,447 £155,262 £148,761 £141,927 £134,744 £127,193 £119,255 £110,912
Monthly Mortgage   (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176) (£1,176)
Monthly Rental   £614 £614 £614 £614 £614 £614 £614 £614 £614 £614 £614
Yield to Purchase Price %   3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
Yield to Property Value %   3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10% 3.10%
Gross Monthly Cashflow   (£563) (£563) (£563) (£563) (£563) (£563) (£563) (£563) (£563) (£563) (£563)
Gross Annual Cashflow   (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754) (£6,754)
Gross Annual Expenses                        
Annual Management Expenses   (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412)
Gross Annual Cashflow less Expenses   (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123)
Vacancy Expenses                        
Net Annual Cashflow   (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123) (£7,123)
Net Yield %   (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%) (3.00%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £59,418 £59,418 £64,743 £70,340 £76,224 £82,409 £88,910 £95,744 £102,927 £110,478 £118,416 £126,759
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   (£7,167) (£1,842) £3,756 £9,639 £15,824 £22,325 £29,159 £36,343 £43,894 £51,831 £60,175
Return on Investment %   (12.06%) (3.10%) 6.32% 16.22% 26.63% 37.57% 49.08% 61.16% 73.87% 87.23% 101.27%
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   (£7,167) (£1,805) £3,607 £9,073 £14,596 £20,180 £25,831 £31,550 £37,343 £43,214 £49,167
Real Return on Investment %   (12.06%) (3.04%) 6.07% 15.27% 24.56% 33.96% 43.47% 53.10% 62.85% 72.73% 82.75%