FIRE 312. Financial Modeling. 3 Hours.

Semester course; 3 lecture hours. 3 credits. Prerequisites: FIRE 311 with a minimum grade of C; and SCMA 301, STAT 210, STAT 212 or STAT 541. Enrollment is restricted to students with majors or concentrations offered by the Department of Finance, Insurance and Real Estate who have completed at least 54 credit hours (junior standing). This course is designed to introduce students to a wide array of primarily Excel techniques used in financial model building. Students will be introduced to techniques such as data tables, solver, matrix manipulation, array formulas, pivot tables, etc., to create financial models that are common in the areas of finance, risk management and real estate finance.