Optional drop-in workshop (IC330)

Welcome to MGFB10!

Your assignment requires you to use Microsoft Excel to answer a variety of time value of money calculations, and create a mortgage amortization schedule. We encourage all MGFB10 students to first go through the online tutorials:

Module 1 Introduction 2:10

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)