MGT436 SAPM Excel Worksheet Assignment

1. Select Any 6 stocks (each from Different Industry) from NSE “NIFTY50” List (As given in Annexure 1).
2. Download their prices (NSE DATA only) from 1 st JUNE, 2022 to 31st MAY, 2023. Save each company data in a separate Excel Worksheet and Label each sheet as [”Sr.No.” “Company Name”]. For example, if you select Reliance Industries Ltd. as the first stock, the sheet will be named as “1 RIL”. Thus, there will be 6 work sheets with company data. Also download NIFTY50 data for the corresponding period and put it in sheet labelled as “7 NIFTY50”.
3. From the price data sheets downloaded above, use only the adjusted closing price of the day. Perform data normalization (edit data for price changes due to issue of bonus share and/or share split besides taking care of missing dates).
   Show in a single EXCEL worksheet “8 Master Data”: all the Dates (1st Column), 6 selected Stocks prices (Column 2 to 7) and NIFTY50 Values (Column 8).
   NOTE: So far, you would have created 8 excel worksheets in the same Excel File….Another 4 are also needed as below….
4. Now, do the following computations – Label it as “9 RRB COMP” Sheet:
   1. Risk-Return: Calculate for each one of the 6 individual stock and the NIFTY50 (These computations can be performed in the individual stock or NIFTY50 excel sheets): Expected Return (using log normal returns) and Risk (Look up your book / material / web for how to calculate them).
   2. Compile all the 7 risks and returns (stocks and NIFTY50) data in a single table [TABLE 1] in “9 RRB COMP” Sheet. Interpret the results in your own words.
   3. Beta Computation: Calculate Beta of each of the individual 6 stocks w.r.t. the Market Index (NIFTY50) [The Beta of the reference market index is always taken as 1]. Tabulate the 6 Betas and sort them in decreasing order [TABLE 2]. Interpret your Results.

Are you struggling to keep up with the demands of your academic journey? Don't worry, we've got your back! Exam Question Bank is your trusted partner in achieving academic excellence for all kind of technical and non-technical subjects.

Our comprehensive range of academic services is designed to cater to students at every level. Whether you're a high school student, a college undergraduate, or pursuing advanced studies, we have the expertise and resources to support you.

To connect with expert and ask your query click here Exam Question Bank