LD8 Presteigne cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £321,553
Input Equity (£80,388)
Total Input Equity (£80,388)
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 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553 £321,553
Finance Amount £241,165 £241,165 £233,960 £226,387 £218,427 £210,059 £201,264 £192,018 £182,299 £172,083 £161,344 £150,056
Monthly Mortgage   (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592) (£1,592)
Monthly Rental   £545 £545 £545 £545 £545 £545 £545 £545 £545 £545 £545
Yield to Purchase Price %   2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03%
Yield to Property Value %   2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03% 2.03%
Gross Monthly Cashflow   (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046) (£1,046)
Gross Annual Cashflow   (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556) (£12,556)
Gross Annual Expenses                        
Annual Management Expenses   (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366) (£366)
Gross Annual Cashflow less Expenses   (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883)
Vacancy Expenses                        
Net Annual Cashflow   (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883) (£12,883)
Net Yield %   (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%) (4.01%)
Debt Coverage Ratio (1:x)   0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33 0.33
Personal Equity £80,388 £80,388 £87,593 £95,166 £103,126 £111,494 £120,289 £129,535 £139,254 £149,470 £160,209 £171,497
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   (£12,923) (£5,718) £1,855 £9,815 £18,183 £26,978 £36,224 £45,943 £56,159 £66,898 £78,186
Return on Investment %   (16.08%) (7.11%) 2.31% 12.21% 22.62% 33.56% 45.06% 57.15% 69.86% 83.22% 97.26%
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   (£12,923) (£5,604) £1,781 £9,238 £16,771 £24,386 £32,089 £39,884 £47,778 £55,776 £63,883
Real Return on Investment %   (16.08%) (6.97%) 2.22% 11.49% 20.86% 30.34% 39.92% 49.61% 59.43% 69.38% 79.47%