BT77 Augher cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £115,349
Input Equity (£28,837)
Total Input Equity (£28,837)
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 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349 £115,349
Finance Amount £86,512 £86,512 £83,927 £81,211 £78,355 £75,354 £72,198 £68,882 £65,395 £61,730 £57,878 £53,829
Monthly Mortgage   (£571) (£571) (£571) (£571) (£571) (£571) (£571) (£571) (£571) (£571) (£571)
Monthly Rental   £397 £397 £397 £397 £397 £397 £397 £397 £397 £397 £397
Yield to Purchase Price %   4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13%
Yield to Property Value %   4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13% 4.13%
Gross Monthly Cashflow   (£174) (£174) (£174) (£174) (£174) (£174) (£174) (£174) (£174) (£174) (£174)
Gross Annual Cashflow   (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087) (£2,087)
Gross Annual Expenses                        
Annual Management Expenses   (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267)
Gross Annual Cashflow less Expenses   (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325)
Vacancy Expenses                        
Net Annual Cashflow   (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325) (£2,325)
Net Yield %   (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%) (2.02%)
Debt Coverage Ratio (1:x)   0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66
Personal Equity £28,837 £28,837 £31,422 £34,138 £36,994 £39,995 £43,151 £46,467 £49,954 £53,619 £57,471 £61,520
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   (£2,354) £230 £2,947 £5,803 £8,804 £11,959 £15,276 £18,762 £22,427 £26,279 £30,329
Return on Investment %   (8.16%) 0.80% 10.22% 20.12% 30.53% 41.47% 52.97% 65.06% 77.77% 91.13% 105.17%
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   (£2,354) £226 £2,830 £5,461 £8,121 £10,810 £13,532 £16,288 £19,080 £21,910 £24,781
Real Return on Investment %   (8.16%) 0.78% 9.81% 18.94% 28.16% 37.49% 46.93% 56.48% 66.17% 75.98% 85.93%