LL66 Rhosgoch cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £196,312
Input Equity (£49,078)
Total Input Equity (£49,078)
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 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312 £196,312
Finance Amount £147,234 £147,234 £142,836 £138,212 £133,352 £128,244 £122,874 £117,229 £111,296 £105,059 £98,503 £91,611
Monthly Mortgage   (£972) (£972) (£972) (£972) (£972) (£972) (£972) (£972) (£972) (£972) (£972)
Monthly Rental   £552 £552 £552 £552 £552 £552 £552 £552 £552 £552 £552
Yield to Purchase Price %   3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38%
Yield to Property Value %   3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38%
Gross Monthly Cashflow   (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419)
Gross Annual Cashflow   (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033) (£5,033)
Gross Annual Expenses                        
Annual Management Expenses   (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371) (£371)
Gross Annual Cashflow less Expenses   (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365)
Vacancy Expenses                        
Net Annual Cashflow   (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365) (£5,365)
Net Yield %   (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%)
Debt Coverage Ratio (1:x)   0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54
Personal Equity £49,078 £49,078 £53,476 £58,100 £62,960 £68,068 £73,438 £79,083 £85,016 £91,253 £97,809 £104,701
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   (£5,404) (£1,006) £3,617 £8,477 £13,586 £18,956 £24,600 £30,534 £36,771 £43,327 £50,218
Return on Investment %   (11.01%) (2.05%) 7.37% 17.27% 27.68% 38.62% 50.12% 62.21% 74.92% 88.28% 102.32%
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   (£5,404) (£986) £3,474 £7,979 £12,531 £17,134 £21,792 £26,507 £31,283 £36,124 £41,032
Real Return on Investment %   (11.01%) (2.01%) 7.08% 16.26% 25.53% 34.91% 44.40% 54.01% 63.74% 73.60% 83.61%