DCF Valuation in Excel: A D2C Brand with Scenarios and a Sensitivity Table

<p>Haldi Haus, a Bengaluru D2C skincare brand, has a cash offer from a large FMCG group, and its board wants to know what the company is really worth before it replies. Across five lessons you build the whole discounted cash flow valuation yourself, in your own personal workbook: turn a GST-inclusive Shopify export into net revenue and normalised EBITDA, forecast five years of free cash flow to the firm (tax on EBIT, capex, working capital), build the WACC from CAPM and an after-tax cost of debt, value the years after FY 2030-31 with the Gordon growth formula, and walk from enterprise value to equity value and a value per share. Then you make the uncertainty visible: a Bear/Base/Bull switch with CHOOSE, a one-variable Data Table of all three scenarios, and a WACC × terminal-growth sensitivity table coloured as a heat map. Every lesson then hands the same job to your AI (Copilot, ChatGPT, Claude or Gemini) and shows you exactly how to catch its mistakes. In the capstone your AI cross-checks the DCF with an exit multiple, works out the growth that multiple implies, weights the scenarios, measures the offer the way the buyer does and draws a football-field chart, and you prove every number before it reaches the board.</p>

Tools: Discounted cash flow (DCF) valuation, Free cash flow to the firm, WACC, CAPM and terminal value, CHOOSE scenario switches, What-If Data Tables and sensitivity analysis, AI assistants for Excel