Equity Research & Corp Dev
Practice Your Consumer DCF Model Online
Stop practicing with dead answer keys. Upload your DCF Model to SheetRank and our AI engine will instantly audit your math, catch disguised hardcodes, and trace your root-cause errors.
Why Consumer modeling is different
Same-store sales, gross margin by category, and inventory turns separate winners from laggards — seasonality and promotional lift must be modeled explicitly.
What a DCF Model actually tests
A DCF tests whether you can build unlevered free cash flow correctly, discount it at a defensible WACC, and handle terminal value without either input silently dominating your entire valuation. Most DCF mistakes aren't arithmetic errors — they're using levered instead of unlevered cash flow, or picking a terminal growth rate that implies an unrealistic long-run return on capital.
Common DCF Model interview questions
How do you calculate WACC?
WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 − Tax Rate)), where E and D are the market values of equity and debt and V = E + D. Cost of equity is usually CAPM (risk-free rate + beta × equity risk premium); cost of debt is the company's current borrowing rate, tax-affected because interest is tax-deductible.
Gordon Growth vs. exit multiple for terminal value — which do you use and why?
Exit multiple is more common in banking because it's easier to defend against comparable transactions, but it implicitly assumes the market multiple environment holds at exit. Gordon Growth is more defensible academically (it's just a perpetuity) but is extremely sensitive to the growth-rate assumption — a 1% change in terminal growth can swing the valuation by a large margin, so it's worth sanity-checking the implied exit multiple either way.
What's the difference between levered and unlevered free cash flow?
Unlevered FCF excludes the effects of financing — no interest expense, no debt paydown — and represents cash available to all capital providers, which is what you discount at WACC to get enterprise value. Levered FCF nets out interest and mandatory debt paydown, representing cash available to equity holders specifically, and gets discounted at cost of equity instead.
What you get on SheetRank
- Live spreadsheet IDE — build from a blank grid, not a template
- Hidden-scenario grading with ±$1 and 0.01% cap rate tolerance
- Hardcode firewall that catches disguised constants like =LOG10(10)*90
- Root-cause error tracing through your formula dependency graph
- Leaderboard rankings to benchmark speed and accuracy
Practice this on a real deal
Project Catalyst is a real, graded DCF Model on SheetRank — not a hypothetical.
Underwrite Project CatalystLooking for interview prep guides? Browse resources or explore the public leaderboard.