TechnoFunda Investing Excel Analysis - Versio

STEPS TO USE THIS ANALYSIS EXCEL

1 >> This excel is customised to be used only on Screener.in website. You might need to create free account on t
to use it.
2>> Once you sign-up on Screener.in webite, go to this URL >> https://www.screener.in/excel/
3>> Upload this excel template there and it's DONE…!! Now in future all the time you will be able to use this tem
when you visit any company on the website.
4>> When you are on company tab on Screener.in website, simply click on "Export To Excel" option and you will
output in exact same template which you have uploaded. It works like MAGIC :)
Visit my website >> https://vivekmashrani.com/ to get lot of other insights on Investing. Cheers…!!

READ THESE INSTRUCTIONS BEFORE YOU START

1. DON’T change anything on "Data Sheet" tab - this is dynamic template based on which company data we ne
through Screener.in upload
2. If you see data is not flowing when you download excel from Screener.in, just click on "Enable Editing" on th
workbook

Data Sheet underlying data is from Screener.in

WATCH SCREENER TUTORIAL

DISCLAIMER
1. This excel template is prepared only for educational purpose. Author is not liable for accuracy of underlying da
Please use this only as reference. For any suggestions or feedback, email to >> connect@vivekmashrani.com
2. Please consult your financial advisor for buy/sell decisions; Author will bear no liability whatsoever based on d
direct or indirect use of this template.

Read full disclaimer and privacy policy here >> https://vivekmashrani.com/disclaimer-and-privacy-policy/

 GO TO OVERVIEW TAB

GET 10-DAY FREE EMAIL COURSE

INVESTING LEARNING UPDATES

VISIT MY WEBSITE
RSE

ES
TRIDENT LTD Final Data Sheet

Narration Mar-12 Mar-13 Mar-14 Mar-15

Equity Share Capital 305.84 310.84 311.09 508.64
Reserves 342.58 395.43 576.79 946.68
Borrowings 2,283.65 2,239.81 1,862.27 2,580.14
Other Liabilities 334.53 340.81 434.38 468.43
Total 3,266.60 3,286.89 3,184.53 4,503.89

Net Block 2,147.95 1,968.22 1,795.59 2,863.86

Capital Work in Progress 6.38 28.05 36.28 221.89
Investments 55.65 64.47 118.73 31.35
Other Assets 1,056.62 1,226.15 1,233.93 1,386.79
Total 3,266.60 3,286.89 3,184.53 4,503.89

Working Capital 722.09 885.34 799.55 918.36

Debtors 191.90 232.30 264.14 204.78
Inventory 520.40 690.99 642.85 746.54

Debtor Days 25.75 25.55 25.10 20.01

Inventory Turnover 5.23 4.80 5.98 5.00

Return on Equity -7% 7% 22% 8%

Return on Capital Emp 11% 17% 11%
 SCREENER.IN

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

509.37 509.58 509.60 509.60 509.60
1,906.24 2,214.92 2,183.89 2,421.69 2,457.30
3,502.66 2,849.41 2,797.81 2,435.75 1,990.75
588.04 576.45 637.77 736.20 760.70
6,506.31 6,150.36 6,129.07 6,103.24 5,718.35

4,693.00 4,344.06 3,901.53 3,716.06 3,680.81

61.53 123.16 176.58 131.76 145.23
52.38 74.84 83.88 159.93 79.07
1,699.40 1,608.30 1,967.08 2,095.49 1,813.24
6,506.31 6,150.36 6,129.07 6,103.24 5,718.35

1,111.36 1,031.85 1,329.31 1,359.29 1,052.54

258.08 381.68 477.76 662.00 278.48
898.50 768.25 906.53 1,000.96 911.98

25.70 30.17 38.19 46.29 21.63

4.08 6.01 5.04 5.21 5.15

10% 12% 10% 13% 12%

9% 10% 9% 12% 10%
Mar-21
509.60
2,806.95
1,561.87
875.74
5,754.16

3,789.86
64.29
3.90
1,896.11
5,754.16

1,020.37
454.51
1,008.28

36.71
4.48

10%
11%
TRIDENT LTD

Narration Sep-19 Dec-19 Mar-20 Jun-20 Sep-20

Sales 1,321.93 1,081.71 990.49 707.93 1,171.44
Expenses 1,066.63 937.70 845.29 594.65 947.64
Operating Profit 255.30 144.01 145.20 113.28 223.80
Other Income 3.69 9.69 6.77 5.43 3.15
Depreciation 84.89 82.24 81.54 82.41 83.10
Interest 27.07 23.44 27.77 23.10 12.30
Profit before tax 147.03 48.02 42.66 13.20 131.55
Tax 9.94 6.12 3.10 3.10 31.31
Net profit 137.09 41.90 39.56 10.10 100.24

OPM 19% 13% 15% 16% 19%

 SCREENER.IN

Dec-20 Mar-21 Jun-21 Sep-21 Dec-21

1,289.93 1,349.99 1,477.01 1,662.57 1,957.66
1,051.79 1,114.43 1,097.41 1,259.75 1,554.78
238.14 235.56 379.60 402.82 402.88
62.04 -27.80 2.85 10.10 -21.74
82.96 87.99 87.41 86.72 77.52
13.21 23.39 25.00 19.87 22.38
204.01 96.38 270.04 306.33 281.24
44.25 20.75 66.54 77.53 72.14
159.76 75.63 203.50 228.80 209.10

18% 17% 26% 24% 21%

TRIDENT LTD

Narration Mar-12 Mar-13 Mar-14 Mar-15 Mar-16

Sales 2,720.03 3,317.95 3,841.30 3,734.91 3,665.25
Expenses 2,419.95 2,762.58 3,109.37 3,073.82 2,935.13
Operating Profit 300.08 555.37 731.93 661.09 730.12
Other Income 20.16 22.44 11.96 34.00 33.34
Depreciation 207.53 261.44 268.41 321.32 336.62
Interest 171.78 235.28 210.33 205.96 145.23
Profit before tax -59.07 81.09 265.15 167.81 281.61
Tax -15.33 31.76 68.12 49.99 39.28
Net profit -43.74 49.33 197.03 117.82 242.33
EPS -0.14 0.16 0.63 0.23 0.48
Price to earning -7.55 4.85 2.32 9.89 10.78
Price 1.08 0.77 1.47 2.29 5.13

RATIOS:
Dividend Payout 0.00% 0.00% 4.74% 25.90% 18.92%
OPM 11.03% 16.74% 19.05% 17.70% 19.92%
 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 Trailing
4,617.38 4,565.96 5,219.52 4,699.46 4,519.29 6,447.23
3,731.59 3,713.74 4,242.18 3,858.05 3,705.29 5,026.37
885.79 852.22 977.34 841.41 814.00 1,420.86
106.13 61.81 45.75 23.90 39.61 -36.59
412.41 404.03 363.91 333.30 336.46 339.64
141.01 118.21 112.26 110.80 72.00 90.64
438.50 391.79 546.92 421.21 445.15 953.99
101.52 125.93 176.00 79.41 99.41 236.96
336.98 265.86 370.92 341.80 345.74 717.03
0.66 0.52 0.73 0.67 0.68 1.41
13.08 11.37 9.85 6.34 20.71 40.19
8.65 5.93 7.17 4.25 14.05 56.55

22.68% 28.75% 41.22% 53.67% 53.06%

19.18% 18.66% 18.72% 17.90% 18.01% 22.04%

TRENDS: 10 YEARS 7 YEARS 5 YEARS 3 YEARS RECENT

Sales Growth 5.80% 2.35% 4.28% -0.34% 42.66%
OPM 17.97% 18.57% 18.50% 18.23% 22.04%
Price to Earning 12.94 15.28 16.92 19.27 40.19
SCREENER.IN

Best Case Worst Case

6,447.23 4,497.25
5,026.37 3,689.16
1,420.86 808.09
- -
339.64 339.64
90.64 90.64
990.58 377.81
25% 25%
744.53 283.97
1.46 0.56
40.19 12.94
58.72 7.21

BEST WORST
42.66% -0.34%
22.04% 17.97%
40.19 12.94
 NAVIGATION MENU

GO TO INSTRUCTIONS TAB RAT

INCOME STATEMENT DUPO

BALANCE SHEET INVEST

CASH FLOW STATEMENT

ON MENU

RATIO ANALYSIS

DUPONT ANALYSIS

INVESTING RESOURCES
Key Items Details
Company Name TRIDENT LTD
Current Price (INR) 57
No. of Shares (crores) 509.6
Market Cap (crores) 28,818
TTM Net Profit (crores) 717
TTM P/E ratio 40.2x
TTM Operating Profit Margin 22.0%
Latest FY ROAE 11.0%
Latest FY ROACE 10.5%
 Inco
COMPANY NAME >>
INR (in crores) Mar-12 Mar-13 Mar-14 Mar-15
Sales 2,720 3,318 3,841 3,735
Operating Profit 300 555 732 661
Other Income 20 22 12 34
EBITDA 320 578 744 695
Interest (172) (235) (210) (206)
Depreciation (208) (261) (268) (321)
Profit before tax (PBT) (59) 81 265 168
Tax 15 (32) (68) (50)
Profit after tax (PAT) / Net Profit (44) 49 197 118

Adjusted Equity Shares (in crores) 305.8 310.8 311.1 508.6

Price 1 1 1 2

Operating Profit Margin (OPM) % 11.0% 16.7% 19.1% 17.7%

Net Profit Margin (NPM) % n/m 1.5% 5.1% 3.2%
Tax Payout % n/m 39.2% 25.7% 29.8%
Interest Coverage Ratio (x) 0.7x 1.3x 2.3x 1.8x
Earnings Per Share (EPS) (0.1) 0.2 0.6 0.2
PE Ratio (x) (7.6x) 4.9x 2.3x 9.9x

NAVIGATION MENU
Income Statement Analysis
TRIDENT LTD
Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
3,665 4,617 4,566 5,220 4,699 4,519
730 886 852 977 841 814
33 106 62 46 24 40
763 992 914 1,023 865 854
(145) (141) (118) (112) (111) (72)
(337) (412) (404) (364) (333) (336)
282 439 392 547 421 445
(39) (102) (126) (176) (79) (99)
242 337 266 371 342 346

509.4 509.6 509.6 509.6 509.6 509.6

5 9 6 7 4 14

19.9% 19.2% 18.7% 18.7% 17.9% 18.0%

6.6% 7.3% 5.8% 7.1% 7.3% 7.7%
13.9% 23.2% 32.1% 32.2% 18.9% 22.3%
2.9x 4.1x 4.3x 5.9x 4.8x 7.2x
0.5 0.7 0.5 0.7 0.7 0.7
10.8x 13.1x 11.4x 9.9x 6.3x 20.7x
 GROWTH TREND ANALYSIS
TTM 9 YEARS 5 YEARS 3 YEARS
6,447 6% 4% (0%)
1,421 12% 2% (2%)
8% 4% (14%)
12% 2% (2%)

954 (225%) 10% 4%

717 (226%) 7% 9%

33% 22% 33%

22.0%
11.1%

(219%) 7% 9%
 Ba
COMPANY NAME >>
INR (in crores) Mar-12 Mar-13 Mar-14 Mar-15
Equity Share Capital 306 311 311 509
Reserves 343 395 577 947
Borrowings 2,284 2,240 1,862 2,580
Other Liabilities 335 341 434 468
Total Liabilities 3,267 3,287 3,185 4,504

Fixed Assets (Net Block) 2,148 1,968 1,796 2,864

Capital Work in Progress (CWIP) 6 28 36 222
Investments 56 64 119 31
Other Assets 1,057 1,226 1,234 1,387
Total Assets 3,267 3,287 3,185 4,504

Receivables 192 232 264 205

Inventory 520 691 643 747
Cash & Bank 23 33 25 17
Working Capital 722 885 800 918
Capital Employed 2,932 2,946 2,750 4,035
Total Equity 648 706 888 1,455

Net Fixed Asset Turnover 1.6x 2.0x 1.6x

Receivables Days 23 24 23
Inventory Turnover 5.5x 5.8x 5.4x
Debt To Equity 3.5x 3.2x 2.1x 1.8x
Return on average Equity (RoAE) 7.3% 24.7% 10.1%
Return on average Capital Employed 10.8% 16.7% 11.0%

NAVIGATION MENU
 Balance Sheet Analysis
TRIDENT LTD
Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
509 510 510 510 510 510
1,906 2,215 2,184 2,422 2,457 2,807
3,503 2,849 2,798 2,436 1,991 1,562
588 576 638 736 761 876
6,506 6,150 6,129 6,103 5,718 5,754

4,693 4,344 3,902 3,716 3,681 3,790

62 123 177 132 145 64
52 75 84 160 79 4
1,699 1,608 1,967 2,095 1,813 1,896
6,506 6,150 6,129 6,103 5,718 5,754

258 382 478 662 278 455

899 768 907 1,001 912 1,008
82 132 166 25 337 112
1,111 1,032 1,329 1,359 1,053 1,020
5,918 5,574 5,491 5,367 4,958 4,878
2,416 2,725 2,693 2,931 2,967 3,317

1.0x 1.0x 1.1x 1.4x 1.3x 1.2x

23 25 34 40 37 30
4.5x 5.5x 5.5x 5.5x 4.9x 4.7x
1.5x 1.0x 1.0x 0.8x 0.7x 0.5x
12.5% 13.1% 9.8% 13.2% 11.6% 11.0%
8.6% 10.1% 9.2% 12.1% 10.3% 10.5%
 AVERAGE TREND
9 YEARS 5 YEARS 3 YEARS

1.4x 1.2x 1.3x

29 33 35
5.2x 5.2x 5.0x
1.4x 0.8x 0.7x
12.6% 11.7% 11.9%
11.0% 10.5% 11.0%
 C
COMPANY NAME >>
INR (in crores) Mar-12 Mar-13 Mar-14 Mar-15
Cash from Operating Activity (CFO) 416 380 747 544
Cash from Investing Activity (CFI) (615) (100) (174) (114)
Cash from Financing Activity (CFF) 211 (285) (574) (432)
Net Cash Flow (CFO + CFI + CFF) 12 (5) (1) (2)

Cash & Equivalent at the end of year 23 33 25 17

Profit After Tax (PAT) (44) 49 197 118

Cash from Operating Activity (CFO) 416 380 747 544

CFO/PAT (atleast 80%) ### 771% 379% 462%

CAPEX 103 104 1,575

Free Cash Flows (FCF) 277 643 (1,031)

Re-investment (Capex/CFO) 27% 14% 289%

FCF/CFO

NAVIGATION MENU
 Cashflow Analysis
TRIDENT LTD
Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
533 1,000 476 653 1,209 499
(1,199) (168) (188) (42) (34) (149)
667 (808) (268) (650) (867) (570)
1 23 20 (38) 309 (220)

82 132 166 25 337 112

242 337 266 371 342 346

533 1,000 476 653 1,209 499

220% 297% 179% 176% 354% 144%

2,005 125 15 134 312 365

(1,473) 875 461 520 898 135

376% 13% 3% 20% 26% 73%

 GROWTH TREND ANALYSIS
TOTAL 9 YEARS 5 YEARS 3 YEARS

2,224 (226%) 7% 9%
6,458 2% (1%) 2%

290%

22%
TRIDENT LTD

Narration Mar-12 Mar-13 Mar-14 Mar-15 Mar-16 Mar-17 Mar-18

Cash from Operating Activity 416.06 380.29 746.85 544.33 532.68 999.62 475.95
Cash from Investing Activity -614.93 -100.02 -173.51 -113.95 ### -168.43 -188.05
Cash from Financing Activity 210.70 -285.30 -574.01 -432.09 666.95 -808.39 -268.12
Net Cash Flow 11.83 -5.03 -0.67 -1.71 0.73 22.80 19.78
0.73
 SCREENER.IN

Mar-19 Mar-20 Mar-21

653.28 1,209.44 499.11
-41.53 -33.52 -148.98
-649.65 -867.08 -570.04
-37.90 308.84 -219.91
 Ratio Analysis
COMPANY NAME >>
INR (in crores) Mar-12 Mar-13 Mar-14 Mar-15
Operating Profit Margin (OPM) % 11.0% 16.7% 19.1% 17.7%
Net Profit Margin (NPM) % n/m 1.5% 5.1% 3.2%
Tax Payout % n/m 39.2% 25.7% 29.8%
Interest Coverage Ratio (x) 0.7x 1.3x 2.3x 1.8x
Earnings Per Share (EPS) (0.14) 0.16 0.63 0.23
PE Ratio (x) (7.6x) 4.9x 2.3x 9.9x

Net Fixed Asset Turnover 1.6x 2.0x 1.6x

Receivables Days 23 24 23
Inventory Turnover 5.5x 5.8x 5.4x
Debt To Equity 3.5x 3.2x 2.1x 1.8x
Return on average Equity (RoAE) 7.3% 24.7% 10.1%
Return on average Capital Employed 10.8% 16.7% 11.0%

CFO/PAT (atleast 80%) (951%) 771% 379% 462%

FIVE STAGE MODEL - DUPONT ANALYSIS

Tax Burden (Net Income ÷ PBT) 0.74 0.61 0.74 0.70
Interest Burden (PBT ÷ EBIT) (0.18) 0.14 0.36 0.24
EBIT Margin (EBIT ÷ Sales) 11.8% 17.4% 19.4% 18.6%
Asset Turnover (Sales ÷ Total Assets) 0.8x 1.0x 1.2x 0.8x
Equity Multiplier (Total Assets ÷ Sharehol 5.0x 4.7x 3.6x 3.1x
Return on Equity (6.7%) 7.0% 22.2% 8.1%

NAVIGATION MENU
Ratio Analysis
TRIDENT LTD
Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21
19.9% 19.2% 18.7% 18.7% 17.9% 18.0%
6.6% 7.3% 5.8% 7.1% 7.3% 7.7%
13.9% 23.2% 32.1% 32.2% 18.9% 22.3%
2.9x 4.1x 4.3x 5.9x 4.8x 7.2x
0.48 0.66 0.52 0.73 0.67 0.68
10.8x 13.1x 11.4x 9.9x 6.3x 20.7x

1.0x 1.0x 1.1x 1.4x 1.3x 1.2x

23 25 34 40 37 30
4.5x 5.5x 5.5x 5.5x 4.9x 4.7x
1.5x 1.0x 1.0x 0.8x 0.7x 0.5x
12.5% 13.1% 9.8% 13.2% 11.6% 11.0%
8.6% 10.1% 9.2% 12.1% 10.3% 10.5%

220% 297% 179% 176% 354% 144%

0.86 0.77 0.68 0.68 0.81 0.78

0.37 0.44 0.43 0.53 0.49 0.52
20.8% 21.5% 20.0% 19.6% 18.4% 18.9%
0.6x 0.8x 0.7x 0.9x 0.8x 0.8x
2.7x 2.3x 2.3x 2.1x 1.9x 1.7x
10.0% 12.4% 9.9% 12.7% 11.5% 10.4%
TTM
22.0%
11.1%
 DuPont Ana
COMPANY NAME >>
INR (in crores) Mar-12 Mar-13
Sales 2,720 3,318
Profit before tax (PBT) (59) 81
EBIT (Operating Profit + Other Income) 320 578
Interest Expense (172) (235)
Income Tax 15 (32)
Net Income (44) 49
Total Assets 3,267 3,287
Shareholders Equity 648 706

THREE STAGE MODEL

Net Profit Margin (Net Income ÷ Sales) (1.6%) 1.5%
Asset Turnover (Sales ÷ Total Assets) 0.8x 1.0x
Equity Multiplier (Total Assets ÷ Shareholders Equity) 5.0x 4.7x
Return on Equity (6.7%) 7.0%

FIVE STAGE MODEL

Tax Burden (Net Income ÷ PBT) 0.74 0.61
Interest Burden (PBT ÷ EBIT) (0.18) 0.14
EBIT Margin (EBIT ÷ Sales) 11.8% 17.4%
Asset Turnover (Sales ÷ Total Assets) 0.8x 1.0x
Equity Multiplier (Total Assets ÷ Shareholders Equity) 5.0x 4.7x
Return on Equity (6.7%) 7.0%

CHECK 1 1

NAVIGATION MENU
DuPont Analysis
TRIDENT LTD
Mar-14 Mar-15 Mar-16 Mar-17 Mar-18 Mar-19
3,841 3,735 3,665 4,617 4,566 5,220
265 168 282 439 392 547
744 695 763 992 914 1,023
(210) (206) (145) (141) (118) (112)
(68) (50) (39) (102) (126) (176)
197 118 242 337 266 371
3,185 4,504 6,506 6,150 6,129 6,103
888 1,455 2,416 2,725 2,693 2,931

5.1% 3.2% 6.6% 7.3% 5.8% 7.1%

1.2x 0.8x 0.6x 0.8x 0.7x 0.9x
3.6x 3.1x 2.7x 2.3x 2.3x 2.1x
22.2% 8.1% 10.0% 12.4% 9.9% 12.7%

0.74 0.70 0.86 0.77 0.68 0.68

0.36 0.24 0.37 0.44 0.43 0.53
19.4% 18.6% 20.8% 21.5% 20.0% 19.6%
1.2x 0.8x 0.6x 0.8x 0.7x 0.9x
3.6x 3.1x 2.7x 2.3x 2.3x 2.1x
22.2% 8.1% 10.0% 12.4% 9.9% 12.7%

1 1 1 1 1 1
Mar-20 Mar-21
4,699 4,519
421 445
865 854
(111) (72)
(79) (99)
342 346
5,718 5,754
2,967 3,317

7.3% 7.7%
0.8x 0.8x
1.9x 1.7x
11.5% 10.4%

0.81 0.78
0.49 0.52
18.4% 18.9%
0.8x 0.8x
1.9x 1.7x
11.5% 10.4%

1 1
TRIDENT LTD

PEG Ratio

Report Date Mar-12 Mar-13 Mar-14 Mar-15 Mar-16

PE Ratio -7.55 4.85 2.32 9.89 10.78

EPS -0.14 0.16 0.63 0.23 0.48
EPS Growth Rate -211% 299% -63% 105%
Quarterly Sep-19 Dec-19 Mar-20 Jun-20 Sep-20
Profit 137.1 41.9 39.6 10.1 100.2
Equity Shares (Cr) 305.8 310.8 311.1 508.6 509.4
EPS 0.45 0.38
EPS Growth Rate -16%

Growth Rates Yearly Quarterly

EPS 2.9% 24.7%

TTM
PE Ratio 40.2

Current Price 56.55 56.55

EPS 4yr Avg 3% 3%
Mar-17 Mar-18 Mar-19 Mar-20 Mar-21 13.73

13.08 11.37 9.85 6.34 20.71

0.66 0.52 0.73 0.67 0.68
39% -21% 40% -8% 1%
Dec-20 Mar-21 Jun-21 Sep-21 Dec-21
159.8 75.6 203.5 228.8 209.1
Mod
509.6 509.6 509.6 509.6 509.6
0.61 0.68 1.06 1.31 1.41
PEG < 1.5
61% 12% 56% 24% 7%
Under Valued
Current Price
TRIDENT LTD 56.6
Avoid the sto
Pref
Ideal
 PEG

Estimated PEG Ratio

13.73

Modified PEG Scores for Emerging Markets

PEG < 1.5 PEG ( 2 - 3 ) PEG > 4

Under Valued Fair Valued Over Valued

Importaint Notes :
Avoid the stock if the Quarterly EPS Growth Rate is Negative
Prefer Stocks with PEG Ratio Lower than 2
Ideal Investment point is PEG Ratio less than 1
COMPANY NAME TRIDENT LTD
LATEST VERSION 2.10 PLEAS
CURRENT VERSION 2.10

META
Number of shares 509.60
Face Value 1
Current Price 56.55
Market Capitalization 28817.63

PROFIT & LOSS

Report Date Mar-12 Mar-13 Mar-14 Mar-15
Sales 2720.03 3317.95 3841.3 3734.91
Raw Material Cost 1644.57 1842.43 2029.67 2021.71
Change in Inventory 18.98 0.87 -22.32 92.08
Power and Fuel 215.24 265.44 291.84 322.38
Other Mfr. Exp 134.31 164.99 206.36 208.48
Employee Cost 201.49 237.86 287 386.95
Selling and admin 144.46 182.11 249.33 225.41
Other Expenses 98.86 70.62 22.85 0.97
Other Income 20.16 22.44 11.96 34
Depreciation 207.53 261.44 268.41 321.32
Interest 171.78 235.28 210.33 205.96
Profit before tax -59.07 81.09 265.15 167.81
Tax -15.33 31.76 68.12 49.99
Net profit -43.74 49.33 197.03 117.82
Dividend Amount 9.33 30.52

Quarters
Report Date Sep-19 Dec-19 Mar-20 Jun-20
Sales 1321.93 1081.71 990.49 707.93
Expenses 1066.63 937.7 845.29 594.65
Other Income 3.69 9.69 6.77 5.43
Depreciation 84.89 82.24 81.54 82.41
Interest 27.07 23.44 27.77 23.1
Profit before tax 147.03 48.02 42.66 13.2
Tax 9.94 6.12 3.1 3.1
Net profit 137.09 41.9 39.56 10.1
Operating Profit 255.3 144.01 145.2 113.28

BALANCE SHEET
Report Date Mar-12 Mar-13 Mar-14 Mar-15
Equity Share Capital 305.84 310.84 311.09 508.64
Reserves 342.58 395.43 576.79 946.68
Borrowings 2283.65 2239.81 1862.27 2580.14
Other Liabilities 334.53 340.81 434.38 468.43
Total 3266.6 3286.89 3184.53 4503.89
Net Block 2147.95 1968.22 1795.59 2863.86
Capital Work in Progress 6.38 28.05 36.28 221.89
Investments 55.65 64.47 118.73 31.35
Other Assets 1056.62 1226.15 1233.93 1386.79
Total 3266.6 3286.89 3184.53 4503.89
Receivables 191.9 232.3 264.14 204.78
Inventory 520.4 690.99 642.85 746.54
Cash & Bank 23.03 33.11 24.52 16.77
No. of Equity Shares 305837112 310837110 311086710 508641469
New Bonus Shares
Face value 10 10 10 10

722.09 885.34 799.55 918.36

CASH FLOW:
Report Date Mar-12 Mar-13 Mar-14 Mar-15
Cash from Operating Activity 416.06 380.29 746.85 544.33
Cash from Investing Activity -614.93 -100.02 -173.51 -113.95
Cash from Financing Activity 210.7 -285.3 -574.01 -432.09
Net Cash Flow 11.83 -5.03 -0.67 -1.71

PRICE: 1.08 0.77 1.47 2.29

DERIVED:
Adjusted Equity Shares in Cr 305.84 310.84 311.09 508.64
 PLEASE DO NOT MAKE ANY CHANGES TO THIS SHEET

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

3665.25 4617.38 4565.96 5219.52 4699.46 4519.29
1733.41 2199.67 2260.58 2460.23 2177.25 2030.07
2.99 -26.62 -21.08 32.47 35.86 4.79
324.09 381.63 412.94 450.45 440.88 431.82
208.93 274.28 305.85 373.29 351.06 365.28
428.54 576.38 505.75 592.3 583.13 577.54
213.28 248.22 224.38 281.3 304.95 284.29
29.87 24.79 -16.84 117.08 36.64 21.08
33.34 106.13 61.81 45.75 23.9 39.61
336.62 412.41 404.03 363.91 333.3 336.46
145.23 141.01 118.21 112.26 110.8 72
281.61 438.5 391.79 546.92 421.21 445.15
39.28 101.52 125.93 176 79.41 99.41
242.33 336.98 265.86 370.92 341.8 345.74
45.84 76.44 76.44 152.88 183.46 183.46

Sep-20 Dec-20 Mar-21 Jun-21 Sep-21 Dec-21

1171.44 1289.93 1349.99 1477.01 1662.57 1957.66
947.64 1051.79 1114.43 1097.41 1259.75 1554.78
3.15 62.04 -27.8 2.85 10.1 -21.74
83.1 82.96 87.99 87.41 86.72 77.52
12.3 13.21 23.39 25 19.87 22.38
131.55 204.01 96.38 270.04 306.33 281.24
31.31 44.25 20.75 66.54 77.53 72.14
 100.24 159.76 75.63 203.5 228.8 209.1
223.8 238.14 235.56 379.6 402.82 402.88

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

509.37 509.58 509.6 509.6 509.6 509.6
1906.24 2214.92 2183.89 2421.69 2457.3 2806.95
3502.66 2849.41 2797.81 2435.75 1990.75 1561.87
588.04 576.45 637.77 736.2 760.7 875.74
6506.31 6150.36 6129.07 6103.24 5718.35 5754.16
4693 4344.06 3901.53 3716.06 3680.81 3789.86
61.53 123.16 176.58 131.76 145.23 64.29
52.38 74.84 83.88 159.93 79.07 3.9
1699.4 1608.3 1967.08 2095.49 1813.24 1896.11
6506.31 6150.36 6129.07 6103.24 5718.35 5754.16
258.08 381.68 477.76 662 278.48 454.51
898.5 768.25 906.53 1000.96 911.98 1008.28
81.79 132.43 165.87 25.11 337.35 112.32
509371026 509579260 509595567 509595567 5095955670 5095955670

10 10 10 10 1 1

1,111.36 1,031.85 1,329.31 1,359.29 1,052.54 1,020.37

Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Mar-21

532.68 999.62 475.95 653.28 1209.44 499.11
-1198.9 -168.43 -188.05 -41.53 -33.52 -148.98
666.95 -808.39 -268.12 -649.65 -867.08 -570.04
0.73 22.8 19.78 -37.9 308.84 -219.91

5.13 8.65 5.93 7.17 4.25 14.05

509.37 509.58 509.60 509.60 509.60 509.60

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

8 way to choose Good Fundamentals Stocks

1.SalesGrowth(5 yr)>12-15%
2.ProfitGrowth(5 yr) >12-15%
3.Eps growth >15%
4.Debt to equity below 0.6
5 PE Ratio < Industry PE
6.P/B Ratio <5 1250
7.Mcap/Sales <5
8.Technical Big Range Breakout
… do ANYTHING.

dalal-street.in
 TRIDENT LTD CMP/EPS = PE 83.4 Parth
Year on Year 3/31/2017 3/31/2018 3/31/2019
1 Market Cap 440.7861Crs 302.1902Crs 365.3800Crs
2 EPS 0.66 0.52 0.73
3 PE Ratio 13.08 11.37 9.85
4 Share Capital 509.58 509.60 509.60
5 Cash Reserve 2215 2184 2422
6 Debt 2849 2798 2436
7 Current Assets 6150 6129 6103
8 Current Liabilities 576 638 736
*9 Top Line 4617 4566 5220
10 Bottom Line 337 266 371
11 ROCE 10% 9% 12%
*12 ROE/Oper.Profit Margin 12% 10% 13%
13 CF from OpertngActvty 999.62 475.95 653.28
14 Net Cash Flow 22.80 19.78 -37.9
15 Reserves > Debt & Liabilities
16 Book Value 5 5 6
17 Net Profit Margin 7% 6% 7%
18 Fixed Assete T-O Ratio 1 1 1
19 Net Working Capital 3423 3544 3363
20 NetWorkingCapital/Sales 74% 78% 64%
21 Debtor Days 25 34 40
22 Inventory Days 66 67 67
23 Debt to Total Capital 51% 51% 45%
*24 Other Income 106 62 46
25 CashFlow from Investing -168 -188 -42
26 CashFlow from Financing -808 -268 -650
27 Cum. CashFlow From Operation 1532 1476 1129
28 Cumulative Net Profit 260 235 279
29 Interest CoverageRatio 4.1x 4.3x 5.9x
30* CFO/PAT (atleast 80%) 297% 179% 176%
PEG Ratio < 1.5 UnderValued PEG 2-3 Fair Valued
More things we must Track are Promoter Holding Pledging Data

Quarter On Quarter Mar-20 Jun-20 Sep-20

Top Line 990.49 708 1171
Bottom Line 40 10 100
Operating Profit Margin 15% 16% 19%

Top Line Increasing No Yes

Bottom Line Increasing No Yes
Operating Profit Margin Increasing Yes Yes
 Debt & Equity Calculations
Report Date Mar/14 Mar/15 Mar/16
Equity Share Capital 311.09 508.64 509.37
Reserves 576.79 946.68 1906.24
Borrowings 1862.27 2580.14 3502.66
Other Liabilities 434.38 468.43 588.04

Reserves 887.88 1455.32 2415.61

Debt + Liabilities 2296.65 3048.57 4090.7
Inc

* Top Line / Operating Profit Margin and Other Income are Most Important in case of manufacturing Companies. TopLine
* PEG Ratio Work Only for Non-Dividend yielding Stocks.
* PEG Ratio is not a Good Matric for Assete Heavy Industries like…Real Estate, Telecom etc. here Price to Book Ratio is m

1 Point Number 25 and 27 - Operating cash flow Plus Cash flow from Investing should be graeter then Zero then we can c
2 In board of Director no family and Friends.
3 ROC > 15% in last 10 Years.
4 Company must Compete on Price Base ie wether it Reduces product prices in Competition or not if it does not good for
6 If Net Profit is increasing but Operating Profit is not Increasing means a Big part of profit is coming from other Income a
 5096000000 56.55 Conclusion
3/31/2020 3/31/2021 3/31/2018 3/31/2019 3/31/2020 ### Odds
2165.7812Crs 28817.8800Crs p p p 12
0.67 0.68 p p
6.34 20.71 q q q
509.60 509.60 n n n
2457 2807 p p p
1991 1561.87 q q q q
5718 5754 p
761 876
4699 4519 p
342 346 p p
10% 11% p p
12% 10% p
1209.44 499.11 p p
308.84 -219.91 p
p p
6 7 p p p
7% 8% p p p
1 1 p p
2421 2149 p
52% 48% q q q
37 30 q q
74 78 q
40% 32% q q q q
24 40 q q q
-34 -149 q q
-867 -570 q q
1863 1709 p
432 438 p p p
4.8x 7.2x p p p
354% 144% p p p p
PEG > 4 Over Valued 13.73 Overvalued 12
FII-DII-MF Holdings Odds

Dec-20 Mar-21 Jun-21 Sep-21 Dec-21

1290 1350 1477 1663 1958
160 76 204 229 209
18% 17% 26% 24% 21%

Yes Yes Yes Yes Yes

Yes No Yes Yes No
No No Yes No No
 Mar/17 Mar/18 Mar/19 Mar/20 Mar/21
509.58 509.6 509.6 509.6 509.6
2214.92 2183.89 2421.69 2457.3 2806.95
2849.41 2797.81 2435.75 1990.75 1561.87
576.45 637.77 736.2 760.7 875.74

2724.5 2693.49 2931.29 2966.9 3316.55

3425.86 3435.58 3171.95 2751.45 2437.61
p p

manufacturing Companies. TopLine & OPM should be Increasing and Other Income should be Zero.

m etc. here Price to Book Ratio is more reliable.

be graeter then Zero then we can conclude Company is Realy earning Profit - Sourabh Mukhereja - https://www.youtube.com/watch?v=3

etition or not if it does not good for company.

rofit is coming from other Income and that is not good for Company.
Favours
17

1
18
Favours
FINAL
ww.youtube.com/watch?v=3dfvVP36VxE&t=496s
TRIDENT LTD Quarterly Data
Sep-19 Dec-19 Mar-20 Jun-20
1322 1082 990 708
SALES Y-o-Y Sep-20 Y Dec-20 Y Mar-21 Y Jun-21
Q-o-Q 1171 Y 1290 Y 1350 Y 1477

Sep-19 Dec-19 Mar-20 Jun-20

137.1 41.9 39.6 10.1
Net Profit Y-o-Y Sep-20 Y Dec-20 Y Mar-21 Y Jun-21
Q-o-Q 100.2 Y 159.8 75.6 Y 203.5

Sep-19 Dec-19 Mar-20 Jun-20

255.3 144.0 145.2 113.3
Operating Y-o-Y Sep-20 Y Dec-20 Y Mar-21 Y Jun-21
Profit Q-o-Q 223.8 Y 238.1 235.6 Y 379.6

Sep-19 Dec-19 Mar-20 Jun-20

27.1 23.4 27.8 23.1
Interest Y-o-Y Sep-20 YES Dec-20 YES Mar-21 Jun-21
Q-o-Q 12.3 13.2 23.4 25.0

Sep-19 Dec-19 Mar-20 Jun-20

147.0 48.0 42.7 13.2
PBT Y-o-Y Sep-20 Y Dec-20 Y Mar-21 Y Jun-21
Q-o-Q 131.6 Y 204.0 96.4 Y 270.0

Sep-19 Dec-19 Mar-20 Jun-20

1.24 1.15 1.17 1.19
Sales/Expense Y-o-Y Sep-20 Y Dec-20 Y Mar-21 Y Jun-21
Q-o-Q 1.24 1.23 1.21 Y 1.35
Sep-20 Dec-20
1171 1290
Y Sep-21 Y Dec-21
Y 1663 Y 1958

Sep-20 Dec-20
100.2 159.8
Y Sep-21 Y Dec-21
Y 228.8 209.1

Sep-20 Dec-20
223.8 238.1
Y Sep-21 Y Dec-21
Y 402.8 Y 402.9

Sep-20 Dec-20
12.3 13.2
Sep-21 Dec-21
YES 19.9 22.4

Sep-20 Dec-20
131.6 204.0
Y Sep-21 Y Dec-21
Y 306.3 281.2

Sep-20 Dec-20
1.24 1.23
Y Sep-21 Y Dec-21
1.32 1.26
Q-Sales 9/30/2019 ### 3/31/2020 6/30/2020 9/30/2020 ### 3/31/2021 6/30/2021
TRIDENT LTD 1321.93 1081.71 990.49 707.93 1171.44 1289.93 1349.99 1477.01
L&T TECHNOLOGY SE 1343.1 1347.5 1402.1 1422.9 1446.6 1294.7 1313.8 1400.7
ORACLE FINANCIAL 1214.92 1275.1 1162.48 1160.15 1263.55 1337.26 1197.39 1238.42
TATA ELXSI LTD 405.1 361.71 385.83 423.44 438.89 400.49 430.18 477.1
COFORGE LTD 972.2 962.7 1038.5 1073.4 1109.3 1057 1153.7 1190.6
PERSISTENT SYSTEM 831.85 832.11 884.6 922.73 926.37 991.39 1007.75 1075.4
HAPPIEST MINDS TE 0 0 175.06 171.5 186.35 177.02 182.84 192.84
MPHASIS LTD 2024.96 2062.56 2158.11 2276.72 2346.15 2288.21 2435.43 2474.39
TEXMO PIPES & PRO 85.72 128.93 50.17 77.71 71.1 81.63 81.3 128.28

Y-Sales ### ### ### ### ### ### ### ###

TRIDENT LTD 2720.03 3317.95 3841.3 3734.91 3665.25 4617.38 4565.96 5219.52
L&T TECHNOLOGY SE 0 0 0 2618.63 3066.2 3248.3 3747.1 5078.3
ORACLE FINANCIAL 3146.68 3474 3741.32 3904.91 4131.22 4426.53 4527.47 4958.9
TATA ELXSI LTD 514.46 604.69 772.1 849.4 1075.21 1237.31 1386.3 1596.93
COFORGE LTD 1576.47 2021.36 2304.99 2372.5 2687.9 2802.1 2991.4 3676.2
PERSISTENT SYSTEM 1000.31 1294.51 1669.15 1891.25 2312.33 2878.44 3033.7 3365.94
HAPPIEST MINDS TE 0 7.82 68.66 170.86 341.16 430.77 443.65 590.36
MPHASIS LTD 5357.33 5796.3 2593.83 5794.81 6080.78 6076.36 6545.84 7730.98
TEXMO PIPES & PRO 175.32 205.16 236.59 308.79 252.72 294.68 248.75 305.9

Q-PAT 9/30/2019 ### 3/31/2020 6/30/2020 9/30/2020 ### 3/31/2021 6/30/2021

TRIDENT LTD 137.09 41.9 39.56 10.1 100.24 159.76 75.63 203.5
L&T TECHNOLOGY SE 191.5 203.9 205.8 204.1 204.8 117.2 165.5 186.1
ORACLE FINANCIAL 326 377.39 358.85 456.76 269.23 479.79 392.07 429.68
TATA ELXSI LTD 71.29 48.79 49.81 75.42 82.08 68.87 78.88 105.2
COFORGE LTD 105.5 87.6 119.5 123.3 113.6 79.9 120.7 122
PERSISTENT SYSTEM 84.47 82.47 86.07 87.93 83.82 90.01 101.99 120.92
HAPPIEST MINDS TE 0 0 26.74 21.51 4.89 48.78 34.08 42.15
MPHASIS LTD 266.15 264.7 273.31 293.6 353.23 275.12 299.23 325.53
TEXMO PIPES & PRO 0.66 1.3 0.4 1.28 0.97 1.33 1.48 3.19
Y-Sales ### ### ### ### ### ### ### ###
TRIDENT LTD -43.74 49.33 197.03 117.82 242.33 336.98 265.86 370.92
L&T TECHNOLOGY SE 0 0 0 310.9 419.1 424.9 506 765.6
ORACLE FINANCIAL 909.27 1075.14 1359.32 1192.32 1048.89 1185.39 1237.04 1385.9
TATA ELXSI LTD 33.95 20.99 75.11 102.9 154.81 174.78 240.04 289.97
COFORGE LTD 197.24 213.22 230.53 114.07 270 250.1 280.2 403.3
PERSISTENT SYSTEM 141.78 187.62 249.28 290.63 277.3 301.47 323.09 351.68
HAPPIEST MINDS TE 0 -29.34 -47.23 -66.25 5.45 4.24 -13.08 4.11
MPHASIS LTD 792.32 743.8 302.68 674.64 631.51 791.58 837.5 1073.35
TEXMO PIPES & PRO 4.19 1.26 1.85 3.41 3.3 -1.34 0.16 2.97
9/30/2021 ### Quaterly Sales
1662.57 1957.66
3000
1440.5 1518.4
1210.86 1397.37 2000

518.4 558.32 1000

1261.5 1461.6 0
9/1/2019 1/1/2020 5/1/2020 9/1/2020 1/1/2021 5/1/2021 9/1/2021
1113.36 1229.93
208.26 230.41 TRIDENT LTD
2524.28 2690.83 L&T TECHNOLOGY SERVICES LTD
130.44 128.72 ORACLE FINANCIAL SERVICES SOFTWARE LTD
TATA ELXSI LTD
COFORGE LTD
PERSISTENT SYSTEMS LTD
HAPPIEST MINDS TECHNOLOGIES LTD
MPHASIS LTD

### ### Yearly Sales

4699.46 4519.29
15000
5619.1 5449.7
10000
4861.28 4983.94
5000
1609.86 1826.16
0
4183.9 4662.8
1/1/2012 1/1/2014 1/1/2016 1/1/2018 1/1/2020
3565.81 4187.89
698.21 760.96 TRIDENT LTD
L&T TECHNOLOGY SERVICES LTD
8843.54 9722.31
ORACLE FINANCIAL SERVICES SOFTWARE LTD
325.52 421.66 TATA ELXSI LTD
COFORGE LTD
PERSISTENT SYSTEMS LTD
HAPPIEST MINDS TECHNOLOGIES LTD
MPHASIS LTD

9/30/2021 ###
228.8 209.1 Quarterly Net-Profi t
194.5 216.2 600
460.31 524.19
400
115.17 113.38
200
133 123.6
0
137.76 151.25 9/1/2019 1/1/2020 5/1/2020 9/1/2020 1/1/2021 5/1/2021 9/1/2021
36.92 35.01
316.94 339.69 TRIDENT LTD
L&T TECHNOLOGY SERVICES LTD
4.74 3.77 ORACLE FINANCIAL SERVICES SOFTWARE LTD
TATA ELXSI LTD
COFORGE LTD
PERSISTENT SYSTEMS LTD
HAPPIEST MINDS TECHNOLOGIES LTD
MPHASIS LTD
 TRIDENT LTD
L&T TECHNOLOGY SERVICES LTD
ORACLE FINANCIAL SERVICES SOFTWARE LTD
TATA ELXSI LTD
COFORGE LTD
PERSISTENT SYSTEMS LTD
HAPPIEST MINDS TECHNOLOGIES LTD
MPHASIS LTD

### ###
341.8 345.74 Yearly Net-Profi t
818.6 663.3 2000
1462.22 1761.86 1500
256.1 368.12 1000
500
444 455.6
0
340.29 450.68 -500 1/1/2012 1/1/2014 1/1/2016 1/1/2018 1/1/2020
73.43 161.93
1184.84 1216.81 TRIDENT LTD
L&T TECHNOLOGY SERVICES LTD
3.94 10.83 ORACLE FINANCIAL SERVICES SOFTWARE LTD
TATA ELXSI LTD
COFORGE LTD
PERSISTENT SYSTEMS LTD
HAPPIEST MINDS TECHNOLOGIES LTD
MPHASIS LTD
Q-Sales 9/30/2019 ### 3/31/2020 6/30/2020 9/30/2020 ### 3/31/2021 6/30/2021
TRIDENT LTD -18% -8% -29% 65% 10% 5% 9%
L&T TECHNOLOGY SERVICES LT 0% 4% 1% 2% -11% 1% 7%
ORACLE FINANCIAL SERVICES 5% -9% 0% 9% 6% -10% 3%
TATA ELXSI LTD -11% 7% 10% 4% -9% 7% 11%
COFORGE LTD -1% 8% 3% 3% -5% 9% 3%
PERSISTENT SYSTEMS LTD 0% 6% 4% 0% 7% 2% 7%
HAPPIEST MINDS TECHNOLOGI #DIV/0! #DIV/0! -2% 9% -5% 3% 5%
MPHASIS LTD 2% 5% 5% 3% -2% 6% 2%
TEXMO PIPES & PRODUCTS LT 50% -61% 55% -9% 15% 0% 58%

Y-Sales ### ### ### ### ### ### ### ###

TRIDENT LTD 22% 16% -3% -2% 26% -1% 14%
L&T TECHNOLOGY SERVICES LT #DIV/0! #DIV/0! #DIV/0! 17% 6% 15% 36%
ORACLE FINANCIAL SERVICES 10% 8% 4% 6% 7% 2% 10%
TATA ELXSI LTD 18% 28% 10% 27% 15% 12% 15%
COFORGE LTD 28% 14% 3% 13% 4% 7% 23%
PERSISTENT SYSTEMS LTD 29% 29% 13% 22% 24% 5% 11%
HAPPIEST MINDS TECHNOLOGI #DIV/0! 778% 149% 100% 26% 3% 33%
MPHASIS LTD 8% -55% 123% 5% 0% 8% 18%
TEXMO PIPES & PRODUCTS LT 17% 15% 31% -18% 17% -16% 23%

Q-PAT 9/30/2019 ### 3/31/2020 6/30/2020 9/30/2020 ### 3/31/2021 6/30/2021

TRIDENT LTD 137.09 -69% -6% -74% 892% 59% -53% 169%
L&T TECHNOLOGY SE 191.5 6% 1% -1% 0% -43% 41% 12%
ORACLE FINANCIAL 326 16% -5% 27% -41% 78% -18% 10%
TATA ELXSI LTD 71.29 -32% 2% 51% 9% -16% 15% 33%
COFORGE LTD 105.5 -17% 36% 3% -8% -30% 51% 1%
PERSISTENT SYSTEM 84.47 -2% 4% 2% -5% 7% 13% 19%
HAPPIEST MINDS TE 0 #DIV/0! #DIV/0! -20% -77% 898% -30% 24%
MPHASIS LTD 266.15 -1% 3% 7% 20% -22% 9% 9%
TEXMO PIPES & PRO 0.66 97% -69% 220% -24% 37% 11% 116%
Y-Sales ### ### ### ### ### ### ### ###
TRIDENT LTD -43.74 -213% 299% -40% 106% 39% -21% 40%
L&T TECHNOLOGY SE 0 #DIV/0! #DIV/0! #DIV/0! 35% 1% 19% 51%
ORACLE FINANCIAL 909.27 18% 26% -12% -12% 13% 4% 12%
TATA ELXSI LTD 33.95 -38% 258% 37% 50% 13% 37% 21%
COFORGE LTD 197.24 8% 8% -51% 137% -7% 12% 44%
PERSISTENT SYSTEM 141.78 32% 33% 17% -5% 9% 7% 9%
HAPPIEST MINDS TE 0 #DIV/0! 61% 40% -108% -22% -408% -131%
MPHASIS LTD 792.32 -6% -59% 123% -6% 25% 6% 28%
TEXMO PIPES & PRO 4.19 -70% 47% 84% -3% -141% -112% 1756%
9/30/2021 ###
13% 18%
3% 5%
-2% 15%
9% 8%
6% 16%
4% 10%
8% 11%
2% 7%
2% -1%

### ###
-10% -4%
11% -3%
-2% 3%
1% 13%
14% 11%
6% 17%
18% 9%
14% 10%
6% 30%

9/30/2021 ###
12% -9%
5% 11%
7% 14%
9% -2%
9% -7%
14% 10%
-12% -5%
-3% 7%
49% -20%
 ### ###
-8% 1%
7% -19%
6% 20%
-12% 44%
10% 3%
-3% 32%
1687% 121%
10% 3%
33% 175%