Objective of this module is simple. In order to perform financial calculations quickly, you need both math and a tool. This module puts them together. This covers solving common business math problems in Microsoft Excel.
EXPECTED LEARNING OUTCOME
At the end of the following labs, students will be confident in solving loan and interest rate problems, valuing annuities and perpetuity or computing depreciation and amortization values in Excel spreadsheets.
One 90 minutes webinar lecture session per each lab
One 90 minutes online doubt solving session per each lab
Access to video lessons for Additional References per each lab
One set of carefully selected problem sets per each lab
Searchable and dedicated discussion Forum thread for each lab
Grading and Overall Feedback video for each lab
Lab 1: Loans and Interest Rate using Excel
Lab 2: Annuity & Perpetuity using Excel
Lab 3: Depreciation & Amortization using Excel
3 – 4 Weeks
Conveniently priced on per lab basis for a section of up to 60 students.
2-3 hours per week preferably during evening or weekends
Laptop with Microsoft Office 2007 or later, OR access to college computer lab, AND bandwidth.
SABA Primer (Excel Primer, Maths Primer and Stats Primer, R Primer) are prerequisite to undergo the remote labs courses.