Tasks
1. Prepare an Excel spreadsheet containing the following:
- Construct the next five-year pro-forma statements (income statement and balance sheet) following the FSM_B.xls file format.
- Estimate annual FCFF.
- Estimate the company's WACC.
- Estimate the terminal value and the enterprise value.
- Conduct the sensitivity analysis, scenario analysis, and Monte Carlo simulation on the enterprise value.
2. Prepare a PowerPoint deck including a high-level executive summary and conclusions, together with an appendix containing details such as assumptions and robustness checks.