DCF Practice Case

You value a consumer packaged-goods company from a supplied forecast and valuation assumptions. The scored modules walk the full valuation chain: P&L, balance sheet, and cash flow drivers (21 checks), unlevered free cash flow projections (13 checks), a WACC calculation you build from its components (6 checks), the headline DCF outputs (15 checks), and sensitivity tables (2 checks).

Terminal value is scored under both the perpetuity growth method and the exit multiple method, including the implied cross-checks between them — because the interviewer's favourite follow-up is whether your growth assumption implies a sane exit multiple, and the model should answer that before they ask.

Every StreetCred case has an answer key that maps specific workbook cells to expected values. When you upload your .xlsx, the scorer opens it and compares each scored cell against the key within a numeric tolerance, so a rounding difference does not cost you points but a broken revenue build does.

Cells that should be calculated are also checked for a live formula. If you type the right number into an output cell instead of linking it through the model, the scorer flags it as a hardcode and tells you so in the report: correct value, zero credit for process.

Your process score weights formula quality at 70% and workbook hygiene, such as explicit number formats for currency, percentages, and multiples, at 30%. The report breaks results down by module and lists your top deductions, so you know exactly which schedule to rebuild next.