Default: 10% - Cost of capital for discounting
Default: 25% (UK) - Applied to EBIT
Default: 2.5% - Long-term growth assumption
Total debt minus cash - for equity value calculation
Discounted Cash Flow (DCF) Analysis Tool
| Financial Item | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
|---|---|---|---|---|---|
| Revenue | |||||
| COGS | |||||
| Fixed Costs | |||||
| D&A | |||||
| CapEx | |||||
| Change in NWC |
| Year | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|
| EBIT (£000s) | £0 | £0 | £0 | £0 | £0 |
| NOPAT (£000s) | £0 | £0 | £0 | £0 | £0 |
| Free Cash Flow (£000s) | £0 | £0 | £0 | £0 | £0 |
| Present Value (£000s) | £0 | £0 | £0 | £0 | £0 |
| Sum of PV of FCFs (£000s) | £0 |
| Terminal Value (£000s) | £0 |
| PV of Terminal Value (£000s) | £0 |
| Enterprise Value (£000s) | £0 |
| Less: Net Debt (£000s) | £0 |