MK1 Denbigh, Mount Farm cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £239,771
Input Equity (£59,943)
Total Input Equity (£59,943)
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 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771 £239,771
Finance Amount £179,828 £179,828 £174,456 £168,809 £162,874 £156,634 £150,075 £143,181 £135,934 £128,316 £120,309 £111,892
Monthly Mortgage   (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187) (£1,187)
Monthly Rental   £981 £981 £981 £981 £981 £981 £981 £981 £981 £981 £981
Yield to Purchase Price %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Yield to Property Value %   4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91% 4.91%
Gross Monthly Cashflow   (£206) (£206) (£206) (£206) (£206) (£206) (£206) (£206) (£206) (£206) (£206)
Gross Annual Cashflow   (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470) (£2,470)
Gross Annual Expenses                        
Annual Management Expenses   (£659) (£659) (£659) (£659) (£659) (£659) (£659) (£659) (£659) (£659) (£659)
Gross Annual Cashflow less Expenses   (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059)
Vacancy Expenses                        
Net Annual Cashflow   (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059) (£3,059)
Net Yield %   (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%) (1.28%)
Debt Coverage Ratio (1:x)   0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79
Personal Equity £59,943 £59,943 £65,315 £70,962 £76,897 £83,137 £89,696 £96,590 £103,837 £111,455 £119,462 £127,879
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   (£3,129) £2,243 £7,890 £13,825 £20,065 £26,624 £33,518 £40,765 £48,383 £56,390 £64,807
Return on Investment %   (5.22%) 3.74% 13.16% 23.06% 33.47% 44.42% 55.92% 68.01% 80.71% 94.07% 108.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   (£3,129) £2,198 £7,577 £13,012 £18,507 £24,066 £29,692 £35,389 £41,162 £47,015 £52,952
Real Return on Investment %   (5.22%) 3.67% 12.64% 21.71% 30.87% 40.15% 49.53% 59.04% 68.67% 78.43% 88.34%