Udemyintermediateen

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!

4.3(153)
5,368students
1h 52m
Certificate
Fabian Moa
Fabian MoaSubject Matter Expert in Finance, Risk, and Sustainability

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:

  1. 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.
  2. 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.

  3. 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.
  4. 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.

  5. 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.
  6. 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.

$ whoami — the devs behind tutorialsearch.io

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.

5.0(46)
1h 30m
beginner
skillshare
5.0(258)
3h 48m
intermediate
skillshare

Lalten Modeling in Maya 3D

by Sushil K Lawaniya

5.0(79)
54m
intermediate
skillshare
skillshare