DeGroote School of Business

Course Description

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 OR F650
  • Cross-list: V703

Course Offerings

Winter 2025

Code Section Outline
F735 E C01

Winter 2024

Code Section Outline
F735 E C01 Outline

Winter 2023

Code Section Outline
F735E CO1 Outline

Winter 2022

Code Section Outline
F735 E C01 Outline

Winter 2021

Code Section Outline
F735 C01 Outline

Winter 2020

Code Section Outline
F735 C01 Outline

Winter 2019

Code Section Outline
F735E C01 Outline

Course Offerings Archive Submission Form

If you need an outline from an earlier semester, please use this form to contact us. Outlines for current and future courses will be posted here on the website as they become available.


  • You can request outlines from earlier semesters. Outlines for current (and future) courses will be posted here as they become available.
  • This field is for validation purposes and should be left unchanged.