LE41 Non-geographic cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £124,083
Input Equity (£31,021)
Total Input Equity (£31,021)
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 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083 £124,083
Finance Amount £93,062 £93,062 £90,282 £87,360 £84,288 £81,059 £77,665 £74,097 £70,347 £66,405 £62,261 £57,905
Monthly Mortgage   (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614)
Monthly Rental   £574 £574 £574 £574 £574 £574 £574 £574 £574 £574 £574
Yield to Purchase Price %   5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55%
Yield to Property Value %   5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55% 5.55%
Gross Monthly Cashflow   (£40) (£40) (£40) (£40) (£40) (£40) (£40) (£40) (£40) (£40) (£40)
Gross Annual Cashflow   (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480)
Gross Annual Expenses                        
Annual Management Expenses   (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386) (£386)
Gross Annual Cashflow less Expenses   (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824)
Vacancy Expenses                        
Net Annual Cashflow   (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824) (£824)
Net Yield %   (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%) (0.66%)
Debt Coverage Ratio (1:x)   0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89 0.89
Personal Equity £31,021 £31,021 £33,801 £36,723 £39,795 £43,024 £46,418 £49,986 £53,736 £57,678 £61,822 £66,178
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   (£865) £1,915 £4,837 £7,909 £11,138 £14,532 £18,100 £21,850 £25,792 £29,936 £34,292
Return on Investment %   (2.79%) 6.17% 15.59% 25.50% 35.90% 46.85% 58.35% 70.44% 83.15% 96.50% 110.55%
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   (£865) £1,876 £4,645 £7,444 £10,273 £13,136 £16,033 £18,969 £21,943 £24,959 £28,019
Real Return on Investment %   (2.79%) 6.05% 14.98% 24.00% 33.12% 42.34% 51.69% 61.15% 70.74% 80.46% 90.32%