Option Area(s):

Recommended Finance Course

Course Description :

Over the past decade, electronic spreadsheets have become the standard tool that business people use to model and analyze quantitative problems. The latest versions of these spreadsheet packages contain powerful analytical tools that could be possible only with mainframe computers and mathematically trained personnel a decade ago. This course covers up-to-date and practical spreadsheet modeling tools which can be applied to a wide variety of business problems in finance, marketing, and operations. The topical coverage consists of the following three modules: (1) simulation modeling techniques to analyze risk and uncertainties in business environment, (2) optimization techniques to determine the best managerial actions under internally- and/or externally-imposed constraints, and (3) real-world examples and cases to demonstrate broad applications of spreadsheet modeling and simulations in manufacturing and service operations, supply chain systems, yield management, asset dynamics, option pricing, etc. This course is case-oriented and provides hands-on experience of computer applications using Microsoft Excel, spreadsheet add-ins @Risk and RiskOptimizer, and SimQuick (process simulation with Excel).

Prerequisites :

MGMT 67000, 67100.