Financial Modelling

Portfolio Optimization using Solver in Excel

Portfolio Optimization using Solver in Excel

Let's say you have a client who wants to construct a stock portfolio, and she chose the following stocks: Apple (AAPL) Boeing Airlines (BA) Netflix (NFLX) Tesla (TSLA) Your client has stated that the objective of maximizing the Sharpe ratio of her portfolio. Her...