Skip to Main Content

MGFB10: Principles of Finance

Fall 2022

Welcome to MGFB10!

QR code to access this research guide

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.


Scan the QR code to access the guide.


In-person Workshops

By the end of this workshop, you will learn:

  • How to work with workbooks and worksheets in Excel
  • How to use absolute and relative cell referencing in Excel
  • How to use the Time Value of Money functions (PV, FV, PMT, NPER, RATE etc.) in Excel
  • How to create a mortgage amortization table in Excel
  • How to create a combo chart with a secondary axis in Excel 

Online Videos


Module 1 Introduction                     

Module 2 Basics of Excel              13:16

Module 3 Excel functions (TVM)   7:53

Module 4 Amortization Table         9:45