Walk me through a DCF valuation from start to finish.
What the interviewer wants to hear
- Forecast unlevered free cash flow for 5 to 10 years from operating drivers
- Discount at WACC
- Terminal value by perpetual growth or exit multiple, then discount it
- Sum to enterprise value and bridge to equity value
- Divide by diluted shares and run sensitivities
Model answer
I first forecast the business for five to ten years: revenue from volume and price drivers, margins, capex and working capital. From that I calculate unlevered free cash flow each year: EBIT less tax, plus depreciation, minus capex, minus the increase in net working capital. Next I estimate WACC, using CAPM for cost of equity and the after-tax cost of debt, weighted by a target capital structure. I discount each year of free cash flow at WACC. Then I calculate a terminal value, either with the perpetual growth method, where growth should be no higher than long-run nominal GDP, or with an exit multiple, and discount it back from the final year. The sum is enterprise value. I subtract debt and similar claims, add cash, to get equity value, and divide by diluted shares. Finally I run sensitivities on WACC, growth and margins and cross-check the result with trading comparables.
Can you answer it under time pressure?
Take a timed hard round and get scored on every answer.
More hard Financial Analyst questions
- How would you estimate the WACC for an unlisted Indian mid-sized company?
- How do you choose and adjust a set of trading comparables for a valuation?
- A bank asks you to assess whether a mid-sized trading company in Dubai can take a new term loan. How would you analyse it?
- The company will miss its annual EBITDA forecast by 15%. How do you prepare the board pack and discussion?
- How would you value a fast-growing startup that is still making losses?
- What red flags would you look for when reviewing the quality of a company earnings?
- You join a growing company with only a spreadsheet budget. How would you build a driver-based FP&A process and board KPI pack?
- A group has operations in India and the UAE and reports in US dollars. How would you handle currency in budgeting and forecasting?
- An Indian company wants to open a subsidiary in Saudi Arabia or the UAE. How would you build the business case?