Course Description

MFIN 707
Financial Modeling Using Excel & VBA

Financial modeling involves the creation of tools that someone, other than the writer, can use to answer “what if” questions in finance. The course will examine the tools built into Excel and VBA and their use in financial modeling, with an emphasis on documentation and industry best practices. The models used for this purpose include the yield curve, the efficient frontier, various asset pricing models (such as the CAPM and the APT) , portfolio management (fixed income and equity), option pricing, VaR (value at risk) and other risk measures, and capital market simulation.

A working knowledge of Excel is assumed although no prior experience with VBA is required.

  • Prerequisite: Finance 601
  • Antirequisite: Business F735

Course Offerings

Winter 2020

Code Section Outline
C01 Outline
C02 Outline

Winter 2019

Code Section Outline
C01 Outline
C01

Winter 2018

Code Section Outline
C01 Outline
C02 Outline
DeGroote on Facebook DeGroote on Twitter WMA LinkedIn