Stress Testing Reliance Industries in Excel: What Will Happen When Things Go Wrong?

Introduction

Every investor I have spoken to has at some point said this about Reliance Industries (RIL): “Bhai, it is Reliance. What can go wrong?” I used to think the same way.

Then I started doing proper fundamental analysis. I was not just looking at revenue and profit numbers, but actually stress testing the balance sheet.

That changed my perspective quite a bit.

Stress testing, in simple terms, is the act of putting a company’s finances through a simulated crisis.

You can ask: what happens to this business if revenues fall, input costs rise, and interest rates go up — all at the same time?

The answers can be very revealing, even for a company as large and well-diversified as Reliance.

For this analysis, I am using a structured tool (a Multibagger Stress Test Excel Sheet). I’ve built it specifically to run this kind of analysis on any listed company.

It has five sheets:

1. Sheet 1: Base data input,
2. Sheet 2: Stress scenario controls,
3. Sheet 3: Stressed financial output,
4. Sheet 4: Scenario comparison and a
5. Sheet 5: Final verdict dashboard.

I am going to show you each step on how this Excel sheet can be used to do the stress test. I’m using RIL’s consolidated financials from FY2021 to FY2025 to do this analysis.

Step 1 — Entering the Base Data (Sheet 1: Base Data)

The first thing I do when I open the stress test sheet is fill in the company’s real numbers. This is the basis of all the analysis that will follow – the foundation.

If the inputs are wrong, everything else that the sheet calculates will be wrong too. So, I suggest you always go directly to the company’s Annual Report to fetch the data.

Here is what the base data looks like for RIL for FY2025 (the latest full year):

1.1 Profit & Loss Account

Description (Rs. Cr.)	FY2021	FY2022	FY2023	FY2024	FY2025
Revenue from Operations (Net)	6,99,962	8,77,835	9,01,064	9,64,693	10,57,219
Cost of Materials + Stock	4,96,369	6,18,746	5,90,226	6,44,813	6,98,930
Employee + Other Operating Expenses	1,05,854	1,18,014	1,49,273	1,74,192	1,79,340
D&A	29,797	40,303	50,832	53,136	57,688
EBITDA (Operations)	68,446	1,41,075	1,60,765	1,45,548	1,78,949
EBIT (Operating)	38,649	1,00,772	1,09,933	92,412	1,21,261
Finance Costs (Interest)	14,584	19,571	23,118	24,269	27,061
PBT	83,862	94,022	1,04,340	1,06,017	1,23,162
Net Profit (PAT – Consolidated)	67,565	74,064	78,633	80,787	95,610

Note: I am using operating EBITDA and EBIT here, which exclude Other Income (Rs. 28,962 Cr in FY25). This gives a more conservative and accurate picture of the core business.

1.2 Balance Sheet Statement

Description (Rs. Cr.)	FY2021	FY2022	FY2023	FY2024	FY2025
Total Equity (Shareholders’ Funds)	7,79,485	7,15,871	7,93,481	8,43,200	9,04,030
Long-Term Borrowings	1,87,699	1,83,176	2,22,712	2,36,899	2,70,751
Short-Term Borrowings	78,606	1,30,790	1,01,910	1,10,631	1,03,670
Total Debt	2,66,305	3,13,966	3,24,622	3,47,530	3,74,421
Cash & Equivalents (Balance Sheet)	36,178	68,664	97,225	1,06,502	1,45,977
Net Debt	2,30,127	2,45,302	2,27,397	2,41,028	2,28,444
D/E Ratio	0.34x	0.44x	0.41x	0.41x	0.41x

1.3 Cash Flow Report

Description (Rs. Cr.)	FY2021	FY2022	FY2023	FY2024	FY2025
Operating Cash Flow (CFO)	26,185	1,10,654	1,15,032	1,58,788	1,78,703
Capital Expenditure (CapEx)	1,05,840	1,00,150	1,40,990	1,52,880	1,39,970
Free Cash Flow (FCF)	-79,655	10,504	-25,958	5,908	38,733

1.4 What the Above Base Data is Telling us?

The five-year data sitting in Sheet 1 is already telling a story in itself.

I want you to read it to understand how I’m interpreting the above numbers. This will help us to build a similar perspective about RIL.

• Revenue growth is solid. RIL grew its top line from Rs. 6.99 lakh crore in FY2021 to Rs. 10.57 lakh crore in FY2025. That is a compounded growth rate of roughly 10.9% per year. It is a respectable achievement for a company of this size. There is no doubt that RIL’s business is getting bigger.

• Profit growth is real but slower. PAT went from Rs. 67,565 Cr to Rs. 95,610 Cr over the same period. It is a CAGR of about 9%. That is slightly below revenue growth, which means margins of RIL have not expanded in a meaningful way.

And now I’ll do something that you will like for sure. I’m sure most investors/analysts kind of ignore this step.

I’ll compute the operating EBITDA margin by excluding Other Income. Let’s call it Operating EBITDA. I’m able to see this in Operating EBITDA:

Year	Op. EBITDA (Rs. Cr)	Op. EBITDA Margin
FY2021	68,446	9.8%
FY2022	1,41,075	16.1%
FY2023	1,60,765	17.8%
FY2024	1,45,548	15.1%
FY2025	1,78,949	16.9%

And the operating EBIT margin (after removing D&A from EBITDA):

Year	Op. EBIT (₹ Cr)	Op. EBIT Margin
FY2021	38,649	5.5%
FY2022	1,00,772	11.5%
FY2023	1,09,933	12.2%
FY2024	92,412	9.6%
FY2025	1,21,261	11.5%

RIL’s operating profit margins are in the range of 10–12%. That is not bad, but it is also not a set of numbers that I want to see as a long-term investor.

1. A company generating over Rs. 10 lakh crore in revenue.
2. But carrying a D&A burden of Rs. 57,688 Cr and a COGS base of nearly Rs. 7 lakh crore.
3. This is, from a stress-testing perspective, quite exposed to simultaneous revenue and cost shocks. Why?
4. Because when your costs are already eating up 66% of your revenue, even a small simultaneous hit (revenue falling and costs rising at the same time) leaves very little operating profit to absorb the shock.

• Free Cash Flow tells another story entirely. FCF was deeply negative in FY2021 (-Rs. 79,655 Cr) and FY2023 (-Rs. 25,958 Cr). It turned positive only in FY2022 (barely), FY2024 (Rs. 5,908 Cr), and FY2025 (Rs. 38,733 Cr). The company is a heavy CapEx spender. It has been investing aggressively in 5G (Jio), new energy, and retail. This is not necessarily bad, but it means the FCF cushion is thin relative to the absolute size of the business.

Now let me take these base numbers into Sheet 2, where the real stress testing begins.

Step 2 — Setting the Stress Scenario Controls (Sheet 2: Stress Controls)

This is the sheet where I define the shocks. The idea is to simulate a bad economic environment. How is it done? I create the following types of scenarios:

• Revenue is falling,
• Costs is rising,
• Interest rates are increasing, and
• The company has to keep spending on CapEx to stay relevant.

I will test RIL for these three scenarios: Mild, Moderate, and Severe by entering the shock data as per my understanding.

Here are the shock assumption data I’ve entered for this RIL analysis:

Shock Variable	Mild Stress	Moderate Stress	Severe Stress
Revenue Decline	-5%	-12%	-25%
COGS Increase	+3%	+8%	+15%
Operating Expense Increase	+3%	+8%	+15%
Interest Rate Increase	+1% pt	+2% pt	+3% pt
CapEx Increase	+10%	+25%	+50%
Tax Rate Increase	+2% pt	+5% pt	+8% pt

Let me explain the logic behind each of these shocks, because this is important.

• Revenue Decline:
  • A 5% fall is mild. It is like a demand slowdown in retail or a temporary dip in refining margins.
  • A 12% fall represents something more serious. It is like a global recession or an oil market disruption.
  • A 25% fall is a severe economic shock. It has happened before during COVID. During this time, RIL’s FY2021 revenue was significantly lower than FY2020.

• COGS Increase: RIL’s COGS is dominated by raw material costs. It is primarily crude oil and petrochemical feedstocks. These are highly sensitive to global commodity prices.
  • A 3% increase is mild.
  • An 8–15% spike is realistic in a commodity supercycle or a supply disruption scenario.

• Interest Rate Increase: India has seen its share of rate hike cycles.
  • A +1 to +3 percentage point increase in the cost of debt has a direct impact on interest expense. Given RIL’s total debt of Rs. 3.74 lakh crore, even a one percentage point rise in cost of borrowing means over Rs. 3,700 Cr of additional interest annually. Under such conditions, a company would consider refinancing its debt, but immediate impact must be born first.

• CapEx Increase: RIL is in the middle of building several big things simultaneously. Jio’s 5G network, new power plants, and retail stores across India needs Capex. These projects cannot be paused midway. So even if the economy turns bad, RIL still has to keep spending money on them. Hence, in our stress test, we assume that CapEx either stays the same or goes up by 10% to 50%.

Step 3 — Reading the Stressed Financial Output (Sheet 3: Stressed Output)

This is where the Excel sheet become very useful.

Once the shock inputs are set in Sheet 2, Sheet 3 auto-calculates every key financial line:

• Revenue,
• Gross profit,
• EBITDA,
• EBIT,
• PAT,
• FCF, and the
• Key ratios

These parameters are calculated for all three stress scenarios, alongside the base case. My Excel has been coded in that way that no manual formula entry needed in Sheet 3.

Here is what Sheet 3 will look like for Reliance Industries:

3.1 Stressed Revenue and Profitability

Metric	Base (FY25)	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Revenue (Rs. Cr)	10,57,219	10,04,358	9,30,353	7,92,914
COGS (Rs. Cr)	6,98,930	7,19,898	7,54,844	8,03,770
Gross Profit (Rs. Cr)	3,58,289	2,84,460	1,75,509	-10,856
Gross Margin	33.9%	28.3%	18.9%	Negative
Operating Expenses (Rs. Cr)	1,79,340	1,84,720	1,93,687	2,06,241
EBITDA (Rs. Cr)	1,78,949	99,740	-18,178	-2,17,097
EBITDA Margin	16.9%	9.9%	Negative	Deeply Negative
D&A (Rs. Cr)	57,688	57,688	57,688	57,688
EBIT (Rs. Cr)	1,21,261	42,052	-75,866	-2,74,785
Operating Margin	11.5%	4.2%	Negative	Deeply Negative

As you can see, in Sheet 3 the first major insight starts to emerges.

• Under Mild Stress (a 5% revenue decline combined with a 3% cost increase):
  • RIL’s operating EBITDA falls from Rs. 1,78,949 Cr to Rs. 99,740 Cr. That is a 44% drop in operating profit from just a 5% revenue fall.
• Under Moderate Stress, EBITDA turns negative.
• Under Severe Stress, EBITDA becomes deeply negative.

Why does this happen so sharply? Because of what is called operating leverage.

• RIL’s COGS base (Rs. 6.98 lakh crore) is 66% of revenue. When you apply a 3% cost increase to such a large base, that is over Rs. 20,000 Cr of additional cost.
• Simultaneously, a 5% revenue drop means Rs. 52,861 Cr less income.
• The combined swing is devastating to the profitability of RIL.

We must also remember that the D&A charge of Rs. 57,688 Cr is also completely fixed. It does not reduce even when revenue falls.

This is the burden of being a capital-intensive business.

Every rupee of depreciation costs the same regardless of what happens to the top line.

3.2 Stressed Interest, Tax, and Net Profit

Metric	Base (FY25)	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Stressed Interest (₹ Cr)	27,061	29,767	32,473	35,179
PBT (₹ Cr)	1,23,162	12,285	Deeply Negative	Deeply Negative
Effective Tax Rate	22.4%	24.4%	27.4%	30.4%
Net Profit PAT (₹ Cr)	95,610	9,288	Negative	Deeply Negative
Net Margin	9.0%	0.9%	Negative	Deeply Negative

• Under Mild Stress, RIL’s net profit does not just decline — it collapses. From Rs. 95,610 Cr to just Rs. 9,288 Cr. That is a 90% drop in PAT from what appears to be a conservative shock scenario. The company remains profitable, yes but barely the margin is almost close to zero (from 9% to 0.9%).

What happens here is a compounding effect:

• Revenue falls,
• Costs rise,
• Interest increases,
• Tax rate also goes up.

Each of these squeezes the PBT from different directions simultaneously. And because the absolute base is so large, even a small percentage move in the wrong direction creates an enormous rupee impact.

3.3 Stressed Free Cash Flow

Metric	Base (FY25)	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Estimated CFO (PAT + D&A)	1,78,703	66,976	Negative	Deeply Negative
Stressed CapEx (₹ Cr)	1,39,970	1,53,967	1,74,963	2,09,955
Free Cash Flow (₹ Cr)	38,733	-86,991	Deeply Negative	Deeply Negative
FCF Signal	Positive	Negative	Negative	Negative

• At base, RIL is generating positive FCF of Rs. 38,733 Cr.
• But under Mild Stress, FCF turns negative to the tune of Rs. 86,991 Cr. The reason for it is, the operating cash flows fall sharply (because PAT drops by 90%). This is the time when the CapEx actually rises (because the stress scenario assumes ongoing investment commitments).

This means under a mild economic stress, RIL would need to fund its operations through debt or by liquidating its cash reserves.

It is true that RIL has a substantial cash reserves of Rs. 1,45,977 Cr as of FY2025. It also has a Rs. 97,431 Cr in current investments. That liquidity buffer is the reason this company is not in danger even under stress.

But it does fundamentally change the investment picture.

3.4 Stressed Leverage Ratios

Metric	Base (FY25)	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Interest Coverage Ratio (EBIT/Interest)	5.55x	1.41x	Negative	Negative
ICR Signal (>2x?)	PASS	FAIL	FAIL	FAIL
Debt-to-Equity Ratio	0.41x	0.41x	0.41x	0.41x
D/E Signal (<1.0x?)	PASS	PASS	PASS	PASS

The D/E ratio stays at 0.41x across all scenarios because I am assuming no new debt is taken on. The existing debt structure is unchanged. And this is one of RIL’s genuine strengths. At 0.41x D/E, the company has significant room before it becomes over-leveraged by any standard.

But look at the Interest Coverage Ratio (ICR).

• Under Mild Stress, it drops from 5.55x to just 1.41x. An ICR of 1.41x means the company earns only Rs. 1.41 of operating profit for every Rs. 1 of interest it must pay. That is a very thin cushion.
• Any further deterioration from there would mean operating income is insufficient to service debt . This is a kind of situation that triggers rating agency to reconsider its credit ratings given to the company.

Step 4 — Side-by-Side Scenario Comparison (Sheet 4: Scenario Comparison)

Sheet 4 presents a clean comparison table that I find very useful when I want to communicate this analysis to someone quickly. Here is the summary:

Metric	Base Case	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Revenue (Rs. Cr)	10,57,219	10,04,358	9,30,353	7,92,914
EBITDA (Rs. Cr)	1,78,949	99,740	-18,178	-2,17,097
EBIT (Rs. Cr)	1,21,261	42,052	-75,866	-2,74,785
Operating Margin	11.5%	4.2%	Negative	Deeply Negative
Net Profit (Rs. Cr)	95,610	9,288	Negative	Deeply Negative
Free Cash Flow (Rs. Cr)	38,733	-86,991	Deeply Negative	Deeply Negative
Interest Coverage	5.55x	1.41x	Negative	Negative

% Change vs Base:

Metric	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
Revenue	-5.0%	-12.0%	-25.0%
EBITDA	-44.3%	-110.2%	-221.3%
Net Profit	-90.3%	N/A (loss)	N/A (loss)
FCF	-324.5% (swing negative)	—	—

The percentage change table makes the point very clearly.

• A 5% revenue decline produces a 44% drop in EBITDA and a 90% drop in net profit. This extreme amplification is the core lesson from this stress test.

Investors who look only at PAT often do not understand how fragile those profits can be under adverse conditions.

Step 5 — The Final Verdict (Sheet 5: Verdict Dashboard)

This is the sheet I always show first when presenting this analysis to someone. It takes all the stressed outputs and summarises them into five pass/fail tests, then assigns a final Fortress Rating.

The Five Tests — RIL Report Card

Test	Base Case	Scenario #1: Mild Stress	Scenario #2: Moderate Stress	Scenario #3: Severe Stress
FCF Positive?	PASS	FAIL	FAIL	FAIL
ICR > 2.0x?	PASS	FAIL	FAIL	FAIL
Operating Margin > 0%?	PASS	PASS	FAIL	FAIL
Net Profit Positive?	PASS	PASS	FAIL	FAIL
D/E Ratio < 1.0x?	PASS	PASS	PASS	PASS
Score (out of 5)	5/5	2/5	1/5	1/5
Fortress Rating	FORTRESS	WEAK	CRITICAL	CRITICAL

Conclusion

MODERATE — Structurally Sound, Operationally Fragile

RIL scores a perfect 5/5 at base. This is exactly what you would expect from India’s largest company. On paper, it looks like a fortress.

• Strong ICR,
• Positive FCF,
• Healthy D/E, and
• Robust profitability.

But under even a Mild Stress scenario, just a 5% revenue fall and a 3% cost increase, it drops to 2/5.

• The ICR falls below the safety threshold of 2.0x.
• FCF turns sharply negative.
• That is a dramatic deterioration from a scenario that is, frankly, not even that extreme.

A 5% fall in revenue is something that has happened to RIL before.

What This Analysis Teaches Us About RIL as an Investment

There are three things I want you to take away from this exercise.

First: Do not confuse revenue size with operational resilience.

• RIL is a Rs. 10.5 lakh crore revenue business. That sounds huge, right? But because a large portion of that revenue comes from retail which operaties on thin margins. The O2C or oil-to-chemicals (commodity-linked margins) are also super thin. The operating profit is a much smaller fraction of revenue than most people realise. When margins are thin and costs are high, small shocks produce large profit impacts.

Second: the balance sheet is genuinely strong, and that matters.

• RIL’s D/E of 0.41x is excellent. Its net debt of Rs. 2.28 lakh crore is comfortably covered by total equity of Rs. 9.04 lakh crore. And its cash position of Rs. 1.46 lakh crore, means the company can absorb a bad year or two without going to the capital markets with its hat in hand. This is not a company that will face a solvency crisis.

Third: FCF volatility is a risk that does not show up in the P&L.

• Over the last five years, RIL’s FCF has been negative in two out of five years. Even in positive years, it has been thin relative to the scale of the business. The company is investing heavily in Jio, in new energy, in retail. Those are long-duration bets. If those investments start delivering strong cash returns over the next few years, the FCF picture improves dramatically. But right now, the cash generation is not as robust as the profit numbers suggest.

My overall Fortress Rating for RIL, on the Multibagger Stress Test framework, is MODERATE.

It is not a weak company for sure.

But it is also not the rock-solid fortress that can encourage me to buy and hold it for the long term. Why? Because I can search and find better looking alternatives.

How to Use This Worksheet?

You can plug in any company’s numbers from the Annual Report and run the same five-step process.

The shock assumptions in Sheet 2 are fully adjustable. For example:

• If you are analysing an FMCG company, you might use lower revenue decline assumptions.
• If you are looking at a commodity stock or an airline, you might make the COGS shocks more severe.

The utility of this worksheet is not to predict the future. No tool can do that.

The point is to understand the range of outcomes. This is an important information to know, before we can actually invest our money.

That is what stress testing is about. And that is how I use it.

Disclaimer: This analysis is for educational purposes only and should not be taken as investment advice.