Abstract

This case presents the dilemma faced by Rishabh Bansal, Senior Research Analyst at Banyan Investment Private Limited, in suggesting a risk and return trade-off for a new client. The case provides enough scope to discuss and understand the concept as well as the measurement of risk and return for various securities and portfolios. It further helps in understanding the Efficient Frontier, Capital Market Line, and construction of optimal portfolio using real data from the National Stock Exchange. This case provides sufficient data and helps learners to understand how to construct the minimum risk portfolio that generates the required expected return after considering the given constraints.

Learning Objectives

The case is structured to achieve the following Learning Objectives:

• Discuss the concept, importance, and measurement of risk and return and its trade-off
• Understand how to assess overvalued/undervalued and aggressive/defensive securities
• Estimate the expected returns of the portfolio as per CAPM
• Construct an optimal portfolio with the help of various Microsoft Excel functions

Keywords

Risk and Return; Optimal Portfolio; Overvalued/Undervalued Securities; Aggressive/Defensive Securities; Beta; Alpha; R-squared; Sharpe Ratio; Correlation Matrix; Security Market Line; Matrix Multiplier Function; SOLVER Function; Correlation Matrix; Portfolio Standard Deviation; Efficient Frontier