Interpretation of Valuation Outputs

You are working as an Investment Analyst and have been asked to interpret the valuation of Reliance Industries Limited (NSE: RELIANCE).

In the previous valuation labs, you used different methods to understand the value of a company.

You used :

• Trading Comparable Companies (Comps) to understand how similar publicly traded companies are valued.

• Precedent Transactions to understand the valuation multiples paid in past acquisitions.

• Discounted Cash Flow (DCF) to estimate the intrinsic value of Reliance Industries based on its expected future cash flows.

The previous Precedent Transactions lab calculated an average transaction multiple of 23.4x EV/EBITDA and compared it with a Trading Comps average of 29.9x EV/EBITDA.

The previous DCF lab calculated an implied Reliance share price of approximately ₹2,989.82, compared with a market price of ₹1,322.

In this lab, you will bring these valuation outputs together and learn how analysts interpret differences between valuation methods.

You will create a simple valuation comparison, calculate the DCF upside, compare Trading Comps with Precedent Transactions, and develop an overall investment interpretation.

The purpose of this activity is not to calculate every valuation method again.

Instead, the purpose is to answer an important analyst question:

What do the different valuation methods tell us about the company, and how should an investor interpret the results?

Topic : Valuation Techniques

1) Comparable company analysis

2) Precedent transaction analysis

3) Discounted cash flow (DCF)

4) Interpretation of valuation outputs

Interpretation of Valuation Outputs

In this activity, you will bring the outputs from the previous valuation models into one Excel worksheet.

Create the Excel Worksheet

Open Excel.

Create a new worksheet.

Rename the worksheet: Valuation_Interpretation

Create the following table:

1

Enter the Valuation Inputs

2

Enter the values into the appropriate cells.

Why are we doing this?

The purpose is to bring the outputs from different valuation methods into one place so that an analyst can compare them easily.

Compare Trading Comps and Precedent Transactions

3

Trading Comps: 29.9x EV/EBITDA

Precedent Transactions: 23.4x EV/EBITDA

The first question is:

Which valuation multiple is higher?

Trading Comps = 29.9x

Precedent Transactions = 23.4x

Therefore:

Trading Comps is higher.

Calculate the Multiple Difference

4

Now calculate how many turns of EV/EBITDA separate the two valuation benchmarks.

In Excel, enter:

=B3-B4

Assuming:

• B3 = Trading Comps

• B4 = Precedent Transactions

Result

6.5x

Why do we calculate this?

The multiple difference tells us the absolute gap between the current public-market benchmark and the historical transaction benchmark.

Interpretation

The Trading Comps average is 6.5x EV/EBITDA higher than the Precedent Transactions average.

This means the selected comparable companies are currently trading at a higher valuation multiple than the selected historical acquisition transactions

Calculate the Percentage Difference

5

A multiple difference of 6.5x tells us the absolute gap.

Now we want to understand the gap in percentage terms.

Use the formula:

Percentage Difference = (Precedent Transactions ÷ Trading Comps) − 1

In Excel, enter:

=(B4/B3)-1

Format the cell as a percentage.

Result

Approximately −21.7%

You can also describe this as:

Approximately −21.7%

You can also describe this as:

Precedent Transactions are approximately 21.7% lower than Trading Comps.

Why do we calculate this?

Percentage comparison makes it easier to understand the relative size of the difference.

Interpretation

The selected historical acquisition transactions were completed at a valuation multiple approximately 21.7% below the current Trading Comps benchmark.

Important Interpretation

Do not conclude that historical buyers necessarily got a bargain.

The difference can arise because of:

• Different market conditions.

• Different transaction dates.

• Different company sizes.

• Different growth expectations.

• Different growth expectations.

• Different profitability levels.

• Different transaction structures.

• Strategic benefits associated with acquisitions.

Compare DCF Value with Market Price

6

Now move to the DCF valuation.

Enter:

Current Market Price = ₹1,322

DCF Implied Share Price = ₹2,989.82

The question is:

Is the DCF value higher or lower than the current market price?

Answer:

DCF value is higher

Calculate DCF Upside

7

Use the following formula:

DCF Upside = (DCF Value − Current Market Price) ÷ Current Market Price

In Excel, enter:

=(B5-B2)/B2

Format the cell as a percentage.

Result

Approximately 126.16%

Why do we calculate DCF upside?

The upside calculation shows how much higher the DCF-estimated value is compared with the current market price.

It helps an analyst answer:

"How much potential value does the DCF model indicate relative to today's market price?"

Interpretation

The DCF model estimates an implied share price of approximately ₹2,989.82,

compared with the current market price of ₹1,322.

Based on the assumptions used in the DCF model, this represents approximately 126.16% implied upside.

Important

This is model-based implied upside, not a guaranteed future return.

The DCF result depends on assumptions such as:

• Future free cash flow growth.

• WACC.

• Terminal growth.

• Capital expenditure.

• Business performance.

If these assumptions change, the DCF value can also change.

Create the Task 1 Summary

8

Create the following table in Excel:

Task 1 Interpretation

Write 2–3 sentences below the table.

Your interpretation should explain:

• Trading Comps are higher than Precedent Transactions.

• The DCF value is significantly above the current market price.

• The DCF result depends on the assumptions used.

The Trading Comps multiple of 29.9x is higher than the Precedent Transactions multiple of 23.4x, indicating that the current comparable-company benchmark is higher than the historical transaction benchmark. The DCF implied value of ₹2,989.82 is significantly above the current market price of ₹1,322, suggesting potential undervaluation based on the DCF model. However, the DCF value depends on assumptions such as cash-flow growth, WACC, and terminal growth, so the result should be interpreted with caution.

In this activity, you move beyond the calculations and interpret the valuation results like an investment analyst.

The purpose is to understand what the different valuation methods are telling us and how these results can be used together to form an investment insight

Understand the Valuation Reference Range

Analysts generally avoid relying on one exact valuation number because different valuation methods are based on different assumptions.

For this exercise, the simple valuation reference range is based on:

Why are we using a range?

The current market price represents what investors are paying for the shares today, while the DCF value represents an estimated value based on expected future cash flows.

Since valuation models can produce different results, a range provides a more practical way of looking at the possible valuation rather than assuming that one number is the perfect or exact value.

Important Clarification

The ₹1,322 to ₹2,989.82 range is a simple interpretive reference range for this lab.

It is not a full mathematically calculated football-field valuation.

The Trading Comps and Precedent Transactions results are expressed as:

• Trading Comps = 29.9x EV/EBITDA

• Precedent Transactions = 23.4x EV/EBITDA

These multiples cannot be directly converted into Reliance's share price without additional company-specific information such as EBITDA, enterprise value adjustments, net debt and shares outstanding.

Therefore, the multiples should be interpreted as valuation benchmarks, rather than being converted into an assumed share price.

Understand What Each Valuation Method Tells Us

2

Trading Comps – 29.9x EV/EBITDA

Trading Comps compare Reliance with similar publicly traded companies.

The 29.9x EV/EBITDA multiple represents the current valuation benchmark observed for the selected comparable companies.

What does this tell us?

It indicates how the public market is currently valuing similar businesses relative to their EBITDA.

Precedent Transactions – 23.4x EV/EBITDA

Precedent Transactions are based on selected historical M&A transactions.

The 23.4x EV/EBITDA multiple represents the historical transaction benchmark.

What does this tell us?

It shows the valuation multiples observed when comparable businesses were acquired in previous transactions.

The difference between the two benchmarks is:

29.9x − 23.4x = 6.5x

The Trading Comps benchmark is therefore 6.5x higher than the Precedent Transactions benchmark.

The percentage difference is:

(23.4 ÷ 29.9) − 1 = −21.7%

This means that the selected historical transaction benchmark is approximately 21.7% lower than the current Trading Comps benchmark.

DCF – ₹2,989.82

The DCF method estimates the value of a company based on its expected future free cash flows.

The DCF model produces an implied share value of:

₹2,989.82

This is substantially higher than the current market price of ₹1,322.

The difference can be expressed as:

(₹2,989.82 − ₹1,322) ÷ ₹1,322 = 126.16%

Therefore, the DCF model indicates approximately 126.16% implied upside relative to the current market price.

Why is the DCF value higher?

A higher DCF value may indicate that the assumptions used in the model expect strong future cash generation and long-term value creation.

However, the DCF result depends heavily on assumptions such as:

• Future free cash flow growth

• WACC

• Terminal growth

• Capital expenditure

• Future profitability

• Business expansion

Therefore, the DCF value should be viewed as a model-based estimate, not a guaranteed future share price.

Understand the DCF–Market Price Difference

3

The two values are:

The DCF value is significantly higher than the current market price.

This creates a valuation divergence.

One possible explanation is that the DCF model assumes stronger future cash flows or growth than the expectations currently reflected in the market price.

However, the market may have different expectations regarding:

• Future growth

• Business profitability

• Risk

• Capital expenditure

• Cash-flow generation

• Execution of strategic projects

Therefore, a higher DCF value does not automatically mean that the market price will reach ₹2,989.82.

Consider Qualitative Business Factors

4

Valuation numbers should not be considered in isolation.

For Reliance, important business factors include:

Growth

Growth opportunities may come from areas such as:

• Jio expansion

• Reliance Retail

• New energy businesses

• Reliance Retail

• New energy businesses

Strong growth can support future revenue, profitability and cash flows.

Capital Requirements

Expansion may require significant investment.

Important considerations include:

• Future capital expenditure

• Investment required for new businesses

• Cash required to support expansion

High investment requirements can affect future free cash flow

Business Risks

The valuation can also be affected by:

• Commodity price movements

• Oil-to-Chemicals performance

• Changes in profitability

• Execution risks associated with strategic projects

Cash Flow

The DCF valuation ultimately depends on the company's ability to generate sustainable future cash flows.

Therefore, an analyst should consider whether expected growth can actually translate into:

Revenue → Profitability → Free Cash Flow

Combine the Quantitative and Qualitative Insights

5

Understand the valuation results provide different perspectives:

The key insight is that different valuation methods can produce different views of value.

Trading Comps provide a market-based comparison, Precedent Transactions provide a historical M&A comparison, while DCF provides a forward-looking cash-flow-based estimate

Final Investment Insight

6

A balanced investment conclusion should combine the quantitative valuation results with the qualitative business factors.

Suggested Analyst Conclusion

The Trading Comps average of 29.9x EV/EBITDA is higher than the Precedent Transactions average of 23.4x EV/EBITDA, with a difference of 6.5x. This indicates that the current public-market valuation benchmark is higher than the selected historical transaction benchmark. The DCF model produces an implied share price of ₹2,989.82, compared with the current market price of ₹1,322, representing approximately 126.16% implied upside based on the DCF assumptions. However, the DCF valuation is sensitive to assumptions relating to future free cash flow, WACC, terminal growth, capital expenditure and business performance. Therefore, the valuation results should be considered together with Reliance's growth opportunities, capital requirements, commodity-price exposure, cash-flow generation and execution risks before reaching an investment conclusion.

₹2,989.82, compared with the current market price of ₹1,322, representing approximately 126.16% implied upside based on the DCF assumptions. However, the DCF valuation is sensitive to assumptions relating to future free cash flow, WACC, terminal growth, capital expenditure and business performance. Therefore, the valuation results should be considered together with Reliance's growth opportunities, capital requirements, commodity-price exposure, cash-flow generation and execution risks before reaching an investment conclusion.

Key Learning

The main lesson from this activity is that valuation is not about finding one perfect number.

A good investment analyst compares different valuation methods, understands why the results differ, evaluates the assumptions behind each method, and combines financial analysis with business and strategic factors before forming an investment view.