<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>
Category: Excel
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 where the expected returns and covariance matrix are given. The optimal…
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…
