MGFB10: Principles of Finance

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

• 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.