FM x FM
  • Home
  • Courses
    • Excel VBA for Financial Modeling
    • Preparing for the Advanced Financial Modeler (AFM) Exam
    • Business and Finance Formulas in Microsoft Excel
  • Blog
  • About
  • Contact
Select Page
Monte-Carlo Simulation for Wealth Planning in Excel

Monte-Carlo Simulation for Wealth Planning in Excel

Financial Modeling

I was inspired to write this piece after teaching a reading in the CFA Level 3 syllabus for the June 2020 exam. In Reading 28 on Overview of Private Wealth Management, it touched on a term called “Capital Sufficiency Analysis” (or Capital Needs Analysis),...
Building a Black-Scholes-Merton (BSM) Option Pricing Calculator (with Greeks)

Building a Black-Scholes-Merton (BSM) Option Pricing Calculator (with Greeks)

Financial Modeling

Sometime back, my student asked me for help in building a calculator in Excel for pricing options using the Black-Scholes (or what they call as Black-Scholes-Merton) model. So, I thought of doing this tutorial to show how anyone with Excel can build their own BSM...
Next Entries »

Recent Posts

  • Optimization of VaR and Trading Liquidity Risk in Excel: Unwinding a Position Optimally
  • Modeling Value-at-Risk (VaR) and Conditional Value-at-Risk (CVaR) in Excel (Historical, Gaussian, and Cornish-Fisher)
  • Binomial Option Pricing Model with Excel VBA (for European Options)
  • Modeling Interest Rate Immunization: Managing the Interest Rate Risk of a Single Liability
  • Finding Option Implied Volatility using Goal Seek in Excel

Recent Comments

    Archives

    • July 2020
    • April 2020

    Categories

    • Financial Modeling

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    Fabian Moa

    • Facebook
    • Twitter
    • Instagram
    • RSS

    Designed by Elegant Themes | Powered by WordPress