Course Description

BUSINESS F735
Financial Modelling

What is the difference between making a purpose built spread sheet and financial modelling? Financial modelling is much more flexible and can be easily modified to solve a wide array of questions. This course will examine the tools built into Excel and VBA and their use in financial modelling The tools will be introduced using concepts such as the time value of money, bond pricing, risk and return, financial planning and option pricing. Tools will include absolute cell references, names, lookup tables, formatting, spinners (and other controls), if statements, graphs, etc., as well as an introduction to VBA programming. A basic knowledge of Excel is assumed with no prior experience with VBA.

  • Prerequisite: F600
  • Cross-list: V703

Course Offerings

Fall 2017

Code Section Outline
C01 Outline

Winter 2017

Code Section Outline
C01

Fall 2016

Code Section Outline
C01 Outline

Winter 2016

Code Section Outline
C01 Outline

Fall 2015

Code Section Outline
C01 Outline

Winter 2015

Code Section Outline
C01 Outline
C02

Fall 2014

Code Section Outline
C01

Winter 2014

Code Section Outline
C01 Outline

Fall 2013

Code Section Outline
C01 Outline

Fall 2012

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