{"id":19221,"date":"2023-12-26T08:52:52","date_gmt":"2023-12-26T03:22:52","guid":{"rendered":"http:\/\/www.sachdevajk.in\/?p=19221"},"modified":"2023-12-26T08:52:52","modified_gmt":"2023-12-26T03:22:52","slug":"description-between-relation-between-bse-sensex-index-and-tech-mahindra-limited","status":"publish","type":"post","link":"http:\/\/www.sachdevajk.in\/?p=19221","title":{"rendered":"Description between relation between BSE SENSEX INDEX AND TECH MAHINDRA LIMITED"},"content":{"rendered":"<p><strong>TITLE :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/strong>Description between relation between \u00a0BSE SENSEX INDEX AND TECH MAHINDRA LIMITED<\/p>\n<p>\u00a0<\/p>\n<p><strong><u>AUTHOR:<\/u><\/strong> \u00a0\u00a0\u00a0\u00a0 VISHESH TIPLE ( FINANCE- 1) \u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n<p>21230023170<\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><u>INTRODUCTION<\/u><\/strong>:\u00a0\u00a0\u00a0 Tech Mahindra is an Indian multinational information technology services and consulting company. Part of the Mahindra Group, the company is headquartered in Pune and has its registered office in Mumbai. Tech Mahindra is a US$6.0 billion company with over 148,000 employees across 90 countries. The company was ranked\u00a0 in India&#8217;s IT firms and overall No. 47 on Fortune India 500 list for 2019. On 25 June 2013, Tech Mahindra announced the completion of a merger with Mahindra Satyam. Tech Mahindra is one of the top Big Tech (India) companies. Tech Mahindra has 1,262 active clients as of June 2022.<\/p>\n<p>\u00a0<\/p>\n<p><strong><u>OBJECTIVE OF THE\u00a0 REPORT<\/u><\/strong><strong> \u2013 <\/strong><\/p>\n<p>To Calculate Beta and its significance of the equity stock of <strong><u>TECH MAHINDRA LIMITED.<\/u><\/strong><\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><u>VIEWS\u00a0 and REVIEWS :<\/u><\/strong><\/p>\n<p>The tagline of Tech Mahindra is \u201cCONNECTED WORLD. CONNECTED EXPERIENCES.\u201d<\/p>\n<p>\u00a0<\/p>\n<p>ANAND MAHINDRA The CEO of Tech Mahindra left us with following sayings which indicate the core values of the company<\/p>\n<ul>\n<li>\u201cMy aspiration is that M&amp;M become one of the most customer-centric organizations in the world. If we focus on understanding our customers, we will be able to develop customer-centric innovations.\u201d<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<ul>\n<li>\u201cAnyone who makes time frames beyond tomorrow probably isn&#8217;t pushing himself hard enough.\u201d\n<p><\/li>\n<\/ul>\n<p><strong><u>PROCEDURE FOR DATA COLLECTION<\/u><\/strong><\/p>\n<p>First I logged on to BSE official website <a href=\"http:\/\/www.BSEindia.com\">www.BSEindia.com<\/a>. Then I clicked on historical data via (<a href=\"https:\/\/www.bseindia.com\/Indices\/IndexArchiveData.html\">https:\/\/www.bseindia.com\/Indices\/IndexArchiveData.html<\/a>). Then I selected the period from 01<sup>st<\/sup>\u00a0 Nov 2022 to 31<sup>st<\/sup> Oct 2023 then clicked apply and downloaded the CSV file of the price of the BSE index.<\/p>\n<p>Similar procedure is followed for obtaining the data of data of Tech Mahindra limited for the period 01<sup>st<\/sup>\u00a0 Nov 2022 to 31<sup>st<\/sup> Oct 2023.<\/p>\n<p>\u00a0<\/p>\n<p>After downloading the CSV\u00a0 Files of both the\u00a0 BSE index and Tech Mahindra share price I proceeded to calculate beta of the stock of Tech Mahindra limited.<\/p>\n<p>\u00a0<\/p>\n<p><strong><u>PROCEDURE FOR DATA ANALYSIS<\/u><\/strong><\/p>\n<p>For calculating the weekly returns of the stock and the bse index, I selected the closing price of every last day of the trading week i.e. Friday<\/p>\n<p>For arriving at the last day of the week I applied the formula =Weekday(cell value,2) then it returns the days signifying: 1\u00a0 for Monday 2 for Tuesday likewise 6 for Friday , I kept only the no 6 denoting Friday and deleted the rest useless data for the purpose.<\/p>\n<p>\u00a0<\/p>\n<p>On performing the above mentioned procedure, we are left with three columns first being date column 2<sup>nd<\/sup>\u00a0 being closing prices of the stock and 3<sup>rd<\/sup> being closing price of the BSE index.<\/p>\n<p>\u00a0<\/p>\n<p>Now we will calculate the corresponding return for each week from the stocks by applying the formula = {(Closing value \u2013 Opening Value)<u>\/<\/u> Opening Value*100}.<\/p>\n<p>\u00a0<\/p>\n<p>Formula used ,<\/p>\n<p>for calculation of Beta = COVARIANCE ( RETURN ON STOCK,RETURN ON MARKET INDEX)\/VARIANCE OF MARKET<\/p>\n<p>\u00a0<\/p>\n<p>Beta= <u>COV(Ri, Rm)\u00a0\u00a0 <\/u><\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 VAR (Market)<\/p>\n<p>\u00a0<\/p>\n<p>=<u>{Ri \u2013 Mean of Ri}{Rm- Mean of Rm}\/No of items<\/u><\/p>\n<p>{(Rm- mean of Rm )^2}\/No of items<\/p>\n<p>Hence on making the above calculations we get the beta for the company =.7371 which is less than 1, that indicates that the company is less volatile in nature hence it is suitable for long term investments.<\/p>\n<p>\u00a0<\/p>\n<p>By applying the anova on the above data obtained we obtained the correlation between the stock and market return .26506 which indicates there is positive relation between the movement of price of stock and market movements.<\/p>\n<p><strong><u>Data Analysis<\/u><\/strong><u>: <\/u><\/p>\n<p>Equation: Y=.2685115+0.73708x<\/p>\n<p><u>Interpretation:<\/u><\/p>\n<p>\u00a0The above equation shows the relation between BSE SENSEX and Tech mahindra\u00a0 ltd .<\/p>\n<p>The regression equation is in the form of Y = mx + b, where:<\/p>\n<ul>\n<li>Y represents the dependent variable.<\/li>\n<li>X represents the independent variable.<\/li>\n<\/ul>\n<p>Interpreting the coefficients:<\/p>\n<ul>\n<li>The coefficient is 2685 is the intercept of regression line.<\/li>\n<li>The coefficient 0.73708 is the slope of the regression line. It indicates the change in Y for a one-unit change in X. In this case, for every unit increase in X, Y is expected to increase by 0.73708 units.<\/li>\n<li>Number of observations are 49.<\/li>\n<li>.4857 is the t-stat for Y, the p-value for which is .62941.<\/li>\n<li>R square is 0.070209. This value indicates that approximately 02% of the variability in the dependent variable can be explained by the independent variables in the model.<\/li>\n<li>The ANOVA table shows the analysis of variance. The regression has a significant F .06577 with a very low p-value .62941. This implies that the overall regression model is statistically insignificant in explaining the variability in the dependent variable.<\/li>\n<\/ul>\n<p><strong><u>Conclusion<\/u><\/strong><u>:<\/u> Beta is 0.7370 which is less than 1, it means that Tech Mahindra \u00a0is good for long term investment.<\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><u>\u00a0<\/u><\/strong><\/p>\n<p><strong><u>References:<\/u><\/strong><\/p>\n<p>http:\/\/www.yahoofinance.com\/<\/p>\n<p>https:\/\/www.techmahindra.co<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TITLE :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Description between relation between \u00a0BSE SENSEX INDEX AND TECH MAHINDRA LIMITED \u00a0 AUTHOR: \u00a0\u00a0\u00a0\u00a0 VISHESH TIPLE ( FINANCE- 1) \u00a0\u00a0\u00a0\u00a0\u00a0 21230023170 \u00a0 \u00a0 INTRODUCTION:\u00a0\u00a0\u00a0 Tech Mahindra is an Indian multinational information technology services and consulting company. Part of the Mahindra Group, the company is headquartered in Pune and has its registered office in&hellip; <a class=\"more-link\" href=\"http:\/\/www.sachdevajk.in\/?p=19221\">Continue reading <span class=\"screen-reader-text\">Description between relation between BSE SENSEX INDEX AND TECH MAHINDRA LIMITED<\/span><\/a><\/p>\n","protected":false},"author":139053,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-19221","post","type-post","status-publish","format-standard","hentry","category-investing","entry"],"_links":{"self":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19221","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\/139053"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19221"}],"version-history":[{"count":1,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19221\/revisions"}],"predecessor-version":[{"id":19222,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=\/wp\/v2\/posts\/19221\/revisions\/19222"}],"wp:attachment":[{"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19221"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sachdevajk.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}