LS19 Rawdon, Yeadon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £230,198
Input Equity (£57,550)
Input Equity FX (£57,550)
Total Input Equity (£57,550)
Total Input Equity FX (£57,550)
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 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198 £230,198
Finance Amount £172,649 £172,649 £167,491 £162,070 £156,371 £150,380 £144,084 £137,465 £130,507 £123,193 £115,506 £107,425
Monthly Mortgage   (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139) (£1,139)
Monthly Rental   £661 £661 £661 £661 £661 £661 £661 £661 £661 £661 £661
Yield to Purchase Price %   3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44%
Yield to Property Value %   3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44% 3.44%
Gross Monthly Cashflow   (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479)
Gross Annual Cashflow   (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745) (£5,745)
Gross Annual Expenses                        
Annual Management Expenses   (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444) (£444)
Gross Annual Cashflow less Expenses   (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142)
Vacancy Expenses                        
Net Annual Cashflow   (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142) (£6,142)
Net Yield %   (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%) (2.67%)
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 £57,550 £57,550 £62,707 £68,128 £73,827 £79,818 £86,114 £92,733 £99,691 £107,005 £114,692 £122,773
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   (£6,189) (£1,032) £4,390 £10,089 £16,079 £22,376 £28,995 £35,952 £43,266 £50,954 £59,035
Return on Investment %   (10.75%) (1.79%) 7.63% 17.53% 27.94% 38.88% 50.38% 62.47% 75.18% 88.54% 102.58%
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   (£6,189) (£1,011) £4,216 £9,495 £14,831 £20,226 £25,685 £31,211 £36,809 £42,483 £48,236
Real Return on Investment %   (10.75%) (1.76%) 7.33% 16.50% 25.77% 35.15% 44.63% 54.23% 63.96% 73.82% 83.82%