FINANCIAL MODELING (3 SCU)

Learning Outcomes:

Upon successful completion of this course, students are expected to be able to explain characteristics of different financial analysis tools; to apply appropriate tool for analyzing financial related problems; to use spreadsheet to effectively gather financial data and create financial models; and to explain financial analysis results for business decision making

Topics:

This course will cover basic financial modeling skills using spreadsheet software, especially Microsoft Excel. From the development of templates for financial statements to the valuation of projects using Monte Carlo simulation, students will master the techniques required to create real-world finance related models through hands-on computer based exercises.