Jan 15, 2025  
School of Graduate Studies Calendar, 2021-2022 
    
Catalog Navigation
  Calendar Home
  Directory for Information
  Officers of Administration
  Vice-Provost and Dean of Graduate Studies
  Associate Deans of Graduate Studies
  Sessional Dates 2021-2022
  Graduate Study at McMaster University
  General Regulations of the Graduate School
  Regulations for Degree Progression
  Financial Matters
  Additional University Regulations Affecting Graduate Students
  General Information
  Graduate Scholarships, Bursaries and Other Awards
  Governing Bodies

  Areas of Study
  DeGroote School of Business
  Faculty of Engineering
  Faculty of Humanities
  Faculty of Health Sciences
  Faculty of Science
  Faculty of Social Sciences
  Interdisciplinary
  Course Listings
  My Favourites
HELP
School of Graduate Studies Calendar, 2021-2022 [-ARCHIVED CALENDAR-]

Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Favourites (opens a new window)

BUSINESS V703 / Financial Modeling and Valuation

3 unit(s)

Prerequisite(s): BUSINESS F600  OR BUSINESS F650  

Antirequisite(s): BUSINESS F735  

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 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.


Facebook this Page (opens a new window)
Tweet this Page (opens a new window)
Add to Favourites (opens a new window)