Fundamental Analysis of Ingersoll-Rand (India) Ltd

About the Company - Ingersoll-Rand (India) Ltd

Ingersoll-Rand (India) Ltd. is a Public Limited Listed company incorporated on 01/12/1921 and has its registered office in the State of Karnataka, India. Company’s Corporate Identification Number(CIN) is L05190KA1921PLC036321 and registration number is 036321. Currently company belongs to the Industry of Compressors. Company’s Total Operating Revenue is Rs. 909.92 Cr. and Equity Capital is Rs. 31.57 Cr. for the Year ended 31/03/2022.

INDUSTRY	ADDRESS	CONTACT
Compressors	First Floor, Subramanya Arcade, Bengaluru Karnataka 560029	p_r_shubhakar@irco.com http://www.irco.com

Management
Name	Position Held
Mr. Sekhar Natarajan	Chairman
Mr. Inder Arora	Executive Director
Ms. Jayantika Dave	Director
Mr. Naveen Samant	Director
Ms. Vijaya Sampath	Director

Basic Stock Data of Ingersoll-Rand (India) Ltd

Last Updated: July 26, 2024, 10:33 pm

Market Cap	13,348 Cr.
Current Price	4,238
High / Low	5,000/2,760
Stock P/E	60.0
Book Value	184
Dividend Yield	1.65 %
ROCE	51.4 %
ROE	38.4 %
Face Value	10.0
PEG Ratio	2.77

Data Source: screener.in

Ingersoll-Rand (India) Ltd Quarterly Results

Month	Sep 2020	Dec 2020	Mar 2021	Jun 2021	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023
Sales	148	190	187	194	249	245	222	273	254	319	304	305	276
Expenses	123	157	148	158	213	206	182	229	208	254	214	233	211
Operating Profit	25	34	40	36	36	39	40	44	46	65	90	71	66
OPM %	17%	18%	21%	19%	14%	16%	18%	16%	18%	21%	30%	23%	24%
Other Income	3	3	3	3	3	3	4	4	7	5	4	6	6
Interest	0	0	1	0	0	0	1	1	1	1	0	0	1
Depreciation	4	4	3	3	3	4	4	4	4	4	4	4	5
Profit before tax	24	33	39	35	35	39	39	43	48	65	90	72	67
Tax %	25%	40%	33%	25%	26%	26%	25%	26%	26%	26%	26%	26%	26%
Net Profit	18	20	26	26	26	29	29	32	35	48	67	54	50
EPS in Rs	5.80	6.31	8.24	8.33	8.25	9.06	9.26	10.17	11.23	15.19	21.26	17.02	15.75

Last Updated: July 10, 2024, 6:22 pm

Ingersoll-Rand (India) Ltd Quarterly Chart

Ingersoll-Rand (India) Ltd Profit & Loss

Last Updated: July 10, 2024, 6:22 pm

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	TTM
Sales	592	586	525	656	621	620	615	739	706	618	910	1,151	1,214
Expenses	532	530	479	632	577	564	544	634	607	507	758	905	912
Operating Profit	60	55	46	23	44	56	71	106	99	111	152	246	302
OPM %	10%	9%	9%	4%	7%	9%	12%	14%	14%	18%	17%	21%	25%
Other Income	69	62	62	90	47	71	74	34	36	13	13	19	21
Interest	0	1	1	2	0	1	0	0	3	2	3	2	2
Depreciation	5	5	8	12	10	12	13	11	18	14	14	16	18
Profit before tax	123	111	98	100	81	114	132	127	114	108	148	246	304
Tax %	33%	30%	32%	34%	25%	32%	32%	36%	26%	33%	26%	26%
Net Profit	83	78	67	66	61	77	89	81	85	72	110	183	226
EPS in Rs	26.22	24.69	21.21	20.95	19.27	24.48	28.16	25.64	26.80	22.92	34.89	57.86	71.48
Dividend Payout %	92%	24%	28%	29%	31%	25%	739%	23%	104%	13%	57%	86%

Ingersoll-Rand (India) Ltd Profit & Loss Yearly Chart

Ingersoll-Rand (India) Ltd Growth

Compounded Sales Growth
10 Years:	9%
5 Years:	10%
3 Years:	25%
TTM:	5%

Compounded Profit Growth
10 Years:	13%
5 Years:	22%
3 Years:	45%
TTM:	22%

Stock Price CAGR
10 Years:	22%
5 Years:	49%
3 Years:	62%
1 Year:	49%

Return on Equity
10 Years:	14%
5 Years:	27%
3 Years:	31%
Last Year:	38%

Last Updated: July 25, 2024, 5:22 am

Ingersoll-Rand (India) Ltd Balance Sheet

Last Updated: July 10, 2024, 6:22 pm

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Sep 2023
Equity Capital	32	32	32	32	32	32	32	32	32	32	32	32	32
Reserves	782	838	883	926	976	1,030	1,097	387	350	419	520	546	587
Borrowings	0	0	0	0	0	0	0	0	8	10	8	5	3
Other Liabilities	131	150	179	174	153	151	160	181	163	212	276	276	254
Total Liabilities	945	1,020	1,093	1,131	1,161	1,212	1,289	599	552	672	836	859	876
Fixed Assets	44	50	109	109	78	126	121	117	117	112	111	110	140
CWIP	1	52	8	46	35	2	1	2	1	4	6	4	4
Investments	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Assets	900	918	977	976	1,048	1,084	1,167	480	434	556	719	745	731
Total Assets	945	1,020	1,093	1,131	1,161	1,212	1,289	599	552	672	836	859	876

Ingersoll-Rand (India) Ltd Reserves and Borrowings Chart

Ingersoll-Rand (India) Ltd Cash Flow

Month	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023	Mar 2024
Cash from Operating Activity	50	-64	29	67	121	77	37	109	76	81	148	207
Cash from Investing Activity	-43	31	-4	113	141	93	100	59	-1	-5	-5	-34
Cash from Financing Activity	-23	-23	-24	-23	-23	-23	-791	-125	-4	-13	-162	-225
Net Cash Flow	-15	-56	1	156	239	148	-655	43	71	63	-19	-53

Ingersoll-Rand (India) Ltd Financial Efficiency Indicators

Month	Mar 2012	Mar 2013	Mar 2014	Mar 2015	Mar 2016	Mar 2017	Mar 2018	Mar 2019	Mar 2020	Mar 2021	Mar 2022	Mar 2023
Debtor Days	82	87	121	99	80	58	65	83	74	108	88	85
Inventory Days	100	91	131	94	87	85	82	78	73	95	105	87
Days Payable	66	103	132	106	96	91	109	111	105	143	131	104
Cash Conversion Cycle	116	76	120	87	71	51	38	50	41	60	62	68
Working Capital Days	184	78	149	114	148	50	37	75	45	56	51	55
ROCE %	15%	14%	11%	9%	9%	11%	12%	17%	28%	26%	30%	44%

Ingersoll-Rand (India) Ltd Financial Efficiency Indicators Chart

Ingersoll-Rand (India) Ltd Share Holding Pattern

Month	Sep 2021	Dec 2021	Mar 2022	Jun 2022	Sep 2022	Dec 2022	Mar 2023	Jun 2023	Sep 2023	Dec 2023	Mar 2024	Jun 2024
Promoters	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%	75.00%
FIIs	0.21%	0.43%	0.40%	0.45%	0.57%	0.91%	1.06%	1.24%	1.31%	1.44%	1.59%	1.62%
DIIs	4.29%	4.99%	5.50%	5.72%	5.93%	5.92%	5.80%	5.42%	5.38%	5.18%	5.36%	5.54%
Public	20.50%	19.58%	19.10%	18.83%	18.50%	18.19%	18.14%	18.34%	18.31%	18.39%	18.03%	17.83%
No. of Shareholders	28,661	27,969	32,745	31,033	33,752	33,627	33,856	35,527	35,988	35,684	34,700	34,935

Ingersoll-Rand (India) Ltd Shareholding Pattern Chart

No. of Ingersoll-Rand (India) Ltd Shareholders

Ingersoll-Rand (India) Ltd Mutual Fund Holdings

Fund Name	No of Shares	AUM (%)	Amount Invested (Cr)	Previous Number of Shares	Previous Date	Percentage Change
SBI Large & Midcap Fund	908,982	1.63	255.24	14,500	2024-07-25	6168.84%
SBI Contra Fund	229,555	0.39	64.46	14,500	2024-07-25	1483.14%
Invesco India Smallcap Fund	92,747	0.91	26.04	14,500	2024-07-25	539.63%
ITI Small Cap Fund	74,652	1.27	20.96	14,500	2024-07-25	414.84%
ICICI Prudential Infrastructure Fund	53,889	0.45	15.13	14,500	2024-07-25	271.65%
Tata Infrastructure Fund - Regular Plan	53,000	1.13	14.88	14,500	2024-07-25	265.52%
Mahindra Manulife Multi Cap Fund	46,677	0.59	13.11	14,500	2024-07-25	221.91%
Mahindra Manulife Flexi Cap Fund	25,200	0.69	7.08	14,500	2024-07-25	73.79%
Invesco India Flexi Cap Fund	18,761	0.47	5.27	14,500	2024-07-25	29.39%
Bank of India Flexi Cap Fund	14,500	0.95	4.07	14,500	2024-07-25	0%

Ingersoll-Rand (India) Ltd ROCE Trend

Ingersoll-Rand (India) Ltd EPS Trend

Ingersoll-Rand (India) Ltd Key Financial Ratios

Month	Mar 24	Mar 23	Mar 22	Mar 21	Mar 20
FaceValue	10.00	10.00	10.00	10.00	10.00
Basic EPS (Rs.)	70.45	57.86	34.89	22.92	26.80
Diluted EPS (Rs.)	70.45	57.86	34.89	22.92	26.80
Cash EPS (Rs.)	76.06	63.03	39.36	27.44	32.58
Book Value[Excl.RevalReserv]/Share (Rs.)	183.80	183.11	174.82	142.76	120.73
Book Value[Incl.RevalReserv]/Share (Rs.)	183.80	183.11	174.82	142.76	120.73
Dividend / Share (Rs.)	70.00	50.00	20.00	3.00	28.00
Revenue From Operations / Share (Rs.)	384.44	364.54	288.24	195.68	223.52
PBDIT / Share (Rs.)	100.68	83.96	52.27	39.20	42.73
PBIT / Share (Rs.)	95.06	78.78	47.80	34.68	36.95
PBT / Share (Rs.)	94.41	78.02	46.99	34.14	36.13
Net Profit / Share (Rs.)	70.44	57.85	34.89	22.92	26.80
PBDIT Margin (%)	26.18	23.03	18.13	20.03	19.11
PBIT Margin (%)	24.72	21.61	16.58	17.72	16.53
PBT Margin (%)	24.55	21.40	16.30	17.44	16.16
Net Profit Margin (%)	18.32	15.87	12.10	11.71	11.98
Return on Networth / Equity (%)	38.32	31.59	19.95	16.05	22.19
Return on Capital Employeed (%)	50.66	42.66	26.98	23.53	29.86
Return On Assets (%)	26.09	21.25	12.83	10.76	15.32
Long Term Debt / Equity (X)	0.00	0.00	0.00	0.01	0.01
Total Debt / Equity (X)	0.00	0.00	0.01	0.02	0.02
Asset Turnover Ratio (%)	1.42	1.34	1.19	1.01	1.23
Current Ratio (X)	2.57	2.61	2.40	2.56	2.50
Quick Ratio (X)	1.89	2.03	1.86	2.10	2.02
Inventory Turnover Ratio (X)	3.99	4.13	4.50	4.06	4.55
Dividend Payout Ratio (NP) (%)	0.00	86.42	8.59	0.00	104.47
Dividend Payout Ratio (CP) (%)	0.00	79.32	7.62	0.00	85.93
Earning Retention Ratio (%)	0.00	13.58	91.41	0.00	-4.47
Cash Earning Retention Ratio (%)	0.00	20.68	92.38	0.00	14.07
Interest Coverage Ratio (X)	153.55	110.12	64.63	73.14	51.88
Interest Coverage Ratio (Post Tax) (X)	108.43	76.88	44.14	43.77	33.54
Enterprise Value (Cr.)	11335.33	7969.39	4753.02	1935.23	1796.73
EV / Net Operating Revenue (X)	9.34	6.93	5.22	3.13	2.55
EV / EBITDA (X)	35.66	30.07	28.80	15.64	13.32
MarketCap / Net Operating Revenue (X)	9.52	7.16	5.54	3.49	2.76
Retention Ratios (%)	0.00	13.57	91.40	0.00	-4.47
Price / BV (X)	19.92	14.26	9.14	4.79	5.11
Price / Net Operating Revenue (X)	9.52	7.16	5.54	3.49	2.76
EarningsYield	0.01	0.02	0.02	0.03	0.04

Ingersoll-Rand (India) Ltd Profitability Ratios (%)

Ingersoll-Rand (India) Ltd Liquidity Ratios

Ingersoll-Rand (India) Ltd Liquidity Ratios (%)

Ingersoll-Rand (India) Ltd Interest Coverage Ratios (%)

Ingersoll-Rand (India) Ltd Valuation Ratios

Fair Value

Fair Value: 4,309.31

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators.

Undervalued: 1.68% compared to the current price 4238

Intrinsic Value: 5,243.46

Calculation basis:

Fair value = P/E Ratio * (Return on Equity / 100) * Book Value * (1 + Dividend Yield / 100) * (1 + EPS CAGR for Last 5 Years)
P/E Ratio (Price-to-Earnings Ratio): Represents the price of the stock relative to its earnings per share. A higher P/E ratio indicates that investors are willing to pay a higher price for the stock.
Return on Equity (ROE): Measures a company's profitability relative to its shareholder equity. It showcases the company's ability to generate profits using the investment made by its shareholders, offering valuable insight into its operational efficiency and financial performance.
Book Value: Represents the net asset value of the company per share. It is calculated as the total assets minus intangible assets and liabilities, divided by the number of outstanding shares.
Dividend Yield: The ratio of the annual dividend per share to the current market price per share. It offers valuable insights into the profitability of an investment through dividends.
EPS CAGR (Compound Annual Growth Rate): Represents the geometric mean growth rate of earnings per share over the last 5 years. It provides insight into the historical growth trajectory of the company's earnings.

This formula allows us to gauge the fair value of the stock by analyzing its fundamental indicators along with EPS growth.

Undervalued: 23.72% compared to the current price 4238

Last 5 Year EPS CAGR: 21.68%

*Investments are subject to market risks

Strength and Weakness of Ingersoll-Rand (India) Ltd Stock

Strength	Weakness
The stock has a high average ROCE of 18.83%, which is a positive sign. The company has higher reserves (710.08 cr) compared to borrowings (3.08 cr), indicating strong financial stability. The company has shown consistent growth in sales (553.08 cr) and profit (138.92 cr) over the years.	The stock has a high average Working Capital Days of 86.83, which may not be favorable. The stock has a high average Cash Conversion Cycle of 70.00, which may not be favorable.

FAQ

What is the latest fair value of Ingersoll-Rand (India) Ltd?

The latest fair value of Ingersoll-Rand (India) Ltd is ₹4309.31.

What is the Market Cap of Ingersoll-Rand (India) Ltd?

The Market Cap of Ingersoll-Rand (India) Ltd is 13,348 Cr..

What is the current Stock Price of Ingersoll-Rand (India) Ltd as on 27 July 2024?

The current stock price of Ingersoll-Rand (India) Ltd as on 27 July 2024 is 4,238.

What is the High / Low of Ingersoll-Rand (India) Ltd stocks in FY 2024?

In FY 2024, the High / Low of Ingersoll-Rand (India) Ltd stocks is 5,000/2,760.

What is the Stock P/E of Ingersoll-Rand (India) Ltd?

The Stock P/E of Ingersoll-Rand (India) Ltd is 60.0.

What is the Book Value of Ingersoll-Rand (India) Ltd?

The Book Value of Ingersoll-Rand (India) Ltd is 184.

What is the Dividend Yield of Ingersoll-Rand (India) Ltd?

The Dividend Yield of Ingersoll-Rand (India) Ltd is 1.65 %.

What is the ROCE of Ingersoll-Rand (India) Ltd?

The ROCE of Ingersoll-Rand (India) Ltd is 51.4 %.

What is the ROE of Ingersoll-Rand (India) Ltd?

The ROE of Ingersoll-Rand (India) Ltd is 38.4 %.

What is the Face Value of Ingersoll-Rand (India) Ltd?

The Face Value of Ingersoll-Rand (India) Ltd is 10.0.

Fundamental Analysis of Ingersoll-Rand (India) Ltd

About the Company - Ingersoll-Rand (India) Ltd

Basic Stock Data of Ingersoll-Rand (India) Ltd

Ingersoll-Rand (India) Ltd Quarterly Results

Ingersoll-Rand (India) Ltd Quarterly Chart

Ingersoll-Rand (India) Ltd Profit & Loss

Ingersoll-Rand (India) Ltd Profit & Loss Yearly Chart

Ingersoll-Rand (India) Ltd Growth

Ingersoll-Rand (India) Ltd Balance Sheet

Ingersoll-Rand (India) Ltd Reserves and Borrowings Chart

Ingersoll-Rand (India) Ltd Cash Flow

Ingersoll-Rand (India) Ltd Financial Efficiency Indicators

Ingersoll-Rand (India) Ltd Financial Efficiency Indicators Chart

Ingersoll-Rand (India) Ltd Share Holding Pattern

Ingersoll-Rand (India) Ltd Shareholding Pattern Chart

No. of Ingersoll-Rand (India) Ltd Shareholders

Ingersoll-Rand (India) Ltd Mutual Fund Holdings

Ingersoll-Rand (India) Ltd ROCE Trend

Ingersoll-Rand (India) Ltd EPS Trend

Ingersoll-Rand (India) Ltd Key Financial Ratios

Ingersoll-Rand (India) Ltd Profitability Ratios (%)

Ingersoll-Rand (India) Ltd Liquidity Ratios

Ingersoll-Rand (India) Ltd Liquidity Ratios (%)

Ingersoll-Rand (India) Ltd Interest Coverage Ratios (%)

Ingersoll-Rand (India) Ltd Valuation Ratios

Fair Value

Strength and Weakness of Ingersoll-Rand (India) Ltd Stock

FAQ

What is the latest fair value of Ingersoll-Rand (India) Ltd?

What is the Market Cap of Ingersoll-Rand (India) Ltd?

What is the current Stock Price of Ingersoll-Rand (India) Ltd as on 27 July 2024?

What is the High / Low of Ingersoll-Rand (India) Ltd stocks in FY 2024?

What is the Stock P/E of Ingersoll-Rand (India) Ltd?

What is the Book Value of Ingersoll-Rand (India) Ltd?

What is the Dividend Yield of Ingersoll-Rand (India) Ltd?

What is the ROCE of Ingersoll-Rand (India) Ltd?

What is the ROE of Ingersoll-Rand (India) Ltd?

What is the Face Value of Ingersoll-Rand (India) Ltd?

About the Author

Getaka