How to get

(a)Risk-Return Sheet: Calculate for each one of the 20 individual stock and the Index - Expected Return (using log normal returns) and Risk (Look up your book / material / web for how to calculate them). Compile all the 21 risks and returns in a single table. Interpret the results in your own words.

(b)Beta Compute Sheet: Calculate Beta of each of the individual 20 stocks w.r.t. the Market Index (NIFTY) [The Beta of the reference market index is always taken as 1]. Tabulate the 20 Betas and sort them in decreasing order. Divide the list in two parts with first 10 as "High Betas" and next 10 as "Low Betas" and Comment on your results.

(c)Beta-H Sheet and Beta-L Sheet: Form two portfolios based on 10 high and 10 low beta stocks. Call them "Portfolio Beta-H" and "Portfolio Beta-L". Adopt equal weightage (1/10 or 10%) for computing the portfolio return for "Portfolio Beta-H" and "Portfolio Beta-L" based on 10 stocks each. [Use Separate EXCEL Sheets for each Portfolio computation]. Compare the risk and return profiles of these two portfolios and state your interpretation.

(d)Superior-P Sheet: Finally, answer, which of the two portfolios was found to be superior and Why? Use Sharpe Ratio and Rf = 6% for your answer.