Course Description

MFIN F707
Financial Modeling Using Excel and VBA

Financial modeling invoves 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

Fall 2017

Code Section Outline
C01
DeGroote on Google Plus DeGroote on Twitter DeGroote on Facebook