LS21 Arthington, Otley, Pool cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £537,768
Input Equity (£134,442)
Total Input Equity (£134,442)
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 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768 £537,768
Finance Amount £403,326 £403,326 £391,277 £378,612 £365,299 £351,305 £336,595 £321,132 £304,879 £287,793 £269,834 £250,956
Monthly Mortgage   (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662) (£2,662)
Monthly Rental   £1,133 £1,133 £1,133 £1,133 £1,133 £1,133 £1,133 £1,133 £1,133 £1,133 £1,133
Yield to Purchase Price %   2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53%
Yield to Property Value %   2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53% 2.53%
Gross Monthly Cashflow   (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529) (£1,529)
Gross Annual Cashflow   (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348) (£18,348)
Gross Annual Expenses                        
Annual Management Expenses   (£761) (£761) (£761) (£761) (£761) (£761) (£761) (£761) (£761) (£761) (£761)
Gross Annual Cashflow less Expenses   (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028)
Vacancy Expenses                        
Net Annual Cashflow   (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028) (£19,028)
Net Yield %   (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%) (3.54%)
Debt Coverage Ratio (1:x)   0.40 0.40 0.40 0.40 0.40 0.40 0.40 0.40 0.40 0.40 0.40
Personal Equity £134,442 £134,442 £146,491 £159,156 £172,469 £186,463 £201,173 £216,636 £232,889 £249,975 £267,934 £286,812
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   (£19,109) (£7,061) £5,604 £18,917 £32,912 £47,622 £63,084 £79,338 £96,424 £114,383 £133,261
Return on Investment %   (14.21%) (5.25%) 4.17% 14.07% 24.48% 35.42% 46.92% 59.01% 71.72% 85.08% 99.12%
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   (£19,109) (£6,919) £5,383 £17,805 £30,357 £43,046 £55,883 £68,875 £82,034 £95,367 £108,884
Real Return on Investment %   (14.21%) (5.15%) 4.00% 13.24% 22.58% 32.02% 41.57% 51.23% 61.02% 70.94% 80.99%