B.A.G Films and Media — DCF Valuation

Every assumption explained. Adjust the model to see how the answer changes.

Historical free cash flow

The real input to the DCF model. Free cash flow = operating cash flow minus capital expenditure. The most recent year is used as the starting point for the 5-year projection.

Year	Free Cash Flow	Operating CF
FY22	₹-12 Cr	₹-11 Cr
FY23	₹-7 Cr	₹-5 Cr
FY24	₹15 Cr	₹19 Cr
FY25	₹2 Cr	₹2 Cr
FY26	₹-15 Cr	₹-14 Cr

Assumptions used

Revenue growth (5 years)

10.3%

Based on the company's recent revenue trend, tapering toward the terminal rate. For cyclical companies, the average of 3-year and 5-year CAGRs is used to smooth cycle effects.

Discount rate (WACC)

12.0%

The required rate of return — what you could earn elsewhere at similar risk. A higher WACC reflects more business risk and significantly reduces today's value of future cash flows. Moving this by 1pp typically shifts the output 20–30%.

Terminal growth rate

5.0%

The growth rate assumed to continue forever after year 5 — typically near India's long-run GDP growth rate. Terminal value usually accounts for 60–80% of the total DCF value, so this single assumption matters enormously.

Projection horizon

5 years

Cash flows are explicitly projected for 5 years. A terminal value captures all growth beyond that point. The 5-year horizon limits exposure to compounding forecast error.

Adjust the model

Change any assumption to see how the intrinsic value shifts. This shows you why DCF results are always a range, not a single precise number.

Reverse DCF

What growth rate is the market already paying for?

Implied Growth vs. History

Priced for faster growth

Historical CAGR (7y)0.5%

Implied growth (what the market is pricing in)15.0%

0%30%

At the market's implied growth rate, revenue would reach ₹302 Cr in 5 years. At the historical growth rate, it would reach ₹154 Cr.

The market is pricing in 15.0% annual growth — faster than the historical 0.5% CAGR. The stock may be expensive unless growth accelerates.

DCF limitations

DCF is highly sensitive to assumptions. Moving the discount rate by 1pp typically changes the output by 20–30%. Moving terminal growth by 0.5pp can shift it 10–15%. Small errors in assumptions compound significantly over a 5-year horizon. Treat the output as a range, not a precise target — and use peer comparison as a sanity check.

New to DCF?

Read our plain-English guide to how DCF analysis works and what each assumption means.

Read DCF guide →

The intrinsic value shown is an algorithmic estimate based on publicly available financial data. It is not investment advice or a recommendation to buy, sell, or hold any security. Please consult a SEBI-registered investment adviser before making any investment decision.