Summary

HATHWAY CABLE & DATACOM LTD

Total number of shares (cr) 177.01
Current price ₹14.43
Market Cap (cr) ₹2,554

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 55%
153 No 45%
0
15

Sales at least more than 200 crores.

YES
Latest Annual Sales 2,040
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 NO

Should have paid dividend for last 10 years uninterrupted YES

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

Current Earnings 0.48
Earnings before 10 years -1.00 NO
Check Value -148.53%

Financial Ratios
ss than 14 19.96 No
2 16.71 No
e less than 1 0.00 Yes
83.74% Yes
2.50% No

Page 3
 EPV method

Avg. Profit 5 years 128

Other income % 114%
EPV at 7% returns 1792
+ Invesments 2,751.50
+ Cash equivalents 208
Total 4751
Borrowings 13
Other Liabilities 727
IV1 (- all liabilities) IV2 (- Debt alone) 0
23 27
MoS 36% 46%

Page 4
 EPV method

Net Profit 2021 2022 2023 2024 2025

252.73 129.99 65.29 99.31 92.51
Other income 2021 2022 2023 2024 2025
195.53 121.35 128.35 164.60 121.63

Page 5
 Buffett Method

Profit Growth CAGR -2.26%

Debt 12.60
Avg. Capex 5 years -103.2
Avg. D&A 5 years 357

Net Profit Adjusted Value

2026 90 318
2027 88 294
2028 86 272
2029 84 251
2030 83 232
Terminal value 1,155 804
Total 2,171
IV3 12
MoS -18%

Page 6
 Buffett Method

Net Profit 2020 2021 2022 2023 2024 2025

103.73 252.73 129.99 65.29 99.31 92.51
Capex 2020 2021 2022 2023 2024 2025
-88 -224 -77 -91 -50 -74
Depreciation 2020 2021 2022 2023 2024 2025
371.10 371.18 367.67 357.07 354.18 336.01

Page 7
HATHWAY CABLE & DATACOM 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 1,136.87 1,344.40 1,534.62 1,558.29 1,798.39 1,731.77 1,793.02 1,858.44 1,980.97 2,039.65 2,067.54 2,129.18 2,092.37
Expenses 1,011.77 1,142.85 1,197.37 1,239.43 1,351.67 1,239.12 1,390.11 1,538.06 1,648.07 1,698.89 1,719.84 1,769.18 1,740.49
Operating Profit 125.10 201.55 337.25 318.86 446.72 492.65 402.91 320.38 332.90 340.76 347.70 360.00 351.87
Other Income -13.49 22.10 42.39 -368.37 262.67 195.53 121.35 128.35 164.60 121.63 133.54 - -
Depreciation 258.86 305.75 334.70 352.41 371.10 371.18 367.67 357.07 354.18 336.01 340.02 340.02 340.02
Interest 90.72 111.69 153.24 224.64 228.72 38.39 0.46 1.22 1.77 1.40 1.25 1.25 1.25
Profit before tax -237.97 -193.79 -108.30 -626.56 109.57 278.61 156.13 90.44 141.55 124.98 139.97 18.73 10.60
Tax -0.29 -0.34 -0.44 -438.89 4.10 25.36 25.78 25.07 42.26 32.44 34.72 25% 25%
Net profit -237.68 -193.01 -99.08 -187.57 103.73 252.73 129.99 65.29 99.31 92.51 105.18 14.09 7.97
EPS -2.86 -2.32 -1.19 -1.06 0.59 1.43 0.73 0.37 0.56 0.52 0.59 0.08 0.05
Price to earning -13.54 -16.22 -28.37 -27.32 22.95 18.00 23.49 35.11 34.94 24.87 24.28 29.80 24.28
Price 38.75 37.70 33.85 28.95 13.45 25.70 17.25 12.95 19.60 13.00 14.43 2.37 1.09

RATIOS:
Dividend Payout 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
OPM 11.00% 14.99% 21.98% 20.46% 24.84% 28.45% 22.47% 17.24% 16.80% 16.71% 16.82%

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

Sales Growth 6.71% 4.15% 2.55% 4.39% 2.96% 4.39% 2.55%
OPM 19.78% 20.81% 20.09% 16.91% 16.82% 16.91% 16.82%
Price to Earning 26.23 26.23 26.78 29.80 24.28 29.80 24.28
HATHWAY CABLE & DATACOM 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 459.59 499.23 483.79 504.58 493.37 502.61 512.74 511.15 513.15 530.50
Expenses 401.83 421.70 401.16 422.51 413.16 421.94 426.48 428.07 422.40 442.89
Operating Profit 57.76 77.53 82.63 82.07 80.21 80.67 86.26 83.08 90.75 87.61
Other Income 20.68 45.92 44.16 38.53 45.74 25.82 34.77 23.30 37.74 37.73
Depreciation 87.81 92.03 92.68 89.55 79.91 80.79 80.79 86.98 87.45 84.80
Interest 0.19 0.12 0.18 0.30 0.45 0.41 0.36 0.33 0.30 0.26
Profit before tax -9.56 31.30 33.93 30.75 45.59 25.29 39.88 19.07 40.74 40.28
Tax 5.05 8.94 13.90 8.40 11.02 6.97 14.10 5.43 5.94 9.25
Net profit -14.62 22.36 20.06 22.34 34.57 18.37 25.80 13.67 34.68 31.03

OPM 13% 16% 17% 16% 16% 16% 17% 16% 18% 17%
HATHWAY CABLE & DATACOM 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 166.10 166.10 166.10 354.02 354.02 354.02 354.02 354.02 354.02 354.02
Reserves 922.72 726.73 626.29 3,285.49 3,389.13 3,642.49 3,771.03 3,829.03 3,935.53 4,028.40
Borrowings 1,576.66 1,688.40 1,666.92 1,973.06 1,974.76 - - 5.07 19.66 12.60
Other Liabilities 687.67 831.05 810.05 811.27 653.54 522.57 494.79 642.79 654.20 726.75
Total 3,353.15 3,412.28 3,269.36 6,423.84 6,371.45 4,519.08 4,619.84 4,830.91 4,963.41 5,121.77

Net Block 1,556.78 1,755.46 1,811.97 1,631.97 1,571.14 1,601.62 1,592.13 1,631.70 1,539.96 1,414.54
Capital Work in Progress 277.86 120.98 55.68 103.60 81.11 81.72 56.96 47.81 27.58 19.93
Investments 718.13 718.78 643.90 3,636.10 703.18 1,795.02 1,905.28 2,013.37 2,528.24 2,751.50
Other Assets 800.38 817.06 757.81 1,052.17 4,016.02 1,040.72 1,065.47 1,138.03 867.63 935.80
Total 3,353.15 3,412.28 3,269.36 6,423.84 6,371.45 4,519.08 4,619.84 4,830.91 4,963.41 5,121.77

Working Capital 112.71 -13.99 -52.24 240.90 3,362.48 518.15 570.68 495.24 213.43 209.05
Debtors 285.86 345.11 390.44 120.77 29.33 5.52 52.42 145.12 180.73 253.52
Inventory 18.26 21.66 17.66 14.97 13.98 5.60 3.66 2.80 1.07 0.54

Debtor Days 91.78 93.70 92.86 28.29 5.95 1.16 10.67 28.50 33.30 45.37
Inventory Turnover 62.26 62.07 86.90 104.09 128.64 309.24 489.90 663.73 1,851.37 3,777.13

Return on Equity -22% -22% -13% -5% 3% 6% 3% 2% 2% 2%

Return on Capital Emp -3% 2% -10% 6% 7% 4% 2% 3% 3%
HATHWAY CABLE & DATACOM 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 83.36 324.61 292.90 246.24 439.91 467.30 332.77 453.35 -409.59 290.30
Cash from Investing Activity -521.04 -331.76 -152.81 -3,295.02 790.17 530.40 -382.29 -303.15 274.14 -263.50
Cash from Financing Activity 427.54 -3.53 -165.70 3,097.56 -243.77 -2,002.63 -0.06 - -1.38 -8.46
Net Cash Flow -10.14 -10.68 -25.61 48.78 986.31 -1,004.93 -49.58 150.20 -136.83 18.34
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: screener.feedback@dalal-street.in
 s… do ANYTHING.

@dalal-street.in
COMPANY NAME HATHWAY CABLE & DATACOM LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 177.01
Face Value 2.00
Current Price 14.43
Market Capitalization 2,554.26

PROFIT & LOSS

Report Date Mar-16 Mar-17 Mar-18 Mar-19
Sales 1,136.87 1,344.40 1,534.62 1,558.29
Raw Material Cost
Change in Inventory
Power and Fuel 20.72 24.07 27.88 28.74
Other Mfr. Exp 604.68 734.96 840.12 869.32
Employee Cost 86.45 93.46 77.28 83.24
Selling and admin 236.34 237.12 196.44 212.55
Other Expenses 63.58 53.24 55.65 45.58
Other Income -13.49 22.10 42.39 -368.37
Depreciation 258.86 305.75 334.70 352.41
Interest 90.72 111.69 153.24 224.64
Profit before tax -237.97 -193.79 -108.30 -626.56
Tax -0.29 -0.34 -0.44 -438.89
Net profit -237.68 -193.01 -99.08 -187.57
Dividend Amount

Quarters
Report Date Mar-23 Jun-23 Sep-23 Dec-23
Sales 459.59 499.23 483.79 504.58
Expenses 401.83 421.70 401.16 422.51
Other Income 20.68 45.92 44.16 38.53
Depreciation 87.81 92.03 92.68 89.55
Interest 0.19 0.12 0.18 0.30
Profit before tax -9.56 31.30 33.93 30.75
Tax 5.05 8.94 13.90 8.40
Net profit -14.62 22.36 20.06 22.34
Operating Profit 57.76 77.53 82.63 82.07

BALANCE SHEET
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Equity Share Capital 166.10 166.10 166.10 354.02
Reserves 922.72 726.73 626.29 3,285.49
Borrowings 1,576.66 1,688.40 1,666.92 1,973.06
Other Liabilities 687.67 831.05 810.05 811.27
Total 3,353.15 3,412.28 3,269.36 6,423.84
Net Block 1,556.78 1,755.46 1,811.97 1,631.97
Capital Work in Progress 277.86 120.98 55.68 103.60
Investments 718.13 718.78 643.90 3,636.10
Other Assets 800.38 817.06 757.81 1,052.17
Total 3,353.15 3,412.28 3,269.36 6,423.84
Receivables 285.86 345.11 390.44 120.77
Inventory 18.26 21.66 17.66 14.97
Cash & Bank 41.60 50.93 31.60 153.00
No. of Equity Shares ### ### ### ###
New Bonus Shares
Face value 2.00 2.00 2.00 2.00

CASH FLOW:
Report Date Mar-16 Mar-17 Mar-18 Mar-19
Cash from Operating Activity 83.36 324.61 292.90 246.24
Cash from Investing Activity -521.04 -331.76 -152.81 -3,295.02
Cash from Financing Activity 427.54 -3.53 -165.70 3,097.56
Net Cash Flow -10.14 -10.68 -25.61 48.78

PRICE: 38.75 37.70 33.85 28.95

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

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

1,798.39 1,731.77 1,793.02 1,858.44 1,980.97 2,039.65

29.99 27.61 30.10 33.67 34.09

875.10 857.30 961.87 1,101.46 1,240.39
95.10 98.28 102.81 104.09 93.69 87.73
250.81 239.87 287.37 289.40 273.90
100.67 16.06 7.96 9.44 6.00 1,611.16
262.67 195.53 121.35 128.35 164.60 121.63
371.10 371.18 367.67 357.07 354.18 336.01
228.72 38.39 0.46 1.22 1.77 1.40
109.57 278.61 156.13 90.44 141.55 124.98
4.10 25.36 25.78 25.07 42.26 32.44
103.73 252.73 129.99 65.29 99.31 92.51

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

493.37 502.61 512.74 511.15 513.15 530.50
413.16 421.94 426.48 428.07 422.40 442.89
45.74 25.82 34.77 23.30 37.74 37.73
79.91 80.79 80.79 86.98 87.45 84.80
0.45 0.41 0.36 0.33 0.30 0.26
45.59 25.29 39.88 19.07 40.74 40.28
 11.02 6.97 14.10 5.43 5.94 9.25
34.57 18.37 25.80 13.67 34.68 31.03
80.21 80.67 86.26 83.08 90.75 87.61

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

354.02 354.02 354.02 354.02 354.02 354.02
3,389.13 3,642.49 3,771.03 3,829.03 3,935.53 4,028.40
1,974.76 5.07 19.66 12.60
653.54 522.57 494.79 642.79 654.20 726.75
6,371.45 4,519.08 4,619.84 4,830.91 4,963.41 5,121.77
1,571.14 1,601.62 1,592.13 1,631.70 1,539.96 1,414.54
81.11 81.72 56.96 47.81 27.58 19.93
703.18 1,795.02 1,905.28 2,013.37 2,528.24 2,751.50
4,016.02 1,040.72 1,065.47 1,138.03 867.63 935.80
6,371.45 4,519.08 4,619.84 4,830.91 4,963.41 5,121.77
29.33 5.52 52.42 145.12 180.73 253.52
13.98 5.60 3.66 2.80 1.07 0.54
3,089.50 330.62 168.64 350.89 189.06 207.74
### ### ### ### ###

2.00 2.00 2.00 2.00 2.00 2.00

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

439.91 467.30 332.77 453.35 -409.59 290.30
790.17 530.40 -382.29 -303.15 274.14 -263.50
-243.77 -2,002.63 -0.06 -1.38 -8.46
986.31 -1,004.93 -49.58 150.20 -136.83 18.34

13.45 25.70 17.25 12.95 19.60 13.00

177.01 177.01 177.01 177.01 177.01 177.01