BUSINESS F735 / Financial Modelling

3 unit(s)

Prerequisite(s): BUSINESS F600 OR BUSINESS F650 OR enrollment in the Blended Learning Part-time MBA Program.

Antirequisite(s): BUSINESS V703

What is the difference between making a purpose built spread sheet and financial modeling? Financial modeling is much more flexible and can be easily modified to solve a wide array of questions. This course will examine the tools built in to Excel and VBA and their use in financial modeling. 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.