Next Mediaworks DCF Value
Detailed discounted cash flow valuation, assumptions and scenarios.
DCF Assumptions
Base DCF · ₹22
Base is the production estimate: 25% Bull + 50% model base case + 25% Bear, weighted before rounding. The model base case alone is ₹22.
- Normalized starting FCF (₹ crore)
- 4.74
- Stored company classification
- highly_cyclical
- FCF growth in years 1–5
- 25/50/25 mixture of the three growth paths
- Stored revenue growth assumption
- 25.00%
- Discount rate / WACC
- 11.00%
- Terminal growth
- 5.00%
- Stored shares (crore)
- 6.69
- Net debt / (net cash), ₹ crore
- 38.40
The existing production model grows normalized FCF at the selected revenue-growth assumption for five years; it does not taper growth or add a separate margin improvement.
DCF Calculation
Amounts in ₹ crore. Base rows are probability-weighted cash flows, not a single growth path. Swipe tables horizontally on smaller screens.
| Year | Projected FCF | Discount factor | Present value |
|---|---|---|---|
| 1 | 5.93 | 0.900901 | 5.34 |
| 2 | 7.41 | 0.811622 | 6.01 |
| 3 | 9.27 | 0.731191 | 6.78 |
| 4 | 11.59 | 0.658731 | 7.64 |
| 5 | 14.51 | 0.593451 | 8.61 |
- PV of projected cash flows
- 34.37
- Terminal FCF
- 15.23
- Terminal value
- 253.87
- Discounted terminal value
- 150.66
- Enterprise value
- 185.03
- Less net debt / (net cash)
- 38.40
- Equity value
- 146.63
- Reconciled per-share value (₹)
- 21.92
PV = FCF ÷ (1 + WACC)^year. Terminal value = Year 5 FCF × (1 + terminal growth) ÷ (WACC − terminal growth). Equity value = enterprise value − net debt; per-share value = equity value ÷ shares.
Underlying model scenarios
| Model case | Growth | Probability | Stored DCF | Reconciled |
|---|---|---|---|---|
| Bear | 22.00% | 25% | ₹19 | ₹18.89 |
| Model base case | 25.00% | 50% | ₹22 | ₹21.85 |
| Bull | 28.00% | 25% | ₹25 | ₹25.09 |
Bear growth = max(clamped growth − 3 percentage points, −2%). Bull growth = min(clamped growth + 3 percentage points, 35%). WACC, terminal growth, shares and net debt are common to all cases.
DCF Sensitivity Analysis
Diagnostic values use the existing production DCF function with unchanged FCF, growth, shares and net debt. Columns vary terminal growth; rows vary WACC. These values do not change the selected scenario.
| WACC / terminal growth | 4.00% | 5.00% | 6.00% |
|---|---|---|---|
| 10.00% | ₹23 | ₹28 | ₹35 |
| 11.00% | ₹19 | ₹22 | ₹27 |
| 12.00% | ₹15 | ₹18 | ₹21 |
Reverse DCF
What growth is the current market price implying?
Forward DCF asks what the business is worth given our assumptions. Reverse DCF asks what operating assumptions would justify the current market price.
- Current market price
- ₹3.54
- Normalized starting FCF
- ₹4.74 Cr
- WACC
- 11.00%
- Terminal growth
- 5.00%
- Net debt / (net cash)
- ₹38.40 Cr
- Shares outstanding
- 6.69 Cr
- Forecast period
- 5 years
At the current market price, the DCF model implies approximately -2.54% annual FCF growth over the forecast period, assuming the displayed discount rate, terminal growth, net debt and share count.
The market is pricing in a lower growth rate than Understock's Base DCF assumption.
Full-precision implied growth reprices the model to ₹3.5419; residual ₹0.001943 per share. Required tolerance: ₹0.005 before published rupee rounding. Displayed growth is rounded.
Implied-growth sensitivity
WACC rows and terminal-growth columns; unavailable cells have no valid solution within the model bounds. Swipe horizontally on smaller screens.
| WACC / terminal growth | 4.00% | 5.00% | 6.00% |
|---|---|---|---|
| 10.00% | -3.53% | Unavailable | Unavailable |
| 11.00% | 0.95% | -2.54% | Unavailable |
| 12.00% | 4.09% | 1.73% | -1.58% |
Reverse DCF is not a prediction. It derives the growth input needed to reconcile the model with the market price while holding the displayed Base inputs constant. The current production model's Bull/Bear offsets, growth clamps and 25%/50%/25% weighting remain active. The solver searches the existing −5% to 30% base-growth bounds; it never extrapolates beyond them.
The calculation relies on rounded stored inputs and the disclosed net-debt/cash source. It is unavailable if the current bridge does not reconcile with stored production outputs. A cash proxy is not verified cash and equivalents.
Input provenance and reconciliation
All stored scenario outputs and the weighted production DCF reconcile at their published rupee precision.
Stored assumptions are rounded. The original valuation run’s full-precision inputs and net debt were not retained. Current cached debt/cash totals; original run inputs not retained
Ratio record calculated_at (not a dedicated DCF timestamp): 2026-08-28T16:22:06.605. Financial cache: indianapi_backfill1500, fetched 2026-08-15T17:18:46.184+00:00. The cache table’s historical name does not identify the actual provider.
| Cached financial year | FCF (₹ crore) |
|---|---|
| FY2019 | 15.16 |
| FY2020 | -25.98 |
| FY2021 | -13.17 |
| FY2022 | -11.25 |
| FY2023 | -2.78 |
| FY2024 | 1.53 |
| FY2025 | Unavailable |
| FY2026 | Unavailable |
Normalized FCF is read directly from the stored production valuation, not replaced with latest-year FCF. Cached history provides context; it is not a retained record of the original run’s input selection.
Sign in to see this
Sign inValuations depend on inputs and assumptions. These calculations are estimates, not investment recommendations.