ME3 Rochester cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £241,909
Input Equity (£60,477)
Input Equity FX (£60,477)
Total Input Equity (£60,477)
Total Input Equity FX (£60,477)
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 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909 £241,909
Finance Amount £181,432 £181,432 £176,012 £170,315 £164,326 £158,031 £151,414 £144,458 £137,146 £129,461 £121,382 £112,890
Monthly Mortgage   (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197) (£1,197)
Monthly Rental   £851 £851 £851 £851 £851 £851 £851 £851 £851 £851 £851
Yield to Purchase Price %   4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22%
Yield to Property Value %   4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22% 4.22%
Gross Monthly Cashflow   (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347)
Gross Annual Cashflow   (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161) (£4,161)
Gross Annual Expenses                        
Annual Management Expenses   (£572) (£572) (£572) (£572) (£572) (£572) (£572) (£572) (£572) (£572) (£572)
Gross Annual Cashflow less Expenses   (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672)
Vacancy Expenses                        
Net Annual Cashflow   (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672) (£4,672)
Net Yield %   (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%) (1.93%)
Debt Coverage Ratio (1:x)   0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
Personal Equity £60,477 £60,477 £65,897 £71,594 £77,583 £83,878 £90,495 £97,451 £104,763 £112,448 £120,527 £129,019
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   (£4,733) £687 £6,384 £12,373 £18,668 £25,285 £32,241 £39,552 £47,238 £55,317 £63,809
Return on Investment %   (7.83%) 1.14% 10.56% 20.46% 30.87% 41.81% 53.31% 65.40% 78.11% 91.47% 105.51%
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   (£4,733) £673 £6,131 £11,645 £17,219 £22,856 £28,560 £34,336 £40,188 £46,120 £52,137
Real Return on Investment %   (7.83%) 1.11% 10.14% 19.26% 28.47% 37.79% 47.22% 56.78% 66.45% 76.26% 86.21%