LL56 Y Felinheli cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £183,194
Input Equity (£45,799)
Total Input Equity (£45,799)
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 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194 £183,194
Finance Amount £137,396 £137,396 £133,291 £128,977 £124,441 £119,674 £114,663 £109,396 £103,859 £98,039 £91,921 £85,490
Monthly Mortgage   (£907) (£907) (£907) (£907) (£907) (£907) (£907) (£907) (£907) (£907) (£907)
Monthly Rental   £662 £662 £662 £662 £662 £662 £662 £662 £662 £662 £662
Yield to Purchase Price %   4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34%
Yield to Property Value %   4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34% 4.34%
Gross Monthly Cashflow   (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245) (£245)
Gross Annual Cashflow   (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939) (£2,939)
Gross Annual Expenses                        
Annual Management Expenses   (£445) (£445) (£445) (£445) (£445) (£445) (£445) (£445) (£445) (£445) (£445)
Gross Annual Cashflow less Expenses   (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336)
Vacancy Expenses                        
Net Annual Cashflow   (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336) (£3,336)
Net Yield %   (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%) (1.82%)
Debt Coverage Ratio (1:x)   0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69 0.69
Personal Equity £45,799 £45,799 £49,903 £54,217 £58,753 £63,520 £68,531 £73,798 £79,335 £85,155 £91,273 £97,704
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,383) £721 £5,036 £9,571 £14,338 £19,349 £24,616 £30,153 £35,974 £42,092 £48,523
Return on Investment %   (7.39%) 1.57% 10.99% 20.90% 31.31% 42.25% 53.75% 65.84% 78.55% 91.91% 105.95%
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,383) £707 £4,836 £9,008 £13,225 £17,490 £21,806 £26,177 £30,605 £35,094 £39,646
Real Return on Investment %   (7.39%) 1.54% 10.56% 19.67% 28.88% 38.19% 47.61% 57.16% 66.83% 76.63% 86.57%