2012-2013 Academic Catalog

May 04, 2024

2012-2013 Academic Catalog [ARCHIVED CATALOG]

FIN 5303 - Financial Modeling

In this course students will implement financial models using excel. The models are drawn from various finance areas such as corporate finance, fixed income securities, investments, and derivatives. The emphasis is not on the models, per se, but on the implementation. It is often true, however, that a complete understanding of the models comes through using them for computations. The models will be introduced through lecture and discussion.

The idea is that students will leave the class fully capable of programming basic financial models in a spreadsheet. This training should prepare the student for many applications in the finance field. There appears to be a growing demand for people who have the practical skills of financial modeling. Since not all students will have the same finance background, however, another objective will be to fill in finance deficiencies in some small way as we discuss models from various areas. Thus, this course is the type of course that, perhaps, could just as easily be taught as a first course in finance or a last course in finance. In sum, students should be able to implement finance theory in spreadsheet models for a number of different practitioner applications.

Prerequisites: FIN 4200 of

FIN 5301

for MBA students. No prerequisite for MSF students.