To install a solver in MS Excel follow the instructions in the video.
Category: Excel
Correlation matrix
<iframe width=”560″ height=”315″ src=”https://www.youtube.com/embed/w5Do76xC7Eg” frameborder=”0″ allow=”accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture” allowfullscreen></iframe>
Net present value
In this video we show how to calculate the net present value (NPV) of a financial investment in MS Excel. The cashflows for more than one period must be given…
Markowitz portfolio selection
In this tutorial we show how to solve the Markowitz portfolio selection problem in Excel by help of Solver. The expected returns for each asset and covariance matrix are given. The…
Dynamic histogram
Consider you want to draw in Excel an histogram which is automatically updating when the input data is changing:
Calculating covariance matrix
To calculate covariance matrix using Excel:
Simulation of stock prices
Modeling the volatility of an asset (e.g., index, bond, stock, commodities) allows to simulate the value of that asset. Based on the simulated value range derived or composite financial products…