Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

MGFB10: Principles of Finance

Winter 2022

Welcome to MGFB10!

Microsoft Excel is a powerful tool for approaching a variety of time value of money (TVM) calculations and graphing.  Knowing these TVM functions will assist you in answering the course assignment questions, and your term project requires you to use Excel for the numerical analysis of the case. We encourage all MGFB10 students to go through the online tutorials and other Excel resources available here.

Module 1 Introduction                     

Module 2 Basics of Excel              13:16

Module 3 Excel functions (TVM)   7:53

Module 4 Amortization Table         9:45


By the end of this workshop, you will know:

  • when to use absolute and relative cell referencing

  • how to write accurate formulae in Excel

  • know how to use Time Value of Money functions (FV, PV, RATE, NPER, PMT, NPV, etc)

  • Optional:

    • how to correctly create and format a mortgage amortization schedule.

    • how to plot data on a secondary axis.

Practice Workbook