LS5 Hawksworth, Kirkstall cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £122,740
Input Equity (£30,685)
Input Equity FX (£30,685)
Total Input Equity (£30,685)
Total Input Equity FX (£30,685)
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 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740 £122,740
Finance Amount £92,055 £92,055 £89,305 £86,414 £83,376 £80,182 £76,824 £73,295 £69,585 £65,686 £61,587 £57,278
Monthly Mortgage   (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608) (£608)
Monthly Rental   £731 £731 £731 £731 £731 £731 £731 £731 £731 £731 £731
Yield to Purchase Price %   7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15%
Yield to Property Value %   7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15% 7.15%
Gross Monthly Cashflow   £123 £123 £123 £123 £123 £123 £123 £123 £123 £123 £123
Gross Annual Cashflow   £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482
Gross Annual Expenses                        
Annual Management Expenses   (£491) (£491) (£491) (£491) (£491) (£491) (£491) (£491) (£491) (£491) (£491)
Gross Annual Cashflow less Expenses   £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043
Vacancy Expenses                        
Net Annual Cashflow   £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043
Taxable Income   £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482 £1,482
Tax Payable                        
Net Annual Cashflow Less Tax   £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043 £1,043
Net Yield %   0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85% 0.85%
Debt Coverage Ratio (1:x)   1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14 1.14
Personal Equity £30,685 £30,685 £33,435 £36,326 £39,364 £42,558 £45,916 £49,445 £53,155 £57,054 £61,153 £65,462
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   £990 £3,740 £6,631 £9,670 £12,864 £16,221 £19,750 £23,460 £27,360 £31,459 £35,767
Return on Investment %   3.23% 12.19% 21.61% 31.51% 41.92% 52.86% 64.36% 76.45% 89.16% 102.52% 116.56%
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   £990 £3,666 £6,368 £9,101 £11,865 £14,663 £17,496 £20,366 £23,276 £26,229 £29,225
Real Return on Investment %   3.23% 11.95% 20.75% 29.66% 38.67% 47.78% 57.02% 66.37% 75.86% 85.48% 95.24%