AUTHOR: SANIKA KORGAONKAR ( FINANCE- 1)
21230023616
Thyagarajan is an industrialist and founder of Chennai-based Shriram Group
Mr. Y S Chakravarti has been the Managing Director and Chief Executive Officer of the company since December 2022.
Shriram Properties Ltd. (SPL) is one of the leading residential real estate development companies in South India, primarily focused on the mid-market and affordable housing categories.
It is a part of the Shriram Group, which is a prominent business group with four decades of operating history in India and a well-recognized brand in the retail financial services sector and several other industries
OBJECTIVE OF THE REPORT –
To Calculate Beta and its significance of the equity stock of SHRIRAM FINANCE LTD.
REVIEWS:
The tagline of Shriram Finance Ltd is “CUSTOMER FIRST .”
Dilip Davda – The company claims that it has priced the IPO reasonably. The only favourable point, for now, is the Shriram Group tag and their efforts to back on track in the near term. Thus this issue is purely and only for long term investors who have surplus funds and risk appetite. Others can skip this issue and may buy at dip post listings.
To be country’s most-preferred financial services destination, delivering delightful customer experience through empowered employees.
PROCEDURE FOR DATA COLLECTION
First I logged on to BSE official website www.yahoofinance.com. Then I clicked on historical data via (https://finance.yahoo.com/quote/SHRIRAMFIN.NS/history). Then I selected the period from 01st Nov 2022 to 31st Oct 2023 then clicked apply and downloaded the CSV file of the price of the BSE index.
Similar procedure is followed for obtaining the data of data of Tech Mahindra limited for the period 01st Nov 2022 to 31st Oct 2023.
After downloading the CSV Files of both the BSE index and Shriram Finance LTD I proceeded to calculate beta of the stock of Shriram Finance LTD.
PROCEDURE FOR DATA ANALYSIS
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
For arriving at the last day of the week I applied the formula =Weekday(cell value,2) then it returns the days signifying: 1 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.
On performing the above mentioned procedure, we are left with three columns first being date column 2nd being closing prices of the stock and 3rd being closing price of the BSE index.
Now we will calculate the corresponding return for each week from the stocks by applying the formula = {(Closing value – Opening Value)/ Opening Value*100}.
Formula used ,
for calculation of Beta = COVARIANCE ( RETURN ON STOCK,RETURN ON MARKET INDEX)/VARIANCE OF MARKET)
Beta= COV(Ri, Rm)
VAR (Market)
={Ri – Mean of Ri}{Rm- Mean of Rm}/No of items
{(Rm- mean of Rm )^2}/No of items
Hence on making the above calculations we get the beta for the company = 0.6263 which is less than 1, that indicates that the company is less volatile in nature hence it is suitable for long term investments.
By applying the anova on the above data obtained we obtained the correlation between the stock and market return .2300 which indicates there is positive relation between the movement of price of stock and market movements. Similarly we obtained the F value and P value to be 2.5500 and 0.1135 respectively.