NMIMS BBA SEP 24 Financial Modeling Assignment Create a dyna

Financial Modeling

MBA Assignment Solutions
Call: +91 9741410271
Email: [email protected]
Visit: www.mbaassignmentsolutions.com

1. Create a dynamic model for Portfolio Optimization of 5 Stocks of your choice. Use historical 1-year daily data (from Yahoo Finance/ Google spreadsheet/ NSE Website) for computing asset returns. Optimize the portfolio for minimum variance, maximum return, and maximum Sharpe ratio (risk-adjusted return). Detail the step-wise approach to analyzing and solving the problem.

2. Using the same historical data collected for 5 Stocks, create a dynamic model to demonstrate the Capital Asset Pricing Model. The user should have option to select the stock of his choice and the corresponding Beta and Expected Rate of return for the stock will be displayed automatically.

3. Create a Dynamic Model

a. To capture Present Value of Future Cash Flows (Lump Sum or Annuity or perpetuity).

b. To capture the Future Value of Cash Flows (Lump Sum or Annuity)
Make necessary assumptions for user Input.

MBA Assignment Solutions
Call: +91 9741410271
Email: [email protected]
Visit: www.mbaassignmentsolutions.com