HINDUSTAN UNILEVER LTD

X Particulars 2024 A 2025 A

Sales ₹61,896.00 ₹63,121.00
Revenue growth - 1.98%

COGS ₹33,651.00 ₹34,529.00

COGS % Sales 54.37% 54.70%
Gross Profit ₹28,245.00 ₹28,592.00
Gross margins 45.63% 45.30%

Operating expenses ₹13,586.00 ₹13,749.00

Operating Exp % Sales 21.95% 21.78%
EBITDA ₹14,659.00 ₹14,843.00
EBITDA Margins 23.68% 23.52%

Depreciation and Amortization ₹1,216.00 ₹1,355.00

Dep % Sales 1.96% 2.15%
EBIT ₹13,443.00 ₹13,488.00
EBIT Margins 21.72% 21.37%

Interest ₹334.00 ₹395.00

Interest % sales 0.54% 0.63%

Other Income ₹817.00 ₹1,322.00

Other income % sales 1.32% 2.09%
Earnings Before Tax ₹13,926.00 ₹14,415.00
EBT % Sales 22.50% 22.84%

Tax ₹3,644.00 ₹3,744.00

Effective Tax rate 26% 26%
Net Profit ₹10,282.00 ₹10,671.00
Net Profit Margin 16.61% 16.91%

No. of Equity shares 234.91 234.91

Earnings Per Share ₹43.77 ₹45.43

EPS Growth - 3.78%

Dividends per share ₹42.02 ₹53.02

Dividend Payout Ratio 96.04% 116.96%
X Particulars EBIT Interest Other Income PBT
X Change in EBIT
Base Case (100%) ₹13,488.00 ₹395.00 ₹1,322.00 ₹14,415.00
80% ₹10,790.40 ₹395.00 ₹1,322.00 ₹11,717.40
90% ₹12,139.20 ₹395.00 ₹1,322.00 ₹13,066.20
120% ₹16,185.60 ₹395.00 ₹1,322.00 ₹17,112.60

X Changes in Debt levels

Increase in Debt (20%) ₹13,488.00 ₹474.00 ₹1,322.00 ₹14,336.00
Decrease in Debt (20%) ₹13,488.00 ₹316.00 ₹1,322.00 ₹14,494.00

X Change in Interest rates

Interest rates decline by 14% ₹13,488.00 ₹230.72 ₹1,322.00 ₹14,579.28
Interest rates increase to 28% ₹13,488.00 ₹461.44 ₹1,322.00 ₹14,348.56
Interest rates decreases to 10% ₹13,488.00 ₹164.80 ₹1,322.00 ₹14,645.20

X Financial Leverage
Percentage change in EPS 25%
Percentage change in EBIT 20%
Degree of Financial Leverage 1.26
 Tax PAT No. of Shares OutstandingEarnings Per Share

₹3,744.00 ₹10,671.00 234.91 ₹45.43

₹3,744.00 ₹7,973.40 234.91 ₹33.94
₹3,744.00 ₹9,322.20 234.91 ₹39.68
₹3,744.00 ₹13,368.60 234.91 ₹56.91

₹3,744.00 ₹10,592.00 234.91 ₹45.09

₹3,744.00 ₹10,750.00 234.91 ₹45.76

₹3,744.00 ₹10,835.28 234.91 ₹46.13

₹3,744.00 ₹10,604.56 234.91 ₹45.14
₹3,744.00 ₹10,901.20 234.91 ₹46.41
 Interest rates remain constant for the second case

24%
Increase/decrease by 20% 24%
24%

Changes in Interest rates (constant calculation)

Debt 1648
Interest 395
Rate of interest 23.97%

Assumptions
Interest rates at 14% 230.72 14%
Interest rate at 28% 461.44 28%
Interest rate at 30% 164.80 10%
X Return on Investment
EBIT ₹13,488.00
Average Total Assets ₹79,176.00
Return on Investment 17.04%

X Dupont Analysis - Return on Equity

Return on Equity

Net Profit ₹10,671.00

Average Shareholder Equity ₹75,011.00
Return on Equity 14.23%

X ROE - Dupont Equation

Net Profit ₹10,671.00

Revenue ₹63,121.00
Net Profit Margin (A) 16.91%

Revenue ₹63,121.00
Average Total Assets ₹79,176.00
Asset Turnover Ratio (B) 79.72%

Average Total Assets ₹79,176.00

Average Shareholder Equity ₹75,011.00
Equity Multiplier (C) 1.06x

Return on Equity (A*B*C) 14.23%

COMPANY NAME HINDUSTAN UNILEVER LTD
LATEST VERSION 2.10 PLEASE DO NO
CURRENT VERSION 2.10

META
Number of shares 234.91
Face Value 1.00
Current Price 2,410.40
Market Capitalization 566,224.45

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 32,186.00 33,162.00 35,545.00 39,310.00
Raw Material Cost 13,184.00 13,606.00 14,233.00 15,845.00
Change in Inventory (83.00) (144.00) 72.00 (12.00)
Power and Fuel 309.00 295.00 295.00 308.00
Other Mfr. Exp 2,966.00 2,887.00 2,998.00 3,041.00
Employee Cost 1,680.00 1,743.00 1,860.00 1,875.00
Selling and admin 6,741.00 6,689.00 7,252.00 7,796.00
Other Expenses 1,313.00 1,470.00 1,480.00 1,553.00
Other Income 486.00 606.00 353.00 322.00
Depreciation 353.00 432.00 520.00 565.00
Interest 17.00 35.00 26.00 33.00
Profit before tax 6,026.00 6,467.00 7,306.00 8,604.00
Tax 1,875.00 1,977.00 2,079.00 2,544.00
Net profit 4,151.00 4,476.00 5,214.00 6,054.00
Dividend Amount 3,456.00 3,672.00 4,320.00 4,752.00

Quarters
Report Date Dec-22 Mar-23 Jun-23 Sep-23
Sales 15,597.00 15,215.00 15,496.00 15,623.00
Expenses 11,903.00 11,643.00 11,832.00 11,828.00
Other Income 7.00 240.00 146.00 178.00
Depreciation 293.00 291.00 286.00 297.00
Interest 29.00 29.00 50.00 88.00
Profit before tax 3,379.00 3,492.00 3,474.00 3,588.00
Tax 898.00 891.00 918.00 931.00
Net profit 2,474.00 2,600.00 2,554.00 2,656.00
Operating Profit 3,694.00 3,572.00 3,664.00 3,795.00

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 216.00 216.00 216.00 216.00
Reserves 6,357.00 6,528.00 7,065.00 7,651.00
Borrowings 177.00 277.00 99.00
Other Liabilities 8,043.00 8,685.00 10,581.00 10,663.00
Total 14,793.00 15,706.00 17,862.00 18,629.00
Net Block 3,258.00 4,419.00 4,528.00 4,715.00
Capital Work in Progress 408.00 229.00 461.00 406.00
Investments 2,592.00 3,794.00 2,873.00 2,716.00
Other Assets 8,535.00 7,264.00 10,000.00 10,792.00
Total 14,793.00 15,706.00 17,862.00 18,629.00
Receivables 1,264.00 1,085.00 1,310.00 1,816.00
Inventory 2,726.00 2,541.00 2,513.00 2,574.00
Cash & Bank 3,009.00 1,828.00 3,485.00 3,757.00
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 1.00 1.00 1.00 1.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activit 4,171.00 5,185.00 6,059.00 5,800.00
Cash from Investing Activity (282.00) (1,173.00) (1,063.00) (438.00)
Cash from Financing Activit (3,864.00) (4,214.00) (4,975.00) (5,390.00)
Net Cash Flow 25.00 (202.00) 21.00 (28.00)

PRICE: 869.50 911.75 1,333.35 1,706.80

DERIVED:
Adjusted Equity Shares in Cr 216.39 216.43 216.45 216.47
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

39,783.00 47,028.00 52,446.00 60,580.00 61,896.00 63,121.00
15,697.00 20,141.00 22,871.00 28,427.00 26,822.00 27,344.00
108.00 405.00 22.00 75.00 11.00 153.00
299.00 339.00 318.00 384.00 446.00 427.00
2,906.00 2,868.00 3,354.00 3,791.00 3,385.00 3,834.00
1,820.00 2,358.00 2,545.00 2,854.00 3,009.00 3,077.00
7,620.00 7,906.00 8,164.00 8,785.00 10,780.00 10,693.00
1,688.00 2,195.00 2,359.00 2,267.00 2,806.00 3,056.00
424.00 170.00 219.00 448.00 817.00 1,322.00
1,002.00 1,074.00 1,091.00 1,137.00 1,216.00 1,355.00
118.00 117.00 106.00 114.00 334.00 395.00
9,165.00 10,605.00 11,879.00 13,344.00 13,926.00 14,415.00
2,409.00 2,606.00 2,987.00 3,201.00 3,644.00 3,744.00
6,748.00 7,995.00 8,879.00 10,120.00 10,277.00 10,649.00
5,400.00 9,517.50 7,990.00 9,165.00 9,870.00 12,455.00

Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25

15,567.00 15,210.00 15,707.00 15,926.00 15,818.00 15,670.00
11,902.00 11,675.00 11,965.00 12,139.00 12,123.00 12,052.00
184.00 309.00 209.00 203.00 740.00 171.00
313.00 320.00 329.00 338.00 341.00 347.00
91.00 105.00 93.00 110.00 112.00 80.00
3,445.00 3,419.00 3,529.00 3,542.00 3,982.00 3,362.00
937.00 858.00 917.00 947.00 993.00 887.00
 2,509.00 2,558.00 2,610.00 2,591.00 2,984.00 2,464.00
3,665.00 3,535.00 3,742.00 3,787.00 3,695.00 3,618.00

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

216.00 235.00 235.00 235.00 235.00 235.00
8,013.00 47,439.00 48,826.00 50,069.00 50,983.00 49,167.00
1,043.00 1,219.00 1,484.00 1,648.00
11,924.00 21,066.00 20,402.00 21,554.00 25,787.00 28,813.00
20,153.00 68,740.00 70,506.00 73,077.00 78,489.00 79,863.00
5,479.00 51,443.00 51,473.00 52,678.00 53,744.00 54,335.00
597.00 745.00 1,313.00 1,132.00 1,025.00 1,009.00
1,255.00 2,709.00 3,521.00 2,882.00 4,625.00 3,810.00
12,822.00 13,843.00 14,199.00 16,385.00 19,095.00 20,709.00
20,153.00 68,740.00 70,506.00 73,077.00 78,489.00 79,863.00
1,149.00 1,758.00 2,236.00 3,079.00 2,997.00 3,819.00
2,767.00 3,579.00 4,096.00 4,251.00 4,022.00 4,415.00
5,113.00 4,471.00 3,846.00 4,678.00 7,559.00 7,554.00
### ### ### ### ### ###

1.00 1.00 1.00 1.00 1.00 1.00

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

7,623.00 9,163.00 9,048.00 9,991.00 15,469.00 11,886.00
1,791.00 (1,228.00) (1,728.00) (1,484.00) (5,324.00) 6,473.00
(6,819.00) (9,309.00) (8,015.00) (8,953.00) (10,034.00) (13,101.00)
2,595.00 (1,374.00) (695.00) (446.00) 111.00 5,258.00

2,298.50 2,431.50 2,048.65 2,560.35 2,264.35 2,258.85

216.48 234.96 234.96 234.96 234.96 234.96

HINDUSTAN UNILEVER LTD

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20

Sales 32,186.00 33,162.00 35,545.00 39,310.00 39,783.00
Expenses 26,276.00 26,834.00 28,046.00 30,430.00 29,922.00
Operating Profit 5,910.00 6,328.00 7,499.00 8,880.00 9,861.00
Other Income 486.00 606.00 353.00 322.00 424.00
Depreciation 353.00 432.00 520.00 565.00 1,002.00
Interest 17.00 35.00 26.00 33.00 118.00
Profit before tax 6,026.00 6,467.00 7,306.00 8,604.00 9,165.00
Tax 1,875.00 1,977.00 2,079.00 2,544.00 2,409.00
Net profit 4,151.00 4,476.00 5,214.00 6,054.00 6,748.00
EPS 19.18 20.68 24.09 27.97 31.17
Price to earning 45.33 44.09 55.35 61.03 73.74
Price 869.50 911.75 1,333.35 1,706.80 2,298.50

RATIOS:
Dividend Payout 83.26% 82.04% 82.85% 78.49% 80.02%
OPM 18.36% 19.08% 21.10% 22.59% 24.79%
 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing
47,028.00 52,446.00 60,580.00 61,896.00 63,121.00 63,121.00
35,402.00 39,589.00 46,433.00 47,237.00 48,278.00 48,279.00
11,626.00 12,857.00 14,147.00 14,659.00 14,843.00 14,842.00
170.00 219.00 448.00 817.00 1,322.00 1,323.00
1,074.00 1,091.00 1,137.00 1,216.00 1,355.00 1,355.00
117.00 106.00 114.00 334.00 395.00 395.00
10,605.00 11,879.00 13,344.00 13,926.00 14,415.00 14,415.00
2,606.00 2,987.00 3,201.00 3,644.00 3,744.00 3,744.00
7,995.00 8,879.00 10,120.00 10,277.00 10,649.00 10,649.00
34.03 37.79 43.07 43.74 45.32 45.33
71.46 54.21 59.44 51.77 49.84 53.17
2,431.50 2,048.65 2,560.35 2,264.35 2,258.85 2,410.40

119.04% 89.99% 90.56% 96.04% 116.96%

24.72% 24.51% 23.35% 23.68% 23.52% 23.51%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT

Sales Growth 7.77% 8.55% 9.67% 6.37% 1.98%
OPM 22.92% 23.86% 23.90% 23.52% 23.51%
Price to Earning 56.31 59.33 56.65 53.56 53.17
SCREENER.IN

Best Case Worst Case

### ###
51,351.45 49,613.96
### ###
- -
1,355.00 1,355.00
395.00 395.00
14,040.57 13,006.28
26% 26%
### 9,628.17
44.25 40.99
53.56 53.17
2,369.66 2,179.33

BEST WORST
6.37% 1.98%
23.52% 22.92%
53.56 53.17
HINDUSTAN UNILEVER LTD

Narration Dec-22 Mar-23 Jun-23 Sep-23 Dec-23

Sales 15,597.00 15,215.00 15,496.00 15,623.00 15,567.00
Expenses 11,903.00 11,643.00 11,832.00 11,828.00 11,902.00
Operating Profit 3,694.00 3,572.00 3,664.00 3,795.00 3,665.00
Other Income 7.00 240.00 146.00 178.00 184.00
Depreciation 293.00 291.00 286.00 297.00 313.00
Interest 29.00 29.00 50.00 88.00 91.00
Profit before tax 3,379.00 3,492.00 3,474.00 3,588.00 3,445.00
Tax 898.00 891.00 918.00 931.00 937.00
Net profit 2,474.00 2,600.00 2,554.00 2,656.00 2,509.00

OPM 24% 23% 24% 24% 24%

 SCREENER.IN

Mar-24 Jun-24 Sep-24 Dec-24 Mar-25

15,210.00 15,707.00 15,926.00 15,818.00 15,670.00
11,675.00 11,965.00 12,139.00 12,123.00 12,052.00
3,535.00 3,742.00 3,787.00 3,695.00 3,618.00
309.00 209.00 203.00 740.00 171.00
320.00 329.00 338.00 341.00 347.00
105.00 93.00 110.00 112.00 80.00
3,419.00 3,529.00 3,542.00 3,982.00 3,362.00
858.00 917.00 947.00 993.00 887.00
2,558.00 2,610.00 2,591.00 2,984.00 2,464.00

23% 24% 24% 23% 23%

HINDUSTAN UNILEVER LTD

Narration Mar-16 Mar-17 Mar-18 Mar-19

Equity Share Capital 216.00 216.00 216.00 216.00
Reserves 6,357.00 6,528.00 7,065.00 7,651.00
Borrowings 177.00 277.00 - 99.00
Other Liabilities 8,043.00 8,685.00 10,581.00 10,663.00
Total 14,793.00 15,706.00 17,862.00 18,629.00

Net Block 3,258.00 4,419.00 4,528.00 4,715.00

Capital Work in Progress 408.00 229.00 461.00 406.00
Investments 2,592.00 3,794.00 2,873.00 2,716.00
Other Assets 8,535.00 7,264.00 10,000.00 10,792.00
Total 14,793.00 15,706.00 17,862.00 18,629.00

Working Capital 492.00 (1,421.00) (581.00) 129.00

Debtors 1,264.00 1,085.00 1,310.00 1,816.00
Inventory 2,726.00 2,541.00 2,513.00 2,574.00

Debtor Days 14.33 11.94 13.45 16.86

Inventory Turnover 11.81 13.05 14.14 15.27

Return on Equity 63% 66% 72% 77%

Return on Capital Emp 94% 103% 113%
 SCREENER.IN

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24

216.00 235.00 235.00 235.00 235.00
8,013.00 47,439.00 48,826.00 50,069.00 50,983.00
- - 1,043.00 1,219.00 1,484.00
11,924.00 21,066.00 20,402.00 21,554.00 25,787.00
20,153.00 68,740.00 70,506.00 73,077.00 78,489.00

5,479.00 51,443.00 51,473.00 52,678.00 53,744.00

597.00 745.00 1,313.00 1,132.00 1,025.00
1,255.00 2,709.00 3,521.00 2,882.00 4,625.00
12,822.00 13,843.00 14,199.00 16,385.00 19,095.00
20,153.00 68,740.00 70,506.00 73,077.00 78,489.00

898.00 (7,223.00) (6,203.00) (5,169.00) (6,692.00)

1,149.00 1,758.00 2,236.00 3,079.00 2,997.00
2,767.00 3,579.00 4,096.00 4,251.00 4,022.00

10.54 13.64 15.56 18.55 17.67

14.38 13.14 12.80 14.25 15.39

82% 17% 18% 20% 20%

115% 38% 25% 26% 27%
Mar-25
235.00
49,167.00
1,648.00
28,813.00
79,863.00

54,335.00
1,009.00
3,810.00
20,709.00
79,863.00

(8,104.00)
3,819.00
4,415.00

22.08
14.30

22%
29%
HINDUSTAN UNILEVER LTD

Narration Mar-16 Mar-17 Mar-18 Mar-19

Cash from Operating Act 4,171.00 5,185.00 6,059.00 5,800.00
Cash from Investing Activity (282.00) (1,173.00) (1,063.00) (438.00)
Cash from Financing Activity (3,864.00) (4,214.00) (4,975.00) (5,390.00)
Net Cash Flow 25.00 (202.00) 21.00 (28.00)
 SCREENER.IN

Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25

7,623.00 9,163.00 9,048.00 9,991.00 15,469.00 11,886.00
1,791.00 (1,228.00) (1,728.00) (1,484.00) (5,324.00) 6,473.00
(6,819.00) (9,309.00) (8,015.00) (8,953.00) (10,034.00) (13,101.00)
2,595.00 (1,374.00) (695.00) (446.00) 111.00 5,258.00
How to use it?
You can customize this workbook as you want.
You can add custom formating, add conditional formating, add your own formulas… do ANYTHING.
Please don't edit the "Data Sheet" only.

After customization, you can upload this back on Screener.

Upload on: https://www.screener.in/excel/

Download your customized workbooks now onwards.

Now whenever you will "Export to excel" from Screener, it will export your customized file.

TESTING:
This is a testing feature currently.
You can report any formula errors on the worksheet at: support@screener.in
as… do ANYTHING.