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
I 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 I 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 I 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 I understand the mechanics — projecting free cash flow, discounting it, where terminal value comes from — not just how to fill a template.