LN7 Market Rasen cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £235,388
Input Equity (£58,847)
Total Input Equity (£58,847)
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 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388 £235,388
Finance Amount £176,541 £176,541 £171,267 £165,724 £159,896 £153,771 £147,332 £140,564 £133,449 £125,971 £118,110 £109,846
Monthly Mortgage   (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165) (£1,165)
Monthly Rental   £517 £517 £517 £517 £517 £517 £517 £517 £517 £517 £517
Yield to Purchase Price %   2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64%
Yield to Property Value %   2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64% 2.64%
Gross Monthly Cashflow   (£648) (£648) (£648) (£648) (£648) (£648) (£648) (£648) (£648) (£648) (£648)
Gross Annual Cashflow   (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776) (£7,776)
Gross Annual Expenses                        
Annual Management Expenses   (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348) (£348)
Gross Annual Cashflow less Expenses   (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086)
Vacancy Expenses                        
Net Annual Cashflow   (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086) (£8,086)
Net Yield %   (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%) (3.44%)
Debt Coverage Ratio (1:x)   0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42 0.42
Personal Equity £58,847 £58,847 £64,121 £69,664 £75,492 £81,617 £88,056 £94,824 £101,939 £109,417 £117,278 £125,542
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   (£8,123) (£2,849) £2,694 £8,522 £14,647 £21,086 £27,854 £34,969 £42,447 £50,308 £58,571
Return on Investment %   (13.80%) (4.84%) 4.58% 14.48% 24.89% 35.83% 47.33% 59.42% 72.13% 85.49% 99.53%
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   (£8,123) (£2,792) £2,588 £8,021 £13,510 £19,060 £24,674 £30,357 £36,112 £41,944 £47,857
Real Return on Investment %   (13.80%) (4.74%) 4.40% 13.63% 22.96% 32.39% 41.93% 51.59% 61.37% 71.28% 81.32%