LS25 Aberford, Ferry Fryston, Garforth, Hillam, Kippax, Ledsham, Micklefield, Monk Fryston, Sherburn-in-Elmet cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £235,151
Input Equity (£58,788)
Total Input Equity (£58,788)
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 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151 £235,151
Finance Amount £176,363 £176,363 £171,095 £165,557 £159,735 £153,616 £147,184 £140,422 £133,315 £125,844 £117,991 £109,736
Monthly Mortgage   (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164) (£1,164)
Monthly Rental   £752 £752 £752 £752 £752 £752 £752 £752 £752 £752 £752
Yield to Purchase Price %   3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84%
Yield to Property Value %   3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84% 3.84%
Gross Monthly Cashflow   (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412) (£412)
Gross Annual Cashflow   (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940) (£4,940)
Gross Annual Expenses                        
Annual Management Expenses   (£506) (£506) (£506) (£506) (£506) (£506) (£506) (£506) (£506) (£506) (£506)
Gross Annual Cashflow less Expenses   (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391)
Vacancy Expenses                        
Net Annual Cashflow   (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391) (£5,391)
Net Yield %   (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%) (2.29%)
Debt Coverage Ratio (1:x)   0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61 0.61
Personal Equity £58,788 £58,788 £64,056 £69,594 £75,416 £81,535 £87,967 £94,729 £101,836 £109,307 £117,160 £125,415
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,446) (£177) £5,361 £11,182 £17,302 £23,734 £30,495 £37,603 £45,074 £52,927 £61,182
Return on Investment %   (9.26%) (0.30%) 9.12% 19.02% 29.43% 40.37% 51.87% 63.96% 76.67% 90.03% 104.07%
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,446) (£174) £5,149 £10,525 £15,958 £21,454 £27,014 £32,644 £38,347 £44,128 £49,990
Real Return on Investment %   (9.26%) (0.30%) 8.76% 17.90% 27.15% 36.49% 45.95% 55.53% 65.23% 75.06% 85.03%