Particulars Mar-16 Mar-17 Mar-18 Mar-19 Mar-20 Trailing Best Case

Sales 4,673.00 5,236.40 5,462.80 7,021.50 7,764.30 7,850.60 8,863.71

Expenses 3,852.00 4,531.90 4,722.30 5,957.00 6,682.80 6,508.30 7,339.90
Operating Profit 821.00 704.50 740.50 1,064.50 1,081.50 1,342.30 1,513.81
Other Income 83.90 55.30 190.20 89.30 75.60 118.20 -
Depreciation 165.80 185.80 171.50 164.10 275.40 254.40 254.40
Interest 16.00 19.10 16.90 2.90 52.90 52.40 52.40
Profit before tax 723.10 554.90 742.30 986.80 828.80 1,153.70 1,207.01
Tax 170.60 136.30 172.20 232.70 197.90 283.80 25%
Net profit 552.50 418.60 570.10 754.10 630.90 869.90 910.10
EPS 32.93 24.92 34.78 45.93 38.33 52.81 55.25
Price to earning 19.84 18.18 22.19 20.57 21.62 26.84 26.84
Price 653.25 452.95 771.95 944.50 828.70 1,417.30 1502.793997

RATIOS: 268.48 168 180.29 541.86 213.98

Dividend Payout 48.59% 40.13% 31.62% 71.86% 33.92%
OPM 17.57% 13.45% 13.56% 15.16% 13.93% 17.10%

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

Sales Growth 19.96% 18.53% 16.86% 14.03% 10.58% 14.03%
OPM 15.64% 15.59% 14.63% 14.26% 17.10% 17.10%
Price to Earning 17.99 20.23 21.54 22.80 26.84 26.84
Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Equity Share Capital 167.80 168.00 163.90 164.20 164.60
Reserves 2,247.10 2,409.10 2,577.50 3,141.90 2,992.20
Borrowings 43.80 99.60 301.40 1.00 0.50
Other Liabilities 818.20 713.90 693.70 871.90 1,999.30
Total 3,276.90 3,390.60 3,736.50 4,179.00 5,156.60

Net Block 1,162.00 1,022.00 956.80 966.90 1,409.20

Capital Work in Progress 23.20 19.20 9.20 29.70 13.60
Investments 232.80 592.70 726.40 803.60 774.80
Other Assets 1,858.90 1,756.70 2,044.10 2,378.80 2,959.00
Total 3,276.90 3,390.60 3,736.50 4,179.00 5,156.60

Working Capital 1,040.70 1,042.80 1,350.40 1,506.90 959.70

Debtors 972.80 896.20 1,015.50 1,335.60 1,438.90
Inventory - - - - -

Debtor Days 75.98 62.47 67.85 69.43 67.64

Inventory Turnover - - - - -

Return on Equity 23% 16% 21% 23% 20%

Return on Capital Emp 33% 22% 27% 31% 27%

Debt to Equity Ratio 1.81% 3.86% 10.99% 0.03% 0.02%

Cost of Equity

Capex 760.10 41.80 96.30 194.70 701.60

Narration Mar-16 Mar-17 Mar-18 Mar-19 Mar-20
Cash from Operating Activity 421.40 653.50 564.40 630.50 825.10
Cash from Investing Activity -416.50 -458.80 -200.20 -180.00 5.90
Cash from Financing Activity -172.00 -137.60 -287.50 -522.10 -696.00
Net Cash Flow -167.10 57.10 76.70 -71.60 135.00

Change in Capex 760.10 41.80 96.30 194.70 701.60

FCFF -338.70 611.70 468.10 435.80 123.50
3 year Rolling FCFF 41.30 190.60 247.03 505.20 342.47
FCFF growth rate 0.20 4.62 0.30 1.05 -32.21%

FCFF growth CAGR

3 year rolling CFO 447.20 557.73 546.43 616.13 673.33

3 year rolling Capex 405.90 367.13 299.40 110.93 330.87
3 year rolling FCFF 41.30 190.60 247.03 505.20 342.47
Average FCCF 0.20 4.62 1.30 2.05 0.68
Average FCFF growth
Narration Jun-18 Sep-18 Dec-18 Mar-19 Jun-19 Sep-19 Dec-19 Mar-20 Jun-20 Sep-20
Sales 1,639.50 1,755.40 1,787.20 1,839.40 1,834.20 1,914.30 1,965.30 2,050.50 1,908.80 1,926.00
Expenses 1,408.50 1,485.50 1,503.90 1,559.10 1,650.10 1,666.10 1,659.00 1,726.80 1,586.80 1,535.70
Operating Profit 231.00 269.90 283.30 280.30 184.10 248.20 306.30 323.70 322.00 390.30
Other Income 27.90 52.40 -20.00 29.00 22.00 19.70 34.80 18.30 40.60 24.50
Depreciation 40.00 40.30 41.00 42.80 66.90 70.70 69.90 67.90 59.70 56.90
Interest 2.80 0.10 - - 13.00 13.80 13.30 12.80 13.10 13.20
Profit before tax 216.10 281.90 222.30 266.50 126.20 183.40 257.90 261.30 289.80 344.70
Tax 57.90 75.60 31.10 68.10 33.50 48.40 60.90 55.10 76.80 91.00
Net profit 158.20 206.30 191.20 198.40 92.70 135.00 197.00 206.20 213.00 253.70

OPM 14.09% 15.38% 15.85% 15.24% 10.04% 12.97% 15.59% 15.79% 16.87% 20.26%
Date MindTree Close Sensex Close Returns
11/29/2017 549.900024 33602.761719 Sensex Mindtree
11/30/2017 538.849976 33149.351563 -0.95% -1.56%
12/1/2017 530.450012 32832.941406 0.11% 4.19%
12/4/2017 552.650024 32869.71875 -0.20% -2.26%
12/5/2017 540.150024 32802.441406 -0.63% -0.21%
12/6/2017 539 32597.179688 1.08% 3.24%
12/7/2017 556.450012 32949.210938 0.91% -1.88%
12/8/2017 546 33250.300781 0.62% -0.17%
12/11/2017 545.049988 33455.789063 -0.68% 3.50%
12/12/2017 564.099976 33227.988281 -0.53% 0.08%
12/13/2017 564.549988 33053.039063 0.59% -0.05%
12/14/2017 564.25 33246.699219 0.65% 0.31%
12/15/2017 566 33462.96875 0.41% 1.44%
12/18/2017 574.150024 33601.679688 0.70% -0.84%
12/19/2017 569.349976 33836.738281 -0.18% 1.34%
12/20/2017 577 33777.378906 -0.06% -0.33%
12/21/2017 575.099976 33756.28125 0.55% 4.18%
12/22/2017 599.150024 33940.300781 0.21% -0.12%
12/26/2017 598.450012 34010.609375 -0.29% 2.08%
12/27/2017 610.900024 33911.808594 -0.19% 0.43%
12/28/2017 613.5 33848.03125 0.62% -0.55%
12/29/2017 610.099976 34056.828125 -0.72% -0.68%
1/1/2018 605.950012 33812.75 0.00% -0.31%
1/2/2018 604.099976 33812.261719 -0.06% -0.94%
1/3/2018 598.400024 33793.378906 0.52% 0.13%
1/4/2018 599.200012 33969.640625 0.54% 0.50%
1/5/2018 602.200012 34153.851563 0.58% 4.99%
1/8/2018 632.25 34352.789063 0.26% -1.00%
1/9/2018 625.950012 34443.191406 -0.03% -0.43%
1/10/2018 623.25 34433.070313 0.20% -0.36%
1/11/2018 621 34503.488281 0.26% 1.76%
1/12/2018 631.950012 34592.390625 0.73% -0.86%
1/15/2018 626.5 34843.511719 -0.21% -0.95%
1/16/2018 620.549988 34771.050781 0.89% 0.47%
1/17/2018 623.450012 35081.820313 0.51% 9.98%
1/18/2018 685.650024 35260.289063 0.71% 2.34%
1/19/2018 701.700012 35511.578125 0.81% 7.68%
1/22/2018 755.599976 35798.011719 0.96% 0.62%
1/23/2018 760.25 36139.980469 0.06% -0.75%
1/24/2018 754.549988 36161.640625 -0.31% -0.85%
1/25/2018 748.150024 36050.441406 0.65% 1.95%
1/29/2018 762.75 36283.25 -0.69% 0.24%
1/30/2018 764.599976 36033.730469 -0.19% 0.50%
1/31/2018 768.450012 35965.019531 -0.16% -1.95%
2/1/2018 753.450012 35906.660156 -2.34% -2.40%
2/2/2018 735.349976 35066.75 -0.88% -4.17%
 2/5/2018 704.650024 34757.160156 -1.61% 2.43%
2/6/2018 721.799988 34195.941406 -0.33% -0.64%
2/7/2018 717.150024 34082.710938 0.97% 2.09%
2/8/2018 732.150024 34413.160156 -1.18% -2.06%
2/9/2018 717.099976 34005.761719 0.87% 0.74%
2/12/2018 722.400024 34300.46875 -0.42% 0.15%
2/14/2018 723.5 34155.949219 0.41% -2.79%
2/15/2018 703.299988 34297.46875 -0.84% 1.23%
2/16/2018 711.950012 34010.761719 -0.69% -2.89%
2/19/2018 691.349976 33774.660156 -0.21% 0.78%
2/20/2018 696.75 33703.589844 0.42% 4.56%
2/21/2018 728.549988 33844.859375 -0.07% 1.74%
2/22/2018 741.200012 33819.5 0.95% 9.60%
2/23/2018 812.349976 34142.148438 0.89% -1.26%
2/26/2018 802.099976 34445.75 -0.29% 0.02%
2/27/2018 802.299988 34346.390625 -0.47% 1.51%
2/28/2018 814.450012 34184.039063 -0.40% -0.37%
3/1/2018 811.450012 34046.941406 -0.88% 5.96%
3/5/2018 859.799988 33746.78125 -1.27% -4.08%
3/6/2018 824.75 33317.199219 -0.85% 0.75%
3/7/2018 830.950012 33033.089844 0.96% -1.57%
3/8/2018 817.900024 33351.570313 -0.13% -0.40%
3/9/2018 814.650024 33307.140625 1.83% 0.08%
3/12/2018 815.299988 33917.941406 -0.18% -1.72%
3/13/2018 801.25 33856.78125 -0.06% -0.16%
3/14/2018 799.950012 33835.738281 -0.44% 5.42%
3/15/2018 843.299988 33685.539063 -1.51% -3.50%
3/16/2018 813.799988 33176 -0.76% -4.36%
3/19/2018 778.349976 32923.121094 0.22% -0.52%
3/20/2018 774.299988 32996.761719 0.42% 2.20%
3/21/2018 791.349976 33136.179688 -0.39% -2.10%
3/22/2018 774.700012 33006.269531 -1.24% 0.99%
3/23/2018 782.349976 32596.539063 1.44% -1.39%
3/26/2018 771.450012 33066.410156 0.33% 0.12%
3/27/2018 772.349976 33174.390625 -0.62% 0.21%
3/28/2018 774 32968.679688 0.87% 4.37%
4/2/2018 807.849976 33255.359375 0.35% -0.80%
4/3/2018 801.349976 33370.628906 -1.05% -2.70%
4/4/2018 779.700012 33019.070313 1.75% 3.21%
4/5/2018 804.75 33596.800781 0.09% 3.22%
4/6/2018 830.650024 33626.96875 0.48% -1.05%
4/9/2018 821.900024 33788.539063 0.27% 0.91%
4/10/2018 829.349976 33880.25 0.18% -0.07%
4/11/2018 828.799988 33940.441406 0.47% 0.89%
4/12/2018 836.150024 34101.128906 0.27% 1.94%
4/13/2018 852.349976 34192.648438 0.33% 1.83%
4/16/2018 867.950012 34305.429688 0.26% 1.78%
4/17/2018 883.400024 34395.058594 -0.18% -1.94%
4/18/2018 866.299988 34331.679688 0.28% 3.58%
4/19/2018 897.299988 34427.289063 -0.03% 8.93%
4/20/2018 977.450012 34415.578125 0.10% 2.21%
4/23/2018 999.099976 34450.769531 0.48% -0.05%
4/24/2018 998.650024 34616.640625 -0.33% 3.42%
4/25/2018 1032.849976 34501.269531 0.62% 3.42%
4/26/2018 1068.150024 34713.601563 0.74% -1.29%
4/27/2018 1054.400024 34969.699219 0.55% 2.94%
4/30/2018 1085.349976 35160.359375 0.05% -3.10%
5/2/2018 1051.699951 35176.421875 -0.21% -1.97%
5/3/2018 1031 35103.140625 -0.53% -1.94%
5/4/2018 1010.950012 34915.378906 0.84% 0.39%
5/7/2018 1014.849976 35208.140625 0.02% 1.54%
5/8/2018 1030.449951 35216.320313 0.29% -1.17%
5/9/2018 1018.349976 35319.351563 -0.21% -0.13%
5/10/2018 1017 35246.269531 0.82% -0.90%
5/11/2018 1007.799988 35535.789063 0.06% -1.51%
5/14/2018 992.549988 35556.710938 -0.04% 0.63%
5/15/2018 998.799988 35543.941406 -0.44% 0.81%
5/16/2018 1006.849976 35387.878906 -0.67% -0.52%
5/17/2018 1001.650024 35149.121094 -0.86% 0.39%
5/18/2018 1005.549988 34848.300781 -0.67% 2.15%
5/21/2018 1027.150024 34616.128906 0.10% -0.98%
5/22/2018 1017.099976 34651.238281 -0.88% 1.63%
5/23/2018 1033.699951 34344.910156 0.93% 0.52%
5/24/2018 1039.099976 34663.109375 0.76% -1.44%
5/25/2018 1024.150024 34924.871094 0.69% -1.35%
5/28/2018 1010.299988 35165.480469 -0.61% 0.90%
5/29/2018 1019.349976 34949.238281 -0.12% -0.28%
5/30/2018 1016.450012 34906.109375 1.19% -0.87%
5/31/2018 1007.650024 35322.378906 -0.27% 0.00%
6/1/2018 1007.599976 35227.261719 -0.61% -0.61%
6/4/2018 1001.5 35011.890625 -0.31% -1.20%
6/5/2018 989.5 34903.210938 0.79% 2.34%
6/6/2018 1012.650024 35178.878906 0.81% -0.09%
6/7/2018 1011.700012 35463.078125 -0.05% 1.61%
6/8/2018 1027.949951 35443.671875 0.11% 0.26%
6/11/2018 1030.599976 35483.46875 0.59% 1.27%
6/12/2018 1043.699951 35692.519531 0.13% -1.31%
6/13/2018 1030 35739.160156 -0.39% -3.52%
6/14/2018 993.75 35599.820313 0.06% 0.96%
6/15/2018 1003.25 35622.140625 -0.21% -1.14%
6/18/2018 991.799988 35548.261719 -0.74% -0.82%
6/19/2018 983.700012 35286.738281 0.74% 1.26%
6/20/2018 996.099976 35547.328125 -0.32% -0.67%
6/21/2018 989.450012 35432.390625 0.73% -0.38%
6/22/2018 985.650024 35689.601563 -0.61% -3.38%
6/25/2018 952.299988 35470.351563 0.06% 1.53%
6/26/2018 966.849976 35490.039063 -0.77% 0.65%
6/27/2018 973.099976 35217.109375 -0.51% -2.17%
6/28/2018 951.950012 35037.640625 1.10% 3.61%
6/29/2018 986.349976 35423.480469 -0.45% 0.53%
7/2/2018 991.599976 35264.410156 0.32% 1.32%
7/3/2018 1004.700012 35378.601563 0.75% 0.51%
7/4/2018 1009.849976 35645.398438 -0.20% -1.03%
7/5/2018 999.450012 35574.550781 0.23% -0.50%
7/6/2018 994.5 35657.859375 0.78% 2.15%
7/9/2018 1015.900024 35934.71875 0.85% 1.77%
7/10/2018 1033.900024 36239.621094 0.07% 1.26%
7/11/2018 1046.949951 36265.929688 0.78% 2.75%
7/12/2018 1075.75 36548.410156 -0.02% -0.93%
7/13/2018 1065.75 36541.628906 -0.60% 1.07%
7/16/2018 1077.150024 36323.769531 0.54% 0.33%
7/17/2018 1080.75 36519.960938 -0.40% -1.68%
7/18/2018 1062.550049 36373.441406 -0.06% -8.67%
7/19/2018 970.450012 36351.230469 0.40% 0.66%
7/20/2018 976.900024 36496.371094 0.61% -1.82%
7/23/2018 959.150024 36718.601563 0.29% 1.17%
7/24/2018 970.400024 36825.101563 0.09% -1.37%
7/25/2018 957.099976 36858.230469 0.34% -1.00%
7/26/2018 947.5 36984.640625 0.95% -1.00%
7/27/2018 938.049988 37336.851563 0.42% -2.33%
7/30/2018 916.200012 37494.398438 0.30% 1.58%
7/31/2018 930.700012 37606.578125 -0.23% 2.49%
8/1/2018 953.849976 37521.621094 -0.95% -0.31%
8/2/2018 950.849976 37165.160156 1.05% 0.54%
8/3/2018 956 37556.160156 0.36% -0.16%
8/6/2018 954.450012 37691.890625 -0.07% -0.84%
8/7/2018 946.400024 37665.800781 0.59% 1.28%
8/8/2018 958.549988 37887.558594 0.36% -1.21%
8/9/2018 946.950012 38024.371094 -0.41% 0.27%
8/10/2018 949.549988 37869.230469 -0.59% 3.23%
8/13/2018 980.200012 37644.898438 0.55% 2.69%
8/14/2018 1006.549988 37852 -0.50% 3.03%
8/16/2018 1037.050049 37663.558594 0.75% -0.73%
8/17/2018 1029.5 37947.878906 0.87% 0.71%
8/20/2018 1036.849976 38278.75 0.02% 0.02%
8/21/2018 1037.050049 38285.75 0.13% 0.10%
8/23/2018 1038.099976 38336.761719 -0.22% -2.39%
8/24/2018 1013.299988 38251.800781 1.16% 3.49%
8/27/2018 1048.650024 38694.109375 0.52% -0.87%
8/28/2018 1039.5 38896.628906 -0.45% -0.34%
8/29/2018 1035.949951 38722.929688 -0.08% 1.39%
 8/30/2018 1050.349976 38690.101563 -0.12% 5.92%
8/31/2018 1112.550049 38645.070313 -0.86% -1.19%
9/3/2018 1099.300049 38312.519531 -0.40% 1.75%
9/4/2018 1118.5 38157.921875 -0.37% 2.86%
9/5/2018 1150.5 38018.308594 0.59% 0.63%
9/6/2018 1157.800049 38242.808594 0.38% 0.28%
9/7/2018 1161 38389.820313 -1.22% -1.27%
9/10/2018 1146.25 37922.171875 -1.34% 1.18%
9/11/2018 1159.800049 37413.128906 0.81% -1.14%
9/12/2018 1146.599976 37717.960938 0.99% -0.13%
9/14/2018 1145.150024 38090.640625 -1.33% 0.57%
9/17/2018 1151.650024 37585.511719 -0.78% -0.52%
9/18/2018 1145.650024 37290.671875 -0.45% -2.23%
9/19/2018 1120.150024 37121.21875 -0.75% -3.11%
9/21/2018 1085.300049 36841.601563 -1.46% -1.36%
9/24/2018 1070.550049 36305.019531 0.96% 1.23%
9/25/2018 1083.75 36652.058594 -0.30% -1.11%
9/26/2018 1071.75 36542.269531 -0.60% -1.81%
9/27/2018 1052.349976 36324.171875 -0.27% -1.79%
9/28/2018 1033.550049 36227.140625 0.83% 4.02%
10/1/2018 1075.099976 36526.140625 -1.51% -0.21%
10/3/2018 1072.849976 35975.628906 -2.24% -1.03%
10/4/2018 1061.75 35169.160156 -2.25% -1.96%
10/5/2018 1040.949951 34376.988281 0.28% -4.18%
10/8/2018 997.400024 34474.378906 -0.51% 1.30%
10/9/2018 1010.400024 34299.46875 1.35% -0.32%
10/10/2018 1007.150024 34760.890625 -2.19% -2.59%
10/11/2018 981.099976 34001.148438 2.15% -2.82%
10/12/2018 953.450012 34733.578125 0.38% 2.82%
10/15/2018 980.299988 34865.101563 0.85% 0.50%
10/16/2018 985.200012 35162.480469 -1.09% -0.63%
10/17/2018 978.950012 34779.578125 -1.33% -17.02%
10/19/2018 812.349976 34315.628906 -0.53% -0.91%
10/22/2018 804.950012 34134.378906 -0.84% 0.70%
10/23/2018 810.549988 33847.230469 0.55% -0.67%
10/24/2018 805.099976 34033.960938 -1.01% -2.91%
10/25/2018 781.700012 33690.089844 -1.01% -1.48%
10/26/2018 770.150024 33349.308594 2.15% 1.05%
10/29/2018 778.25 34067.398438 -0.52% 1.03%
10/30/2018 786.25 33891.128906 1.63% 8.43%
10/31/2018 852.549988 34442.050781 -0.03% -3.00%
11/1/2018 826.950012 34431.96875 1.68% -2.70%
11/2/2018 804.650024 35011.648438 -0.17% 1.97%
11/5/2018 820.5 34950.921875 0.12% 1.72%
11/6/2018 834.599976 34991.910156 0.70% 0.22%
11/7/2018 836.400024 35237.679688 -0.22% 1.81%
11/9/2018 851.549988 35158.550781 -0.98% 1.40%
11/12/2018 863.450012 34812.988281 0.95% -2.19%
11/13/2018 844.5 35144.488281 -0.01% 0.34%
11/14/2018 847.400024 35141.988281 0.34% -1.03%
11/15/2018 838.650024 35260.539063 0.56% -0.05%
11/16/2018 838.200012 35457.160156 0.90% 0.96%
11/19/2018 846.25 35774.878906 -0.84% -1.45%
11/20/2018 833.950012 35474.511719 -0.77% -0.74%
11/21/2018 827.75 35199.800781 -0.62% 0.22%
11/22/2018 829.549988 34981.019531 1.07% 0.81%
11/26/2018 836.25 35354.078125 0.45% -1.35%
11/27/2018 824.950012 35513.140625 0.57% 5.95%
11/28/2018 874.049988 35716.949219 1.27% -2.83%
11/29/2018 849.299988 36170.410156 0.07% 3.17%
11/30/2018 876.25 36194.300781 0.13% 1.97%
12/3/2018 893.5 36241 -0.29% -0.97%
12/4/2018 884.849976 36134.308594 -0.69% -1.57%
12/5/2018 871 35884.410156 -1.59% -1.03%
12/6/2018 862 35312.128906 1.02% 0.57%
12/7/2018 866.900024 35673.25 -2.00% -1.04%
12/10/2018 857.849976 34959.71875 0.54% 0.43%
12/11/2018 861.5 35150.011719 1.79% 1.99%
12/12/2018 878.650024 35779.070313 0.42% -2.24%
12/13/2018 859 35929.640625 0.09% 0.88%
12/14/2018 866.549988 35962.929688 0.85% 0.48%
12/17/2018 870.75 36270.070313 0.21% -2.93%
12/18/2018 845.25 36347.078125 0.38% 0.56%
12/19/2018 850 36484.328125 -0.14% -0.09%
12/20/2018 849.200012 36431.671875 -1.89% -0.29%
12/21/2018 846.75 35742.070313 -0.76% -1.15%
12/24/2018 837.049988 35470.148438 0.51% 1.75%
12/26/2018 851.700012 35649.941406 0.44% 0.79%
12/27/2018 858.450012 35807.28125 0.75% 0.55%
12/28/2018 863.150024 36076.71875 -0.02% 0.02%
12/31/2018 863.349976 36068.328125 -0.49% -0.56%
1/2/2019 858.549988 35891.519531 -1.05% -2.82%
1/3/2019 834.349976 35513.710938 0.51% -2.29%
1/4/2019 815.25 35695.101563 0.43% 2.47%
1/7/2019 835.349976 35850.160156 0.36% -1.71%
1/8/2019 821.099976 35980.929688 0.64% 0.24%
1/9/2019 823.049988 36212.910156 -0.29% -1.43%
1/10/2019 811.25 36106.5 -0.27% 2.55%
1/11/2019 831.900024 36009.839844 -0.43% 2.36%
1/14/2019 851.5 35853.558594 1.30% 0.40%
1/15/2019 854.900024 36318.328125 0.01% -1.53%
1/16/2019 841.849976 36321.289063 0.15% 3.03%
1/17/2019 867.400024 36374.078125 0.03% 2.24%
1/18/2019 886.799988 36386.609375 0.53% -0.60%
1/21/2019 881.5 36578.960938 -0.37% 4.32%
1/22/2019 919.549988 36444.640625 -0.92% -1.40%
1/23/2019 906.650024 36108.46875 0.24% 0.31%
1/24/2019 909.450012 36195.101563 -0.47% -2.58%
1/25/2019 885.950012 36025.539063 -1.02% -1.95%
1/28/2019 868.650024 35656.699219 -0.18% 3.85%
1/29/2019 902.099976 35592.5 0.00% -1.32%
1/30/2019 890.150024 35591.25 1.87% 0.44%
1/31/2019 894.099976 36256.691406 0.59% 0.59%
2/1/2019 899.400024 36469.429688 0.31% -0.93%
2/4/2019 891 36582.738281 0.09% -0.43%
2/5/2019 887.200012 36616.808594 0.98% 0.95%
2/6/2019 895.650024 36975.230469 -0.01% 0.55%
2/7/2019 900.549988 36971.089844 -1.15% -0.83%
2/8/2019 893.099976 36546.480469 -0.41% 2.73%
2/11/2019 917.5 36395.03125 -0.66% -1.84%
2/12/2019 900.599976 36153.621094 -0.77% -0.41%
2/14/2019 896.900024 35876.21875 -0.19% -0.28%
2/15/2019 894.400024 35808.949219 -0.87% -2.68%
2/18/2019 870.400024 35498.441406 -0.41% 1.92%
2/19/2019 887.099976 35352.609375 1.14% 1.80%
2/20/2019 903.099976 35756.261719 0.40% -0.56%
2/21/2019 898 35898.351563 -0.07% 0.40%
2/22/2019 901.599976 35871.480469 0.95% 0.82%
2/25/2019 909 36213.378906 -0.66% -0.34%
2/26/2019 905.900024 35973.710938 -0.19% -0.94%
2/27/2019 897.400024 35905.429688 -0.11% 1.22%
2/28/2019 908.349976 35867.441406 0.55% 2.53%
3/1/2019 931.349976 36063.808594 1.05% -1.59%
3/5/2019 916.5 36442.539063 0.53% 0.15%
3/6/2019 917.900024 36636.101563 0.24% 0.01%
3/7/2019 918 36725.421875 -0.15% 0.32%
3/8/2019 920.950012 36671.429688 1.04% 0.74%
3/11/2019 927.799988 37054.101563 1.30% -1.22%
3/12/2019 916.5 37535.660156 0.58% 0.81%
3/13/2019 923.950012 37752.171875 0.01% 2.90%
3/14/2019 950.75 37754.890625 0.71% -0.50%
3/15/2019 946 38024.320313 0.19% 1.74%
3/18/2019 962.5 38095.070313 0.70% -2.03%
3/19/2019 943 38363.46875 0.06% 0.74%
3/20/2019 950 38386.75 -0.58% -1.16%
3/22/2019 939 38164.609375 -0.93% 0.13%
3/25/2019 940.25 37808.910156 1.12% 1.10%
3/26/2019 950.549988 38233.410156 -0.26% -1.01%
3/27/2019 940.950012 38132.878906 1.08% 0.02%
3/28/2019 941.150024 38545.71875 0.85% 0.36%
4/1/2019 944.5 38871.871094 0.48% 0.08%
 4/2/2019 945.25 39056.648438 -0.46% -0.21%
4/3/2019 943.25 38877.121094 -0.49% -0.11%
4/4/2019 942.25 38684.71875 0.46% 1.06%
4/5/2019 952.25 38862.230469 -0.42% 0.56%
4/8/2019 957.599976 38700.53125 0.62% 0.23%
4/9/2019 959.799988 38939.21875 -0.91% 0.93%
4/10/2019 968.75 38585.351563 0.06% 0.53%
4/11/2019 973.849976 38607.011719 0.41% 0.07%
4/12/2019 974.549988 38767.109375 0.36% 0.36%
4/15/2019 978.049988 38905.839844 0.95% -0.60%
4/16/2019 972.150024 39275.640625 -0.34% -0.31%
4/18/2019 969.099976 39140.28125 -1.26% 0.38%
4/22/2019 972.799988 38645.179688 -0.21% 0.30%
4/23/2019 975.75 38564.878906 1.27% 0.34%
4/24/2019 979.099976 39054.679688 -0.83% 1.00%
4/25/2019 988.849976 38730.859375 0.87% -1.27%
4/26/2019 976.25 39067.328125 -0.09% 0.52%
4/30/2019 981.299988 39031.550781 -0.13% 0.03%
5/2/2019 981.549988 38981.429688 -0.05% -1.11%
5/3/2019 970.650024 38963.261719 -0.93% 0.95%
5/6/2019 979.849976 38600.339844 -0.84% -0.06%
5/7/2019 979.299988 38276.628906 -1.27% 0.12%
5/8/2019 980.5 37789.128906 -0.61% -0.19%
5/9/2019 978.599976 37558.910156 -0.26% -0.55%
5/10/2019 973.25 37462.988281 -0.99% 0.24%
5/13/2019 975.549988 37090.820313 0.61% -0.13%
5/14/2019 974.25 37318.53125 -0.55% 0.09%
5/15/2019 975.099976 37114.878906 0.75% 0.53%
5/16/2019 980.25 37393.480469 1.44% 0.16%
5/17/2019 981.799988 37930.769531 3.75% -0.18%
5/20/2019 980.049988 39352.671875 -0.97% 0.14%
5/21/2019 981.450012 38969.800781 0.36% 0.21%
5/22/2019 983.5 39110.210938 -0.76% -0.36%
5/23/2019 979.950012 38811.390625 1.61% 0.01%
5/24/2019 980 39434.71875 0.63% -0.08%
5/27/2019 979.25 39683.289063 0.17% 0.31%
5/28/2019 982.299988 39749.730469 -0.62% -0.21%
5/29/2019 980.200012 39502.050781 0.84% -0.02%
5/30/2019 980 39831.96875 -0.30% -0.23%
5/31/2019 977.700012 39714.199219 1.39% 0.41%
6/3/2019 981.75 40267.621094 -0.46% -0.99%
6/4/2019 972.049988 40083.539063 -1.38% -0.70%
6/6/2019 965.200012 39529.71875 0.22% 0.39%
6/7/2019 969 39615.898438 0.43% 0.58%
6/10/2019 974.650024 39784.519531 0.42% 0.28%
6/11/2019 977.400024 39950.460938 -0.48% -0.19%
6/12/2019 975.5 39756.808594 -0.04% -0.35%
6/13/2019 972.099976 39741.359375 -0.73% -0.15%
6/14/2019 970.599976 39452.070313 -1.25% -0.22%
6/17/2019 968.450012 38960.789063 0.22% 0.45%
6/18/2019 972.849976 39046.339844 0.17% -0.13%
6/19/2019 971.549988 39112.738281 1.25% 0.22%
6/20/2019 973.700012 39601.628906 -1.03% -0.49%
6/21/2019 968.900024 39194.488281 -0.18% -0.44%
6/24/2019 964.599976 39122.960938 0.80% -1.23%
6/25/2019 952.75 39434.941406 0.40% -1.74%
6/26/2019 936.150024 39592.078125 -0.01% 0.97%
6/27/2019 945.200012 39586.410156 -0.48% -1.87%
6/28/2019 927.5 39394.640625 0.74% -2.51%
7/1/2019 904.25 39686.5 0.33% 1.00%
7/2/2019 913.299988 39816.480469 0.06% -0.79%
7/3/2019 906.099976 39839.25 0.17% -0.83%
7/4/2019 898.549988 39908.058594 -0.99% -1.17%
7/5/2019 888.049988 39513.390625 -2.01% -13.45%
7/8/2019 768.599976 38720.570313 0.03% 0.58%
7/9/2019 773.049988 38730.820313 -0.45% -1.95%
7/10/2019 757.950012 38557.039063 0.69% 0.16%
7/11/2019 759.200012 38823.109375 -0.22% -0.94%
7/12/2019 752.099976 38736.230469 0.41% 0.98%
7/15/2019 759.450012 38896.710938 0.60% -1.33%
7/16/2019 749.349976 39131.039063 0.22% 0.35%
7/17/2019 751.950012 39215.640625 -0.81% -8.07%
7/18/2019 691.299988 38897.460938 -1.44% -3.72%
7/19/2019 665.599976 38337.011719 -0.80% 2.24%
7/22/2019 680.5 38031.128906 -0.13% 1.78%
7/23/2019 692.599976 37982.738281 -0.36% -0.87%
7/24/2019 686.549988 37847.648438 -0.04% 1.21%
7/25/2019 694.849976 37830.980469 0.14% -0.77%
7/26/2019 689.5 37882.789063 -0.52% 1.57%
7/29/2019 700.299988 37686.371094 -0.77% 1.69%
7/30/2019 712.150024 37397.238281 0.22% 0.72%
7/31/2019 717.299988 37481.121094 -1.23% -3.65%
8/1/2019 691.150024 37018.320313 0.27% 1.95%
8/2/2019 704.599976 37118.21875 -1.13% 0.41%
8/5/2019 707.5 36699.839844 0.75% 0.59%
8/6/2019 711.650024 36976.851563 -0.77% 4.82%
8/7/2019 745.950012 36690.5 1.74% 0.17%
8/8/2019 747.25 37327.359375 0.68% 0.66%
8/9/2019 752.150024 37581.910156 -1.66% -4.06%
8/13/2019 721.650024 36958.160156 0.96% -1.82%
8/14/2019 708.5 37311.53125 0.10% -1.19%
8/16/2019 700.049988 37350.328125 0.14% 0.31%
8/19/2019 702.200012 37402.488281 -0.20% 0.79%
8/20/2019 707.75 37328.011719 -0.72% -0.97%
 8/21/2019 700.849976 37060.371094 -1.59% -1.11%
8/22/2019 693.099976 36472.929688 0.63% 2.25%
8/23/2019 708.700012 36701.160156 2.16% -0.33%
8/26/2019 706.349976 37494.121094 0.39% -3.59%
8/27/2019 681 37641.269531 -0.50% -0.57%
8/28/2019 677.150024 37451.839844 -1.02% 1.46%
8/29/2019 687.049988 37068.929688 0.71% 0.25%
8/30/2019 688.75 37332.789063 -2.06% -0.64%
9/3/2019 684.349976 36562.910156 0.44% -0.57%
9/4/2019 680.450012 36724.738281 -0.22% 2.07%
9/5/2019 694.549988 36644.421875 0.92% -1.22%
9/6/2019 686.099976 36981.769531 0.44% -0.42%
9/9/2019 683.25 37145.449219 0.34% -0.55%
9/11/2019 679.5 37270.820313 -0.45% -1.30%
9/12/2019 670.650024 37104.28125 0.76% 0.88%
9/13/2019 676.549988 37384.988281 -0.70% 0.76%
9/16/2019 681.700012 37123.308594 -1.73% -0.18%
9/17/2019 680.5 36481.089844 0.23% 2.86%
9/18/2019 699.950012 36563.878906 -1.29% -1.33%
9/19/2019 690.650024 36093.46875 5.32% 3.24%
9/20/2019 713 38014.621094 2.83% 1.38%
9/23/2019 722.849976 39090.03125 0.02% -0.68%
9/24/2019 717.900024 39097.140625 -1.29% -2.37%
9/25/2019 700.900024 38593.519531 1.03% -0.58%
9/26/2019 696.849976 38989.738281 -0.43% 1.66%
9/27/2019 708.400024 38822.570313 -0.40% -0.05%
9/30/2019 708.049988 38667.328125 -0.94% 1.80%
10/1/2019 720.799988 38305.410156 -0.52% -0.11%
10/3/2019 720 38106.871094 -1.14% -1.18%
10/4/2019 711.5 37673.308594 -0.38% 1.38%
10/7/2019 721.299988 37531.980469 1.72% 0.10%
10/9/2019 722.049988 38177.949219 -0.78% 0.25%
10/10/2019 723.849976 37880.398438 0.65% 0.12%
10/11/2019 724.75 38127.078125 0.23% 0.80%
10/14/2019 730.549988 38214.46875 0.76% -0.72%
10/15/2019 725.299988 38506.089844 0.24% 2.48%
10/16/2019 743.299988 38598.988281 1.17% -1.88%
10/17/2019 729.349976 39052.058594 0.63% 0.86%
10/18/2019 735.599976 39298.378906 -0.85% -0.92%
10/22/2019 728.799988 38963.839844 0.24% -1.41%
10/23/2019 718.5 39058.828125 -0.10% -0.02%
10/24/2019 718.349976 39020.390625 0.10% -0.03%
10/25/2019 718.150024 39058.058594 1.98% -0.73%
10/29/2019 712.900024 39831.839844 0.55% -0.29%
10/30/2019 710.799988 40051.871094 0.19% 0.25%
10/31/2019 712.549988 40129.050781 0.09% 1.07%
11/1/2019 720.150024 40165.03125 0.34% -0.81%
 11/4/2019 714.299988 40301.960938 -0.13% -0.65%
11/5/2019 709.650024 40248.230469 0.55% -0.61%
11/6/2019 705.349976 40469.78125 0.45% 0.23%
11/7/2019 706.950012 40653.738281 -0.81% -1.76%
11/8/2019 694.5 40323.609375 0.05% -0.66%
11/11/2019 689.950012 40345.078125 -0.57% -1.09%
11/13/2019 682.400024 40116.058594 0.42% 1.02%
11/14/2019 689.349976 40286.480469 0.17% 0.49%
11/15/2019 692.75 40356.691406 -0.18% 1.58%
11/18/2019 703.700012 40284.191406 0.46% 0.21%
11/19/2019 705.200012 40469.699219 0.45% 1.58%
11/20/2019 716.349976 40651.640625 -0.19% -0.87%
11/21/2019 710.099976 40575.171875 -0.53% -0.34%
11/22/2019 707.700012 40359.410156 1.31% 1.02%
11/25/2019 714.900024 40889.230469 -0.17% -2.56%
11/26/2019 696.599976 40821.300781 0.49% 0.75%
11/27/2019 701.849976 41020.609375 0.27% 0.17%
11/28/2019 703.049988 41130.171875 -0.82% -0.50%
11/29/2019 699.5 40793.808594 0.02% 0.83%
12/2/2019 705.299988 40802.171875 -0.31% 1.65%
12/3/2019 716.950012 40675.449219 0.43% 4.25%
12/4/2019 747.450012 40850.289063 -0.17% 2.20%
12/5/2019 763.900024 40779.589844 -0.82% -3.05%
12/6/2019 740.599976 40445.148438 0.10% 1.19%
12/9/2019 749.450012 40487.429688 -0.61% -1.51%
12/10/2019 738.099976 40239.878906 0.43% 2.36%
12/11/2019 755.549988 40412.570313 0.42% -0.47%
12/12/2019 752 40581.710938 1.05% 1.58%
12/13/2019 763.849976 41009.710938 -0.17% -0.48%
12/16/2019 760.150024 40938.71875 1.01% 1.66%
12/17/2019 772.75 41352.171875 0.50% -0.65%
12/18/2019 767.700012 41558.570313 0.28% -0.37%
12/19/2019 764.849976 41673.921875 0.02% 2.46%
12/20/2019 783.700012 41681.539063 -0.09% -0.91%
12/23/2019 776.549988 41642.660156 -0.44% -0.10%
12/24/2019 775.799988 41461.261719 -0.72% 2.17%
12/26/2019 792.599976 41163.761719 1.00% -0.70%
12/27/2019 787.049988 41575.140625 -0.04% 1.61%
12/30/2019 799.700012 41558 -0.73% -0.06%
12/31/2019 799.200012 41253.738281 0.90% 1.75%
1/2/2020 813.200012 41626.640625 -0.39% 0.31%
1/3/2020 815.700012 41464.609375 -1.90% 1.05%
1/6/2020 824.299988 40676.628906 0.47% 2.78%
1/7/2020 847.25 40869.46875 -0.13% 0.49%
1/8/2020 851.400024 40817.738281 1.55% -2.85%
1/9/2020 827.099976 41452.351563 0.36% 0.42%
1/10/2020 830.599976 41599.71875 0.62% 1.10%
1/13/2020 839.75 41859.691406 0.22% 2.86%
1/14/2020 863.75 41952.628906 -0.19% 2.73%
1/15/2020 887.299988 41872.730469 0.14% 1.12%
1/16/2020 897.25 41932.558594 0.03% -1.60%
1/17/2020 882.849976 41945.371094 -0.99% 1.09%
1/20/2020 892.5 41528.910156 -0.49% 0.49%
1/21/2020 896.849976 41323.808594 -0.50% 1.03%
1/22/2020 906.099976 41115.378906 0.66% -0.68%
1/23/2020 899.900024 41386.398438 0.55% -0.83%
1/24/2020 892.450012 41613.191406 -1.10% -0.90%
1/27/2020 884.400024 41155.121094 -0.46% -0.97%
1/28/2020 875.799988 40966.859375 0.57% 1.23%
1/29/2020 886.599976 41198.660156 -0.69% 0.19%
1/30/2020 888.25 40913.820313 -0.47% -0.04%
1/31/2020 887.900024 40723.488281 -2.09% 1.62%
2/3/2020 902.299988 39872.308594 2.30% 0.50%
2/4/2020 906.799988 40789.378906 0.87% 0.31%
2/5/2020 909.650024 41142.660156 0.40% -0.74%
2/6/2020 902.950012 41306.03125 -0.40% 2.08%
2/7/2020 921.700012 41141.851563 -0.39% -0.24%
2/10/2020 919.450012 40979.621094 0.58% 0.87%
2/11/2020 927.450012 41216.140625 0.85% -0.58%
2/12/2020 922.099976 41565.898438 -0.26% 1.46%
2/13/2020 935.599976 41459.789063 -0.49% 2.56%
2/14/2020 959.549988 41257.738281 -0.49% 2.32%
2/17/2020 981.849976 41055.691406 -0.39% 1.51%
2/18/2020 996.700012 40894.378906 1.05% 1.68%
2/19/2020 1013.450012 41323 -0.37% 3.45%
2/20/2020 1048.449951 41170.121094 -1.96% -3.20%
2/24/2020 1014.900024 40363.230469 -0.20% 3.57%
2/25/2020 1051.099976 40281.199219 -0.97% -2.16%
2/26/2020 1028.400024 39888.960938 -0.36% -4.27%
2/27/2020 984.5 39745.660156 -3.64% -3.20%
2/28/2020 952.950012 38297.289063 -0.40% 5.49%
3/2/2020 1005.299988 38144.019531 1.26% -1.50%
3/3/2020 990.200012 38623.699219 -0.55% 0.06%
3/4/2020 990.799988 38409.480469 0.16% -2.96%
3/5/2020 961.5 38470.609375 -2.32% 1.56%
3/6/2020 976.5 37576.621094 -5.17% 0.00%
3/9/2020 976.5 35634.949219 0.18% -8.60%
3/11/2020 892.549988 35697.398438 -8.18% -8.66%
3/12/2020 815.25 32778.140625 4.04% 5.75%
3/13/2020 862.099976 34103.480469 -7.96% -2.23%
3/16/2020 842.849976 31390.070313 -2.58% 1.26%
3/17/2020 853.450012 30579.089844 -5.59% -5.44%
3/18/2020 807.049988 28869.509766 -2.01% -10.63%
3/19/2020 721.25 28288.230469 5.75% 17.62%
3/20/2020 848.299988 29915.960938 -13.15% -13.66%
3/23/2020 732.450012 25981.240234 2.67% 8.24%
3/24/2020 792.799988 26674.029297 6.98% 4.29%
3/25/2020 826.849976 28535.779297 4.94% 1.38%
3/26/2020 838.25 29946.769531 -0.44% -1.13%
3/27/2020 828.75 29815.589844 -4.61% 2.26%
3/30/2020 847.450012 28440.320313 3.62% -2.26%
3/31/2020 828.299988 29468.490234 -4.08% -9.04%
4/1/2020 753.450012 28265.310547 -2.39% -7.04%
4/3/2020 700.400024 27590.949219 8.97% 5.04%
4/7/2020 735.700012 30067.210938 -0.58% -0.50%
4/8/2020 732 29893.960938 4.23% 0.33%
4/9/2020 734.450012 31159.619141 -1.51% 0.62%
4/13/2020 739 30690.019531 -1.01% 4.40%
4/15/2020 771.549988 30379.810547 0.73% 0.76%
4/16/2020 777.400024 30602.609375 3.22% -3.14%
4/17/2020 753 31588.720703 0.19% 3.83%
4/20/2020 781.849976 31648 -3.20% -5.85%
4/21/2020 736.150024 30636.710938 2.42% -0.63%
4/22/2020 731.5 31379.550781 1.54% 4.57%
4/23/2020 764.900024 31863.080078 -1.68% 2.07%
4/24/2020 780.700012 31327.220703 1.33% 12.90%
4/27/2020 881.400024 31743.080078 1.17% -1.54%
4/28/2020 867.849976 32114.519531 1.89% 1.61%
4/29/2020 881.799988 32720.160156 3.05% 3.80%
4/30/2020 915.299988 33717.621094 -5.94% -1.34%
5/4/2020 903.049988 31715.349609 -0.83% -3.17%
5/5/2020 874.400024 31453.509766 0.74% 3.77%
5/6/2020 907.349976 31685.75 -0.76% -3.24%
5/7/2020 877.950012 31443.380859 0.63% 1.50%
5/8/2020 891.099976 31642.699219 -0.26% -0.06%
5/11/2020 890.599976 31561.220703 -0.60% -0.35%
5/12/2020 887.450012 31371.119141 2.03% -0.26%
5/13/2020 885.150024 32008.609375 -2.77% -5.58%
5/14/2020 835.799988 31122.890625 -0.08% 1.72%
5/15/2020 850.150024 31097.730469 -3.44% 3.23%
5/18/2020 877.599976 30028.980469 0.56% 4.73%
5/19/2020 919.099976 30196.169922 2.06% -1.63%
5/20/2020 904.150024 30818.609375 0.37% -2.46%
5/21/2020 881.950012 30932.900391 -0.84% 0.96%
5/22/2020 890.450012 30672.589844 -0.21% -0.98%
5/26/2020 881.700012 30609.300781 3.25% 1.04%
5/27/2020 890.900024 31605.220703 1.88% 0.45%
5/28/2020 894.950012 32200.589844 0.69% -0.11%
5/29/2020 894 32424.099609 2.71% -0.31%
6/1/2020 891.200012 33303.519531 1.57% 3.28%
6/2/2020 920.450012 33825.53125 0.84% -1.30%
 6/3/2020 908.5 34109.539063 -0.38% 2.89%
6/4/2020 934.75 33980.699219 0.90% -1.69%
6/5/2020 918.950012 34287.238281 0.24% -0.06%
6/8/2020 918.400024 34370.578125 -1.20% -2.30%
6/9/2020 897.25 33956.691406 0.86% 1.33%
6/10/2020 909.200012 34247.050781 -2.07% 1.09%
6/11/2020 919.150024 33538.371094 0.72% -0.61%
6/12/2020 913.549988 33780.890625 -1.63% 1.03%
6/15/2020 922.950012 33228.800781 1.13% -1.16%
6/16/2020 912.200012 33605.21875 -0.29% -0.66%
6/17/2020 906.150024 33507.921875 2.09% 0.14%
6/18/2020 907.400024 34208.050781 1.53% 0.59%
6/19/2020 912.75 34731.730469 0.52% -0.36%
6/22/2020 909.450012 34911.320313 1.49% 2.00%
6/23/2020 927.599976 35430.429688 -1.58% -0.50%
6/24/2020 923 34868.980469 -0.08% -0.69%
6/25/2020 916.599976 34842.101563 0.94% 3.54%
6/26/2020 949.049988 35171.269531 -0.60% -1.98%
6/29/2020 930.299988 34961.519531 -0.13% -0.46%
6/30/2020 926.049988 34915.800781 1.43% -0.23%
7/1/2020 923.900024 35414.449219 1.21% 1.48%
7/2/2020 937.549988 35843.699219 0.50% 0.86%
7/3/2020 945.599976 36021.421875 1.29% 1.58%
7/6/2020 960.549988 36487.28125 0.51% 2.21%
7/7/2020 981.75 36674.519531 -0.94% 0.63%
7/8/2020 987.900024 36329.011719 1.12% 0.01%
7/9/2020 987.950012 36737.691406 -0.39% 2.06%
7/10/2020 1008.299988 36594.328125 0.27% -0.04%
7/13/2020 1007.900024 36693.691406 -1.80% -2.97%
7/14/2020 977.950012 36033.058594 0.05% -0.22%
7/15/2020 975.75 36051.808594 1.16% 3.33%
7/16/2020 1008.25 36471.679688 1.50% 1.41%
7/17/2020 1022.450012 37020.140625 1.08% 0.53%
7/20/2020 1027.900024 37418.988281 1.37% -1.95%
7/21/2020 1007.849976 37930.328125 -0.16% 0.59%
7/22/2020 1013.75 37871.519531 0.71% -0.27%
7/23/2020 1011.049988 38140.46875 -0.03% 1.09%
7/24/2020 1022.049988 38128.898438 -0.51% 2.72%
7/27/2020 1049.900024 37934.730469 1.47% 0.21%
7/28/2020 1052.099976 38492.949219 -1.10% 1.00%
7/29/2020 1062.650024 38071.128906 -0.88% 1.76%
7/30/2020 1081.300049 37736.070313 -0.34% 0.19%
7/31/2020 1083.349976 37606.890625 -1.77% 4.01%
8/3/2020 1126.75 36939.601563 2.03% -0.07%
8/4/2020 1125.949951 37687.910156 -0.07% 1.29%
8/5/2020 1140.5 37663.328125 0.96% 0.21%
8/6/2020 1142.849976 38025.449219 0.04% 0.79%
 8/7/2020 1151.900024 38040.570313 0.37% -0.78%
8/10/2020 1142.900024 38182.078125 0.59% -2.29%
8/11/2020 1116.75 38407.011719 -0.10% 1.47%
8/12/2020 1133.150024 38369.628906 -0.15% 1.58%
8/13/2020 1151 38310.488281 -1.13% -1.30%
8/14/2020 1136 37877.339844 0.46% 2.37%
8/17/2020 1162.900024 38050.78125 1.26% 0.31%
8/18/2020 1166.550049 38528.320313 0.22% 0.48%
8/19/2020 1172.199951 38614.789063 -1.02% 0.24%
8/20/2020 1175 38220.390625 0.56% -1.14%
8/21/2020 1161.650024 38434.71875 0.95% -0.74%
8/24/2020 1153.099976 38799.078125 0.12% -1.34%
8/25/2020 1137.650024 38843.878906 0.59% 3.10%
8/26/2020 1172.900024 39073.921875 0.10% -1.94%
8/27/2020 1150.099976 39113.46875 0.90% 3.00%
8/28/2020 1184.550049 39467.308594 -2.13% -2.42%
8/31/2020 1155.900024 38628.289063 0.71% -1.19%
9/1/2020 1142.099976 38900.800781 0.48% 4.67%
9/2/2020 1195.449951 39086.03125 -0.24% 1.07%
9/3/2020 1208.199951 38990.941406 -1.63% -1.24%
9/4/2020 1193.199951 38357.179688 0.16% 1.13%
9/7/2020 1206.699951 38417.230469 -0.14% -1.69%
9/8/2020 1186.25 38365.351563 -0.45% -1.13%
9/9/2020 1172.900024 38193.921875 1.69% 0.32%
9/10/2020 1176.650024 38840.320313 0.04% 0.44%
9/11/2020 1181.800049 38854.550781 -0.25% 3.36%
9/14/2020 1221.5 38756.628906 0.74% 2.50%
9/15/2020 1252.050049 39044.351563 0.66% 0.75%
9/16/2020 1261.449951 39302.851563 -0.82% 1.01%
9/17/2020 1274.25 38979.851563 -0.34% -0.04%
9/18/2020 1273.75 38845.820313 -2.09% -0.27%
9/21/2020 1270.349976 38034.140625 -0.79% 3.04%
9/22/2020 1308.949951 37734.078125 -0.17% -0.85%
9/23/2020 1297.849976 37668.421875 -2.96% -3.79%
9/24/2020 1248.599976 36553.601563 2.28% 1.59%
9/25/2020 1268.400024 37388.660156 1.59% 1.36%
9/28/2020 1285.650024 37981.628906 -0.02% 2.94%
9/29/2020 1323.449951 37973.21875 0.25% 1.11%
9/30/2020 1338.150024 38067.929688 1.65% -0.08%
10/1/2020 1337.050049 38697.050781 0.71% 0.88%
10/5/2020 1348.800049 38973.699219 1.54% 1.78%
10/6/2020 1372.800049 39574.570313 0.77% 1.15%
10/7/2020 1388.650024 39878.949219 0.76% 5.29%
10/8/2020 1462.150024 40182.671875 0.81% 2.88%
10/9/2020 1504.199951 40509.488281 0.21% 3.98%
10/12/2020 1564.099976 40593.800781 0.08% 1.42%
10/13/2020 1586.25 40625.511719 0.42% -2.06%
10/14/2020 1553.5 40794.738281 -2.61% -8.11%
10/15/2020 1427.550049 39728.410156 0.64% -6.75%
10/16/2020 1331.199951 39982.980469 1.12% 0.76%
10/19/2020 1341.300049 40431.601563 0.28% 6.45%
10/20/2020 1427.849976 40544.371094 0.40% -5.03%
10/21/2020 1356 40707.308594 -0.37% 2.12%
10/22/2020 1384.75 40558.488281 0.31% 0.66%
10/23/2020 1393.900024 40685.5 -1.33% -0.34%
10/26/2020 1389.099976 40145.5 0.94% -0.22%
10/27/2020 1386.050049 40522.101563 -1.48% -4.22%
10/28/2020 1327.599976 39922.460938 -0.43% -0.70%
10/29/2020 1318.25 39749.851563 -0.34% 0.66%
10/30/2020 1326.900024 39614.070313 0.36% -0.73%
11/2/2020 1317.199951 39757.578125 1.27% 0.00%
11/3/2020 1317.199951 40261.128906 0.88% 1.39%
11/4/2020 1335.449951 40616.140625 1.78% 1.69%
11/5/2020 1358.050049 41340.160156 1.34% -0.14%
11/6/2020 1356.199951 41893.058594 1.68% 1.05%
11/9/2020 1370.5 42597.429688 1.60% -4.28%
11/10/2020 1311.849976 43277.648438 0.73% 1.38%
11/11/2020 1329.949951 43593.671875 -0.54% 0.89%
11/12/2020 1341.75 43357.191406 0.20% 0.40%
11/13/2020 1347.150024 43443 1.17% -0.50%
11/17/2020 1340.349976 43952.710938 0.52% -0.47%
11/18/2020 1334.050049 44180.050781 -1.31% -1.11%
11/19/2020 1319.25 43599.960938 0.65% 2.77%
11/20/2020 1355.75 43882.25 0.44% 2.95%
11/23/2020 1395.75 44077.148438 1.01% 1.00%
11/24/2020 1409.650024 44523.019531 -1.56% -2.38%
11/25/2020 1376.150024 43828.101563 0.98% 1.28%
11/26/2020 1393.75 44259.738281 -0.25% 1.70%
11/27/2020 1417.449951 44149.71875
SUMMARY OUTPUT

Regression Statistics
Multiple R 0.3786575377
R Square 0.1433815308
Adjusted R Square 0.142211287
Standard Error 0.0234216597
Observations 734

ANOVA
df SS MS F Significance F
Regression 1 0.06721283156 0.0672128 122.52279 1.941E-26
Residual 732 0.4015562712 0.0005486
Total 733 0.46876910276

Coefficients Standard Error t Stat P-value Lower 95% Upper 95%Lower 95.0%
Intercept 0.0012980653 0.00086506177 1.5005464 0.1339041 -0.0004 0.0029964 -0.0004
Sensex 0.7084909327 0.06400676332 11.069001 1.941E-26 0.5828322 0.8341497 0.5828322
Upper 95.0%
0.0029964
0.8341497
 WACC Calculations

Market Returns Risk free rate

Date Last Price Return (over 10 year period) Date
31-Dec-19 41,254 8.98% 31 Dec 19
31-Dec-18 36,068 14.10% 31 Dec 18
31-Dec-17 34,056 5.36% 31 Dec 17
31-Dec-16 26,626 7.05% 31 Dec 16
31-Dec-15 25,838 10.81% 31 Dec 15
31-Dec-14 21,171 12.54% 31 Dec 14
31-Dec-13 21,483 14.51% 31 Dec 13
31-Dec-12 19,423 19.12% 31 Dec 12
31-Dec-11 15,454 17.11% 31 Dec 11
31-Dec-10 20,509 17.84% 31 Dec 10
31-Dec-09 17,464 13.31% 31 Dec 09
Average 12.79% Average

Average Rf Average Rp Beta

7.52% 5.27% 0.71
Risk free rate CAPM calculation
Month End Return (%) Date Rm Rf Rp= Rm-Rf
6.554 2019 8.98% 6.55% 2.42%
6.516 2018 14.10% 6.52% 7.58%
7.758 2017 5.36% 7.76% -2.40%
7.857 2016 7.05% 7.86% -0.81%
8.825 2015 10.81% 8.83% 1.99%
8.049 2014 12.54% 8.05% 4.49%
8.572 2013 14.51% 8.57% 5.94%
7.913 2012 19.12% 7.91% 11.21%
7.679 2011 17.11% 7.68% 9.43%
5.26 2010 17.84% 5.26% 12.58%
7.791 2009 13.31% 7.79% 5.52%
7.52
Particulars Average numbers Comments Cost of debt
Sales growth rate 11.31% CAGR Cost of equity
Operating margin(%) 14.03% debt
Historical equity
Expected
Sales/(NB+CWIP) 5.84 value
Historical
long term wt of debt
Depreciation/ Sales 3.09% value
GDP growth wt of equity
Terminal growth rate 4% rate
Discount rate 11.23% WACC

3/31/2016 3/31/2017 3/31/2018 3/31/2019

Sales 4673.00 5236.40 5462.80 7021.50
Operating profit 821.00 704.50 740.50 1064.50
OPM 0.18 0.13 0.14 0.15

Cash from operations 421.40 653.50 564.40 630.50

Sales/ (NB+CWIP) 3.94 5.03 5.66 7.05
NB+CWIP 1185.20 1041.20 966.00 996.60
Depreciation 165.80 185.80 171.50 164.10
Depreciation/ Sales 0.04 0.04 0.03 0.02
Capex 760.10 41.80 96.30 194.70
FCFF -338.70 611.70 468.10 435.80

Projected cashflows
3/31/2021 3/31/2022 3/31/2023 3/31/2024
FCFF 485.75 465.66 551.96 654.25

Fair value by DCF(Rs. Cr) ₹11,052.78

Price per share ₹435.18

 0
11.26%
0.5
164.6
0.00
1.00

3/31/2020 3/31/2021 3/31/2022 3/31/2023 3/31/2024 Terminal value

7984.30 9203.21 10908.78 12930.44 15326.76
7794.50 1311.95 1555.08 1843.27 2184.88
0.14 0.14 0.14 0.14 0.14

825.10 923.91 1095.14 1298.09 1538.66

5.46 5.84 5.84 5.84 5.84 9411.18
1422.80 1576.37 1868.51 2214.79 2625.24
275.40 284.59 337.34 399.85 473.96
0.04 0.03 0.03 0.03 0.03
701.60 438.17 629.48 746.13 884.41
123.50 485.75 465.66 551.96 654.25

Terminal value
9411.18
Valuations as on
31st March 2019 Shares Outstanding Share Price Market Cap EV
TCS 3,752,384,706.00 2001.65 751,096 741,064
Infosys 4,472,252,710.00 743.85 332,669 307,872
HCL Technologies 1,356,278,868.00 543.73 73,745 141,247
Wipro 6,033,935,388.00 254.8 153,745 148,446

Average

All figures except

Shares outstanding,
Share price, are in
Cr. Rs.

Averages Mindtree
EV/Sales 4.69 Sales 7,021.50
EV/EBITDA 14.35 EBITDA 1,153.70
EV/EBIT 15.52 EBIT 989.60
Sales EBITDA EBIT Net Profit EV/Sales EV/EBITDA
123,170.00 42,591.00 40,875.00 30,065.00 6.02 17.40
73,107.00 21,526.00 19,927.00 14,702.00 4.21 14.30
26,012.00 11,223.00 9,947.00 8,185.00 5.43 12.59
48,123.80 11,329.70 10,395.40 7,614.00 3.08 13.10

4.69 14.35

EV Weights Totals
32,900.31 0.1 3,290.03 Weights can be changed later on
16,552.66 0.3 4,965.80
15,353.64 0.6 9,212.19

EV of Mindtree 17,468.01
EV/EBIT P/E
18.13 24.98
15.45 22.63
14.20 9.01
14.28 20.19

15.52 19.20
 Open Low High Close
EV/EBITDA 12.59 12.59 17.4 17.4
EVSALES 3.08 3.08 6.02 6.02
EV/EBIT 14.2 14.2 18.3 18.3
P/E 9.01 9.01 24.98 24.98
52 wk hi/lo 692 692 1605.85 1605.85

Valuation Summary ( footbal field analysis)

10000

acquisition stock price 979

1000

100

10

1
EV/EBITDA EVSALES EV/EBIT P/E 52 w
ld analysis)

P/E 52 wk hi/lo