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.

MGAC02: Intermediate Financial Accounting II

The guide introduces Excel and TVM functions to MGAC02 students.

Introduction to Excel and Time Value of Money Functions

The original playlist consists of 4 modules and is intended for MGFB10 students.  MGAC02 students may skip module 1 and 4 to take advantage of the Excel training.

Module 2 Basics of Excel                   13:16

Module 3 Excel functions (TVM)         7:53

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)

Practice Workbook

Intro to Financial Calculator