Summary

ZEE ENTERTAINMENT ENTERPRISES LTD

Total number of shares (cr) 96.05
Current price ₹112.79
Market Cap (cr) ₹10,834

Page 1
 Graham Check list

Input Data
Fixed Assets
Current Assets
Fixed Liabilities
Current Liabilities

1. Size of the company

2. Strong financial stability

3. Earnings Stability

4. Dividend record

5. Earnings Growth

Financial Ratios
PE ratio should be at least less than 14
PB ratio should be less than 2
Debt to Equity ratio should be less than 1
RoE should be atleast 15%
RoA should be atleast 15%

Page 2
 Graham Check list

Input Data Result

15 Yes 64%
153 No 36%
0
15

Sales at least more than 200 crores.

YES
Latest Annual Sales 8,294
1. Current assets must be at least twice current liabilities

2. Long term or Fixed liabilities must be less than net current assets (Current assets – current
liabilities)
Criteria 1 YES
Criteria 2 YES

Should have positive earnings for past 10 years at least YES

Should have paid dividend for last 10 years uninterrupted YES

Average earnings should have increased by at least 100% in 10 years

Current Earnings 3.01
Earnings before 10 years 15.70 NO
Check Value -80.80%

Financial Ratios
ss than 14 20.57 No
2 70.89 No
e less than 1 0.03 Yes
344.64% Yes
3.83% No

Page 3
 EPV method

Avg. Profit 5 years 527

Other income % -30%
EPV at 7% returns 7374
+ Invesments 1,194.70
+ Cash equivalents 1,250
Total 9818
Borrowings 321
Other Liabilities 1,880
IV1 (- all liabilities) IV2 (- Debt alone) 0
79 99
MoS -42% -14%

Page 4
 EPV method

Net Profit 2021 2022 2023 2024 2025

800.10 964.60 47.80 141.40 679.50
Other income 2021 2022 2023 2024 2025
-28.90 -111.20 -459.40 -206.50 17.30

Page 5
 Buffett Method

Profit Growth CAGR 5.23%

Debt 320.90
Avg. Capex 5 years -103.2
Avg. D&A 5 years 277

Net Profit Adjusted Value

2026 715 767
2027 752 746
2028 792 725
2029 833 706
2030 877 687
Terminal value 12,277 8,541
Total 12,172
IV3 127
MoS 11%

Page 6
 Buffett Method

Net Profit 2020 2021 2022 2023 2024 2025

526.50 800.10 964.60 47.80 141.40 679.50
Capex 2020 2021 2022 2023 2024 2025
-88 -224 -77 -91 -50 -74
Depreciation 2020 2021 2022 2023 2024 2025
270.60 264.90 221.30 312.70 309.10 278.50

Page 7
ZEE ENTERTAINMENT ENTERPRISES LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25 Trailing Best Case Worst Case
Sales 5,812.50 6,434.20 6,685.70 7,933.90 8,129.90 7,729.90 8,185.70 8,087.90 8,637.20 8,294.10 7,988.40 8,330.55 7,999.67
Expenses 4,385.50 4,711.20 4,604.90 5,369.80 6,870.40 6,123.40 6,408.90 6,981.10 7,726.20 7,082.00 6,807.90 7,099.49 6,966.94
Operating Profit 1,427.00 1,723.00 2,080.80 2,564.10 1,259.50 1,606.50 1,776.80 1,106.80 911.00 1,212.10 1,180.50 1,231.06 1,032.73
Other Income 183.30 1,430.30 564.80 235.50 112.30 -28.90 -111.20 -459.40 -206.50 17.30 59.50 - -
Depreciation 77.70 115.20 182.10 234.70 270.60 264.90 221.30 312.70 309.10 278.50 262.00 262.00 262.00
Interest 159.80 137.20 144.80 130.40 144.90 57.10 43.80 70.20 72.10 32.70 34.90 34.90 34.90
Profit before tax 1,372.80 2,900.90 2,318.70 2,434.50 956.30 1,255.60 1,400.50 264.50 323.30 918.20 943.10 934.16 735.83
Tax 549.10 680.80 840.90 867.30 431.70 462.50 444.70 216.70 181.90 238.70 238.00 25% 25%
Net profit 823.20 2,221.30 1,479.10 1,567.10 526.50 800.10 964.60 47.80 141.40 679.50 705.10 698.42 550.14
EPS 8.57 23.13 15.40 16.32 5.48 8.33 10.04 0.50 1.47 7.07 7.34 7.27 5.73
Price to earning 45.14 23.16 37.37 27.31 22.61 24.39 28.71 426.50 94.11 13.90 15.36 137.47 15.36
Price 386.95 535.55 575.50 445.50 123.95 203.20 288.35 212.25 138.55 98.34 112.79 999.57 88.00

RATIOS:
Dividend Payout 26.24% 10.80% 18.82% 21.44% 5.47% 30.03% 29.89% 0.00% 67.96% 34.37%
OPM 24.55% 26.78% 31.12% 32.32% 15.49% 20.78% 21.71% 13.68% 10.55% 14.61% 14.78%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT BEST WORST

Sales Growth 4.03% 3.13% 0.40% 0.44% -3.69% 0.44% -3.69%
OPM 20.63% 18.31% 16.16% 12.91% 14.78% 14.78% 12.91%
Price to Earning 68.96 81.61 100.50 137.47 15.36 137.47 15.36
ZEE ENTERTAINMENT ENTERPRISES LTD SCREENER.IN

Narration Mar-23 Jun-23 Sep-23 Dec-23 Mar-24 Jun-24 Sep-24 Dec-24 Mar-25 Jun-25
Sales 2,112.11 1,983.80 2,437.80 2,045.70 2,169.90 2,130.50 2,000.70 1,978.80 2,184.10 1,824.80
Expenses 1,960.38 1,825.02 2,105.10 1,836.70 1,959.70 1,860.00 1,677.50 1,658.10 1,886.40 1,585.90
Operating Profit 151.73 158.78 332.70 209.00 210.20 270.50 323.20 320.70 297.70 238.90
Other Income -198.78 -113.37 -54.80 -27.30 -10.90 -17.10 44.60 -46.30 36.10 25.10
Depreciation 83.34 78.52 77.20 76.10 77.20 75.60 73.20 65.80 63.90 59.10
Interest 39.64 23.43 23.40 18.30 6.90 5.50 8.30 10.80 8.10 7.70
Profit before tax -170.03 -56.54 177.30 87.30 115.20 172.30 286.30 197.80 261.80 197.20
Tax 26.00 -3.12 54.30 28.80 101.80 54.20 76.90 34.20 73.40 53.50
Net profit -196.03 -53.42 123.00 58.50 13.40 118.10 209.40 163.60 188.40 143.70

OPM 7% 8% 14% 10% 10% 13% 16% 16% 14% 13%

ZEE ENTERTAINMENT ENTERPRISES LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Equity Share Capital 96.00 96.00 96.00 96.00 96.00 96.10 96.10 96.10 96.10 96.10
Reserves 4,707.90 6,594.40 7,465.70 8,827.90 9,247.90 9,998.50 10,766.70 10,625.80 10,776.70 11,437.30
Borrowings 1,715.90 2,203.10 1,526.20 1,114.50 649.60 423.10 76.30 282.00 230.30 320.90
Other Liabilities 1,446.10 1,364.00 2,041.80 2,894.60 2,424.10 2,301.00 2,300.50 2,724.40 2,346.60 1,879.80
Total 7,965.90 10,257.50 11,129.70 12,933.00 12,417.60 12,818.70 13,239.60 13,728.30 13,449.70 13,734.10

Net Block 1,332.60 915.60 1,476.10 1,414.50 1,314.80 1,191.20 1,225.10 1,359.70 1,203.90 1,004.60
Capital Work in Progress 110.40 155.70 91.90 156.10 83.10 75.40 87.20 19.10 9.80 1.40
Investments 1,147.80 1,343.10 1,528.90 976.50 324.80 798.30 65.10 34.90 39.10 1,194.70
Other Assets 5,375.10 7,843.10 8,032.80 10,385.90 10,694.90 10,753.80 11,862.20 12,314.60 12,196.90 11,533.40
Total 7,965.90 10,257.50 11,129.70 12,933.00 12,417.60 12,818.70 13,239.60 13,728.30 13,449.70 13,734.10

Working Capital 3,929.00 6,479.10 5,991.00 7,491.30 8,270.80 8,452.80 9,561.70 9,590.20 9,850.30 9,653.60
Debtors 1,348.20 1,241.80 1,536.50 1,827.40 2,128.60 1,945.20 1,737.50 1,608.80 1,701.60 1,532.50
Inventory 1,318.00 1,696.20 2,627.80 3,850.50 5,347.50 5,403.00 6,386.20 7,307.90 6,912.90 6,774.80

Debtor Days 84.66 70.44 83.88 84.07 95.57 91.85 77.48 72.60 71.91 67.44
Inventory Turnover 4.41 3.79 2.54 2.06 1.52 1.43 1.28 1.11 1.25 1.22

Return on Equity 17% 33% 20% 18% 6% 8% 9% 0% 1% 6%

Return on Capital Emp 39% 27% 27% 11% 13% 13% 3% 4% 8%
ZEE ENTERTAINMENT ENTERPRISES LTD SCREENER.IN

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Mar-22 Mar-23 Mar-24 Mar-25
Cash from Operating Activity 730.90 740.60 554.40 135.20 249.90 1,547.70 279.90 129.00 714.40 1,186.00
Cash from Investing Activity 16.20 1,325.20 -1,041.30 864.40 397.30 -511.30 585.60 -201.50 -45.60 -1,603.50
Cash from Financing Activity -404.60 -413.80 -1,090.20 -966.40 -1,062.00 -540.80 -715.30 -408.30 -273.60 22.80
Net Cash Flow 342.50 1,652.00 -1,577.10 33.20 -414.80 495.60 150.20 -480.80 395.20 -394.70
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: [email protected]
 s… do ANYTHING.

@dalal-street.in
COMPANY NAME ZEE ENTERTAINMENT ENTERPRISES LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 96.05
Face Value 1.00
Current Price 112.79
Market Capitalization 10,833.70

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 5,812.50 6,434.20 6,685.70 7,933.90
Raw Material Cost
Change in Inventory 130.20 378.20 -1,824.90 -2,276.60
Power and Fuel 15.90 15.80 18.10 18.50
Other Mfr. Exp 2,746.80 3,178.10 733.80 840.50
Employee Cost 498.60 606.10 667.90 727.20
Selling and admin 1,140.00 999.70 1,278.10 1,364.20
Other Expenses 114.40 289.70 82.10 142.80
Other Income 183.30 1,430.30 564.80 235.50
Depreciation 77.70 115.20 182.10 234.70
Interest 159.80 137.20 144.80 130.40
Profit before tax 1,372.80 2,900.90 2,318.70 2,434.50
Tax 549.10 680.80 840.90 867.30
Net profit 823.20 2,221.30 1,479.10 1,567.10
Dividend Amount 216.00 240.00 278.40 336.00

Quarters
Report Date Mar-23 Jun-23 Sep-23 Dec-23
Sales 2,112.11 1,983.80 2,437.80 2,045.70
Expenses 1,960.38 1,825.02 2,105.10 1,836.70
Other Income -198.78 -113.37 -54.80 -27.30
Depreciation 83.34 78.52 77.20 76.10
Interest 39.64 23.43 23.40 18.30
Profit before tax -170.03 -56.54 177.30 87.30
Tax 26.00 -3.12 54.30 28.80
Net profit -196.03 -53.42 123.00 58.50
Operating Profit 151.73 158.78 332.70 209.00

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 96.00 96.00 96.00 96.00
Reserves 4,707.90 6,594.40 7,465.70 8,827.90
Borrowings 1,715.90 2,203.10 1,526.20 1,114.50
Other Liabilities 1,446.10 1,364.00 2,041.80 2,894.60
Total 7,965.90 10,257.50 11,129.70 12,933.00
Net Block 1,332.60 915.60 1,476.10 1,414.50
Capital Work in Progress 110.40 155.70 91.90 156.10
Investments 1,147.80 1,343.10 1,528.90 976.50
Other Assets 5,375.10 7,843.10 8,032.80 10,385.90
Total 7,965.90 10,257.50 11,129.70 12,933.00
Receivables 1,348.20 1,241.80 1,536.50 1,827.40
Inventory 1,318.00 1,696.20 2,627.80 3,850.50
Cash & Bank 963.10 2,613.30 1,611.70 1,221.80
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 Activity 730.90 740.60 554.40 135.20
Cash from Investing Activity 16.20 1,325.20 -1,041.30 864.40
Cash from Financing Activity -404.60 -413.80 -1,090.20 -966.40
Net Cash Flow 342.50 1,652.00 -1,577.10 33.20

PRICE: 386.95 535.55 575.50 445.50

DERIVED:
Adjusted Equity Shares in Cr 96.04 96.04 96.05 96.05
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

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

8,129.90 7,729.90 8,185.70 8,087.90 8,637.20 8,294.10

-3,126.10 -3,063.90 -2,827.20 -3,042.10 -3,805.40

19.10 15.80 15.10 19.10 18.50
755.20 730.90 1,210.00 1,498.70 1,314.10
784.20 822.60 868.30 827.80 1,023.80 926.60
1,225.80 1,131.90 1,392.30 1,510.30 1,494.20 1,146.60
960.00 358.30 96.00 83.10 70.20 5,008.80
112.30 -28.90 -111.20 -459.40 -206.50 17.30
270.60 264.90 221.30 312.70 309.10 278.50
144.90 57.10 43.80 70.20 72.10 32.70
956.30 1,255.60 1,400.50 264.50 323.30 918.20
431.70 462.50 444.70 216.70 181.90 238.70
526.50 800.10 964.60 47.80 141.40 679.50
28.80 240.25 288.30 96.10 233.52

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

2,169.90 2,130.50 2,000.70 1,978.80 2,184.10 1,824.80
1,959.70 1,860.00 1,677.50 1,658.10 1,886.40 1,585.90
-10.90 -17.10 44.60 -46.30 36.10 25.10
77.20 75.60 73.20 65.80 63.90 59.10
6.90 5.50 8.30 10.80 8.10 7.70
115.20 172.30 286.30 197.80 261.80 197.20
 101.80 54.20 76.90 34.20 73.40 53.50
13.40 118.10 209.40 163.60 188.40 143.70
210.20 270.50 323.20 320.70 297.70 238.90

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

96.00 96.10 96.10 96.10 96.10 96.10
9,247.90 9,998.50 10,766.70 10,625.80 10,776.70 11,437.30
649.60 423.10 76.30 282.00 230.30 320.90
2,424.10 2,301.00 2,300.50 2,724.40 2,346.60 1,879.80
12,417.60 12,818.70 13,239.60 13,728.30 13,449.70 13,734.10
1,314.80 1,191.20 1,225.10 1,359.70 1,203.90 1,004.60
83.10 75.40 87.20 19.10 9.80 1.40
324.80 798.30 65.10 34.90 39.10 1,194.70
10,694.90 10,753.80 11,862.20 12,314.60 12,196.90 11,533.40
12,417.60 12,818.70 13,239.60 13,728.30 13,449.70 13,734.10
2,128.60 1,945.20 1,737.50 1,608.80 1,701.60 1,532.50
5,347.50 5,403.00 6,386.20 7,307.90 6,912.90 6,774.80
734.50 1,090.70 1,273.30 804.00 1,193.20 1,250.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

249.90 1,547.70 279.90 129.00 714.40 1,186.00
397.30 -511.30 585.60 -201.50 -45.60 -1,603.50
-1,062.00 -540.80 -715.30 -408.30 -273.60 22.80
-414.80 495.60 150.20 -480.80 395.20 -394.70

123.95 203.20 288.35 212.25 138.55 98.34

96.05 96.05 96.05 96.05 96.05 96.05