FINANCE 707 / Financial Modeling Using Excel and VBA

3 unit(s)

Prerequisite(s): FINANCE 601

Antirequisite(s): BUSINESS F735

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.