{"id":23495,"date":"2025-12-29T20:06:35","date_gmt":"2025-12-29T14:36:35","guid":{"rendered":"http:\/\/www.sachdevajk.in\/?p=23495"},"modified":"2025-12-29T20:06:35","modified_gmt":"2025-12-29T14:36:35","slug":"topic-relationship-of-tata-consultancy-services-with-nifty-author-c-s-tanya","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=23495","title":{"rendered":"Topic: Relationship of Tata Consultancy Services with NIFTY Author: C S Tanya"},"content":{"rendered":"<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Introduction:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Tata Consultancy Services (TCS) is a leading global provider of IT services, consulting, and business solutions. As the flagship company of the Tata Group\u2014India\u2019s largest business conglomerate\u2014TCS ranks among the world\u2019s largest and most recognized IT service companies. With operations spanning 55 countries, it is a key constituent of the NIFTY 50 index. In the Indian equity market, TCS is widely regarded as a blue-chip stock, valued for its steady growth and consistent dividend payouts, although its performance is influenced by global IT demand and fluctuations in the USD\u2013INR exchange rate.<b><i><\/i><\/b><\/span><\/p>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Objective:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">The main aim of this analysis is to:<\/span><\/p>\n<ul style=\"margin-top: 0cm\" type=\"disc\">\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Estimate the beta of TCS to measure its volatility in relation to the broader Indian market (NIFTY 50).<\/span><\/li>\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Evaluate the stock\u2019s risk\u2013return characteristics using weekly returns data.<\/span><\/li>\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Calculate the coefficient of determination to assess the extent to which market movements explain TCS\u2019s price fluctuations, as opposed to firm-specific factors.<\/span><\/li>\n<\/ul>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Literature Review:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">In finance, the Capital Asset Pricing Model (CAPM) is employed to estimate the theoretically required rate of return on an asset. A central component of CAPM is <b>beta<\/b>, which measures the asset\u2019s sensitivity to movements in the overall market.<\/span><\/p>\n<ul style=\"margin-top: 0cm\" type=\"disc\">\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">: Represents the &#8220;Systematic Risk&#8221; (market risk) that cannot be diversified away.<\/span>\n<ul style=\"margin-top: 0cm\" type=\"circle\">\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta = 1: The stock moves in sync with the market.<\/span><\/li>\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta &gt; 1: The stock is &#8220;Aggressive&#8221; (more volatile than the market).<\/span><\/li>\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta &lt; 1: The stock is &#8220;Defensive&#8221; (less volatile than the market).<\/span><\/li>\n<\/ul>\n<\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">R Squared<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">: Indicates the percentage of a fund or security&#8217;s movements that can be explained by movements in its benchmark index. A higher suggests a stronger correlation with the market.<\/span><\/li>\n<\/ul>\n<p class=\"MsoListParagraphCxSpFirst\" style=\"text-indent: -18.0pt\"><!-- [if !supportLists]--><span style=\"font-size: 10.0pt;line-height: 107%;font-family: Symbol\">\u00b7<span style=\"font-size: 7pt;line-height: normal;font-family: 'Times New Roman'\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span><\/span><!--[endif]--><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Regression Equation:<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> The relationship is modeled as:<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">\u00a0<\/span><\/p>\n<p class=\"MsoListParagraphCxSpMiddle\" style=\"text-align: center\" align=\"center\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Ri = Alpha + Beta (Rm) + Epsilon<\/span><\/i><\/p>\n<p class=\"MsoListParagraphCxSpLast\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"><br \/>Where <i>Ri<\/i> is the stock return, <i>Rm<\/i> is the market return, alpha is the intercept (excess return), and epsilon is the error term.<\/span><\/p>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Data Collection:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">The data utilized for this study consists of weekly closing prices and calculated weekly returns for:<\/span><\/p>\n<ul style=\"margin-top: 0cm\" type=\"disc\">\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Dependent Variable (Y):<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> TCS Equity Returns.<\/span><\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Independent Variable (X):<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> NIFTY 50 Index Returns.<\/span><\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Time Period:<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> December 2024 to November 2025 (approx. 47-48 observations).<\/span><\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Source:<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> National Stock Exchange (NSE) historical data (as provided in the CSV).<\/span><\/li>\n<\/ul>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"><br \/>Data Analysis:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Based on the regression analysis performed on the dataset, here are the key findings:<\/span><\/p>\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">A. Descriptive Statistics<\/span><\/b><\/p>\n<table class=\"MsoNormalTable\" style=\"border: solid windowtext 1.0pt\" border=\"1\" cellspacing=\"3\" cellpadding=\"0\">\n<thead>\n<tr>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Metric<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">TCS (Weekly)<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">NIFTY 50 (Weekly)<\/span><\/p>\n<\/td>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Mean Return<\/span><\/b><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">0.813%<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">-0.102%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Standard Deviation (Risk)<\/span><\/b><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">3.383%<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">1.899%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Minimum Return<\/span><\/b><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">-6.279%<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">-5.036%<\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Maximum Return<\/span><\/b><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">9.317%<\/span><\/p>\n<\/td>\n<td style=\"border: solid windowtext 1.0pt;padding: .75pt .75pt .75pt .75pt\">\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">5.006%<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul style=\"margin-top: 0cm\" type=\"disc\">\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Interpretation:<\/span><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> During this period, TCS provided a higher average weekly return (0.81%) compared to the Nifty 50, which saw a slight decline. However, TCS also exhibited higher volatility (Standard Deviation of 3.38%) compared to the market (1.90%).<\/span><\/li>\n<\/ul>\n<p class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">B. Regression Results<\/span><\/b><\/p>\n<ul style=\"margin-top: 0cm\" type=\"disc\">\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta: 1.153<\/span><\/b>\n<ul style=\"margin-top: 0cm\" type=\"circle\">\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">The Beta is greater than 1, indicating that TCS was 15.3% more volatile than the Nifty 50 during this period. For every 1% move in the Nifty 50, TCS is expected to move by ~1.15%.<\/span><\/li>\n<\/ul>\n<\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">R Squared: 0.419 (41.9%)<\/span><\/b>\n<ul style=\"margin-top: 0cm\" type=\"circle\">\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">This indicates that approximately 42% of the variations in TCS returns are explained by the market (Nifty 50). The remaining 58% is attributed to unsystematic risk (company-specific factors like earnings reports, deal wins, or sector-specific trends).<\/span><\/li>\n<\/ul>\n<\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Intercept: 0.93%<\/span><\/b>\n<ul style=\"margin-top: 0cm\" type=\"circle\">\n<li class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">The positive alpha suggests that TCS generated an &#8220;excess return&#8221; of 0.93% per week over what was predicted by its Beta alone.<\/span><\/li>\n<\/ul>\n<\/li>\n<li class=\"MsoNormal\"><b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Regression Equation:<\/span><\/b><\/li>\n<\/ul>\n<p class=\"MsoNormal\" style=\"margin-left: 36.0pt;text-align: center\" align=\"center\"><!-- [if gte vml 1]&gt;--><\/p>\n<p><!-- [if !vml]--><span style=\"position: absolute;z-index: 251659264;left: 0px;margin-left: 234px;margin-top: 572px;width: 352px;height: 37px\"><img loading=\"lazy\" decoding=\"async\" src=\"\/Users\/Tanya\/AppData\/Local\/Temp\/msohtmlclip1\/01\/clip_image001.png\" width=\"282\" height=\"30\" \/><\/span><!--[endif]--><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">TCS (Y) = 0.93 + 1.153 (NIFTY 550 X)<\/span><\/i><\/p>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Conclusion:<\/span><\/i><\/b><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">The analysis indicates that TCS behaved as an aggressive stock during the 2024\u20132025 period, with a beta of 1.15. Although it exhibited higher risk compared to the market index, it also generated superior average weekly returns. The relatively moderate coefficient of determination (R\u00b2 = 0.419) suggests that while overall market movements influence the stock, company-specific factors and dynamics within the IT sector play a more significant role in driving its price. From an investment perspective, TCS would be a suitable choice for portfolios focused on growth, provided investors are comfortable with slightly higher-than-market volatility.<\/span><\/p>\n<p class=\"MsoNormal\"><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">\u00a0<\/span><\/p>\n<p class=\"MsoNormal\"><b><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">References:<br \/><\/span><\/i><\/b><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">For your further studies, these resources are excellent for mastering these fundamentals:<\/span><\/p>\n<p>\u00a0<\/p>\n<ol style=\"margin-top: 0cm\" start=\"1\" type=\"1\">\n<li class=\"MsoNormal\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Investopedia &#8211; Beta: <\/span><\/i><a href=\"https:\/\/www.investopedia.com\/terms\/b\/beta.asp\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Understanding Beta<\/span><\/i><\/a><i><\/i><\/li>\n<li class=\"MsoNormal\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">NSE India: <\/span><\/i><a href=\"https:\/\/www.google.com\/search?q=https:\/\/www.nseindia.com\/products\/content\/indices\/indices.htm\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">NIFTY 50 Methodology<\/span><\/i><\/a><i><\/i><\/li>\n<li class=\"MsoNormal\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Damodaran Online: <\/span><\/i><a href=\"http:\/\/pages.stern.nyu.edu\/~adamodar\/\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Beta and Cost of Capital<\/span><\/i><\/a><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\"> (The &#8220;Gold Standard&#8221; for valuation by Prof. Aswath Damodaran).<\/span><\/i><\/li>\n<li class=\"MsoNormal\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">TCS Investor Relations: <\/span><\/i><a href=\"https:\/\/www.tcs.com\/investor-relations\" target=\"_blank\" rel=\"noopener\"><i><span style=\"font-size: 12.0pt;line-height: 107%;font-family: 'Palatino Linotype',serif\">Quarterly Reports and Financials<\/span><\/i><\/a><i><\/i><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Introduction:Tata Consultancy Services (TCS) is a leading global provider of IT services, consulting, and business solutions. As the flagship company of the Tata Group\u2014India\u2019s largest business conglomerate\u2014TCS ranks among the world\u2019s largest and most recognized IT service companies. With operations spanning 55 countries, it is a key constituent of the NIFTY 50 index. In the&hellip; <a class=\"more-link\" href=\"http:\/\/www.sachdevajk.in\/?p=23495\">Continue reading <span class=\"screen-reader-text\">Topic: Relationship of Tata Consultancy Services with NIFTY Author: C S Tanya<\/span><\/a><\/p>\n","protected":false},"author":140054,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-23495","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/users\/140054"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=23495"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23495\/revisions"}],"predecessor-version":[{"id":23496,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/23495\/revisions\/23496"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=23495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=23495"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=23495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}