Quantitative Financial Modeling in Microsoft Excel
Master financial modeling with Excel & VBA. Learn to build powerful models for various finance topics. Boost your financial analysis skills!
Course Content
Quantitative Financial Modeling in Microsoft Excel is an intermediate-level Udemy course taught by Fabian Moa. It runs 1h 52m, is taught in English, and includes a certificate of completion. Learners rate it 4.3 out of 5 from 153 reviews, with 5,368 students enrolled. It is a paid course, last updated November 2022.
Master Financial Modeling with Excel
Unlock the power of Excel for sophisticated financial modeling. This course provides practical, step-by-step guidance on implementing key financial models directly within Microsoft Excel. Gain hands-on experience building models to analyze investments and manage risk.
Here's a detailed look at the models you'll learn:
Black-Scholes-Merton (BSM) Option Pricing Model: Understand and apply the Black-Scholes-Merton model to accurately price European-style call and put options. The course covers scenarios including options on stocks that pay dividends. You'll then calculate crucial Option Greeks:
- Delta: Measures the sensitivity of an option's price to changes in the underlying asset.
- Gamma: Indicates the rate of change of Delta.
- Vega: Quantifies the option's sensitivity to changes in implied volatility.
- Theta: Represents the rate of time decay of the option.
- Rho: Measures the option's sensitivity to changes in interest rates.
Binomial Option Pricing Model: Develop a powerful option pricing calculator using VBA within Excel, based on the Cox-Ross-Rubinstein (CRR) model. This provides a flexible alternative to the Black-Scholes model.
Portfolio Optimization: Learn to optimize your investment portfolio using Excel's Solver function. This includes:
- Downloading and importing stock data into Excel.
- Calculating key performance metrics: returns, variance, covariance, and Sharpe ratios.
- Determining the optimal asset allocation to maximize returns for a given level of risk.
Option Implied Volatility: Discover how to determine implied volatility for options using Excel's Goal Seek function. This allows you to backsolve option prices to find the market's expectation of future price fluctuations.
Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR): (NEW! Added 4th June 2020) Calculate Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR) to assess potential losses in your portfolio. The course covers:
- Historical VaR and Historical CVaR.
- Gaussian VaR and Gaussian CVaR.
- Cornish-Fisher VaR and Cornish-Fisher CVaR.
Apply these methods using a selected stock.
Optimization of VaR and Trading Liquidity Risk: (NEW! Added 4th June 2020) Learn to optimize position unwinding to minimize risk and liquidation costs. This involves:
- Calculating the cost of unwinding a position, considering market risk exposure (VaR) and liquidation costs (bid-ask spread).
- Determining the optimal liquidation period to balance risk and cost.
To maximize your learning, actively build the models alongside the video tutorials. This hands-on approach will solidify your understanding of financial modeling in Excel.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.