Financial Modeling

Catalog description

The course focuses primarily on developing spreadsheet applications and using the case method to apply decision-making procedures to real-world problems in finance areas. Students will be exposed to spreadsheets throughout the course to develop models that can be used in the financial decision-making process. Important financial topics such as financial ratio analysis, financial forecast, regression analysis, portfolio management, asset valuation, risk management, and capital budgeting decisions will be covered. Students will access market data through the internet and proprietary providers. Students will apply advanced skills such as Data Analysis tools, Advanced reporting, Monte Carlo simulation, and user-defined functions and macros. An overview of a scripting programming language in financial analysis/research will also be included.