DCF & Valuation Models
Valuation and unit-economics built from first principles, plus a live DCF calculator you can play with.
01 · The opportunity
What it set out to solve
Any business needs defensible numbers for valuation and profitability, not gut feel, and the intuition is usually buried inside spreadsheet cells nobody opens.
02 · The approach
How I thought about it
We apply security analysis and valuation to a real business case: a DCF and a COGS-driven P&L that tie every assumption to the output. Then we rebuild the DCF as an interactive tool so the intuition is visible, not hidden in cells.
03 · What I built
- Discounted cash flow valuation model (Excel)
- COGS and P&L model with scenario levers
- MRP / invoice cross-check tooling
- A live, interactive DCF calculator (below), change the assumptions, watch enterprise value move
04 · The result
What changed
Cleaner financial decisions grounded in transparent assumptions, and a demo that shows we understand what's inside the model, not just how to run one.
Play with the assumptions.
Move the sliders and watch enterprise value respond. It's the same discounted-cash-flow logic as the Excel model, just made visible.
Assumptions
Enterprise value
₹248 Cr
74% of the value sits in the terminal value, most of a growth business is worth what happens after the forecast.
PV of forecast FCF
₹64 Cr
PV of terminal value
₹183 Cr
Simplifying assumption: free cash flow ≈ NOPAT (depreciation ≈ capex, no working-capital swing). Enough to show the intuition, nudge WACC or growth and watch value move. A full model layers in those line items.
05 · Decisions & trade-offs
The questions I'd get asked about this, and my answers
Why build models in Excel/Sheets and not code?
The audience is finance leadership. A transparent model they can open and poke beats a black-box script. Excel is the right tool when the reader needs to see every assumption.
Then why also build the interactive version here?
To make the sensitivity obvious: nudge WACC and watch value swing. It proves we understand the mechanics, projecting free cash flow, discounting it, where terminal value comes from, not just how to fill a template.