LS17 Alwoodley, Bardsey, East Keswick, Eccup, Harewood, Moor Allerton, Moortown, Shadwell, Weardley, Wike cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £469,231
Input Equity (£117,308)
Total Input Equity (£117,308)
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 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231 £469,231
Finance Amount £351,923 £351,923 £341,410 £330,359 £318,743 £306,532 £293,697 £280,205 £266,023 £251,115 £235,444 £218,972
Monthly Mortgage   (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323) (£2,323)
Monthly Rental   £1,067 £1,067 £1,067 £1,067 £1,067 £1,067 £1,067 £1,067 £1,067 £1,067 £1,067
Yield to Purchase Price %   2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73%
Yield to Property Value %   2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73%
Gross Monthly Cashflow   (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256) (£1,256)
Gross Annual Cashflow   (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072) (£15,072)
Gross Annual Expenses                        
Annual Management Expenses   (£717) (£717) (£717) (£717) (£717) (£717) (£717) (£717) (£717) (£717) (£717)
Gross Annual Cashflow less Expenses   (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712)
Vacancy Expenses                        
Net Annual Cashflow   (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712) (£15,712)
Net Yield %   (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%)
Debt Coverage Ratio (1:x)   0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44
Personal Equity £117,308 £117,308 £127,821 £138,872 £150,488 £162,699 £175,534 £189,026 £203,208 £218,116 £233,787 £250,259
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   (£15,789) (£5,276) £5,775 £17,391 £29,602 £42,437 £55,929 £70,112 £85,019 £100,690 £117,162
Return on Investment %   (13.46%) (4.50%) 4.92% 14.83% 25.23% 36.18% 47.68% 59.77% 72.48% 85.83% 99.88%
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   (£15,789) (£5,170) £5,546 £16,369 £27,304 £38,360 £49,545 £60,866 £72,331 £83,950 £95,730
Real Return on Investment %   (13.46%) (4.41%) 4.73% 13.95% 23.28% 32.70% 42.23% 51.89% 61.66% 71.56% 81.61%