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)
how to correctly create and format a mortgage amortization schedule.
how to plot data on a secondary axis.
University of Toronto Scarborough Library
1265 Military Trail, Toronto, ON M1C 1A4 Canada
About web accessibility. Tell us about a web accessibility problem.
About online privacy and data collection.
© University of Toronto. All rights reserved.