LL73 Marianglas cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £241,250
Input Equity (£60,313)
Input Equity FX (£60,313)
Total Input Equity (£60,313)
Total Input Equity FX (£60,313)
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 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250 £241,250
Finance Amount £180,938 £180,938 £175,532 £169,851 £163,878 £157,600 £151,001 £144,064 £136,773 £129,108 £121,051 £112,582
Monthly Mortgage   (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194) (£1,194)
Monthly Rental   £566 £566 £566 £566 £566 £566 £566 £566 £566 £566 £566
Yield to Purchase Price %   2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81%
Yield to Property Value %   2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81% 2.81%
Gross Monthly Cashflow   (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629)
Gross Annual Cashflow   (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543) (£7,543)
Gross Annual Expenses                        
Annual Management Expenses   (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380) (£380)
Gross Annual Cashflow less Expenses   (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882)
Vacancy Expenses                        
Net Annual Cashflow   (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882) (£7,882)
Net Yield %   (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%) (3.27%)
Debt Coverage Ratio (1:x)   0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45
Personal Equity £60,313 £60,313 £65,718 £71,399 £77,372 £83,650 £90,249 £97,186 £104,477 £112,142 £120,199 £128,668
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   (£7,923) (£2,517) £3,164 £9,137 £15,415 £22,014 £28,950 £36,242 £43,907 £51,964 £60,433
Return on Investment %   (13.14%) (4.17%) 5.25% 15.15% 25.56% 36.50% 48.00% 60.09% 72.80% 86.16% 100.20%
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   (£7,923) (£2,467) £3,039 £8,599 £14,218 £19,899 £25,646 £31,463 £37,354 £43,325 £49,378
Real Return on Investment %   (13.14%) (4.09%) 5.04% 14.26% 23.57% 32.99% 42.52% 52.17% 61.93% 71.83% 81.87%