This course builds upon the fundamentals of Excel learned at BCIT and in the students’ Finance and Accounting courses. It does so by approaching the subject of computer modeling from the perspective of an analyst who wishes to construct dynamic computer based models and scenarios which allow him/her to understand, and manipulate, the information associated with common financial and accounting problems. Rather than using the traditional lecture format, students will be expected to analyze various financial concepts and, on the basis of their analysis, construct a spreadsheet model which allows them to test hypotheses, compare the performance of alternative options under various scenarios and provide detailed information for the decision making process. In their project, students will be expected to design a working spreadsheet model based on a problem typically encountered in the assigned topic.
Upon successful completion, the student will be able to:
Effective as of Winter 2016
FMGT 4720 is offered as a part of the following programs:
Interested in being notified about future offerings of FMGT 4720 - Advanced Computer Applications 2 for Finance? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.