Skip to main content

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