DCF Studio

    ETERNAL.NS · NSI · Consumer Cyclical

    Eternal Limited

    Also onConsensus Drift

    Implied value per share

    INR -32.23

    Market price

    INR 326.85

    Implied upside

    -109.9%

    5-year forecast · Perpetuity growth terminal value · Mid-year discounting · Base case

    AdjustedFree cashflow is negative in at least one forecast year, so terminal value carries most of the valuation.
    NoteRisk-free rate is an assumption: INR assumption - no free live source available for this market.

    Current EV/EBITDA of 193.5x sits outside a defensible 3-20x band, so the exit multiple is capped at 20.0x. A multiple that far out usually means EBITDA is the wrong denominator for this business.

    Value Per Share

    Perpetuity growth
    INR -32.23-109.9%
    Exit multiple
    INR -145.03-144.4%
    Market price
    INR 326.85

    Same forecast, different terminal treatment. Percentages vs price.

    Forecast Cashflows

    Reporting currency (INR). Outflows negative.

    -179525512011-897627560060FY27FY28FY29FY30FY31
    Nominal FCFFDiscounted to todayINR
    LineFY27FY28FY29FY30FY31CAGR
    RevenueINR 815.5bnINR 1223.2bnINR 1834.8bnINR 2752.2bnINR 4128.3bn+50.0%
    EBITINR -52.5bnINR -78.8bnINR -118.2bnINR -177.2bnINR -265.8bn-50.0%
    NOPATINR -39.3bnINR -58.9bnINR -88.4bnINR -132.6bnINR -198.9bn-50.0%
    Add depreciation & amortisationINR 36.2bnINR 54.3bnINR 81.4bnINR 122.2bnINR 183.2bn+50.0%
    Less capital expenditureINR -22.6bnINR -33.9bnINR -50.8bnINR -76.3bnINR -114.4bn+50.0%
    Less increase in working capitalINR -9.8bnINR -14.7bnINR -22.0bnINR -33.0bnINR -49.5bn+50.0%
    Free cashflow to firmINR -35.5bnINR -53.2bnINR -79.8bnINR -119.7bnINR -179.5bn-50.0%
    Discount factor0.95060.85900.77620.70140.6338-
    Present valueINR -33.7bnINR -45.7bnINR -61.9bnINR -83.9bnINR -113.8bn-35.5%
    Present Value Of The ForecastINR -339.1bn

    Discount Rate

    Source shown per component. All overridable above.

    Risk-free rate6.80%INR assumption - no free live source available for this market (assumption)
    Equity risk premium8.00%Market assumption
    Beta0.487Reported 0.234, pulled toward 1.0 (Blume)
    Cost of equity10.69%Risk-free + beta x equity risk premium
    Cost of debt11.69%Interest expense / average total debt
    Market capitalisationINR 3008.8bn98.5% of capital
    Total debtINR 45.9bn1.5% of capital, book value as a proxy
    Tax rate25.2%Effective, capped at statutory
    WACC10.66%E/V x Re + D/V x Rd x (1 - t)

    Terminal Value

    Perpetuity growth is intrinsic. The exit multiple defaults to the company's current EV/EBITDA, so it answers a different question - what the shares are worth if today's rating holds and EBITDA grows as forecast.

    Perpetuity growth at 2.50%

    Value per shareINR -32.23

    0% of EV

    Terminal value, undiscounted
    INR 0.00
    Terminal value, discounted
    INR 0.00
    Enterprise value
    INR -339.1bn
    Less net debt
    INR -39.9bn
    Equity value
    INR -299.1bn

    Exit at 20.0x EBITDA

    Value per shareINR -145.03

    76% of EV

    Terminal value, undiscounted
    INR -1652.1bn
    Terminal value, discounted
    INR -1047.1bn
    Enterprise value
    INR -1386.1bn
    Less net debt
    INR -39.9bn
    Equity value
    INR -1346.2bn

    Sensitivity

    Value per share (INR) by discount rate and long-run growth.

    Long-run growth
    Discount rate1.50%2.00%2.50%3.00%3.50%
    8.66%-34.35-34.35-34.35-34.35-34.35
    9.66%-33.27-33.27-33.27-33.27-33.27
    10.66%-32.23-32.23-32.23-32.23-32.23
    11.66%-31.23-31.23-31.23-31.23-31.23
    12.66%-30.27-30.27-30.27-30.27-30.27

    Outlined: this model. Green text: above today's price of 326.85. Shading: distance from this model's own value.

    Priced In

    What each input would have to be to justify the current price, one at a time.

    InputModelImpliedGap
    EBIT margin-6.4%10.5%+17.0pp
    Download as Excel

    Live formulas, not pasted numbers - edit a driver and the workbook reprices.

    Yahoo Finance and RBA data. General information, not advice. Methodology.