Brief Introduction
Learn how to build financial models in Excel and VBA for different financial topicsDescription
Excel is an excellent tool for understanding the intricacies involved in financial modeling. The aim in each section of the course is to explain the implementation of the models using Excel.
Some models discussed in this course:
Black-Scholes-Merton (BSM) Option Pricing Model
Binomial Option Pricing Model
Portfolio Optimization
Option Implied Volatility
Value-at-Risk (VaR) and Conditional Value-at-Risk (CVar): Historical, Gaussian and Cornish-Fisher (NEW! Added on 4th June 2020)
Optimization of VaR and Trading Liquidity Risk: Unwinding a Position Optimally (NEW! Added on 4th June 2020)
To benefit from this course, it is advised that you try building the models as you go through the videos.
As I am nearing to the 2 hour limit for a free course, I will no longer be adding new videos to this course. If I want to add more videos, then I will have to convert it to a paid-course, which I am not planning to do anytime soon.