Course Descriptions

Course catalog descriptions for courses offered in all currently published terms.


FIN 575 Financial Modeling
  1.5 hours Elective Terms Offered: W15(A), W16(A)
  Advisory Prerequisites: FIN core or concurrent enrollment in FIN 603 required 
  Financial Modeling --- This course is on financial modeling in Excel. Financial models have become increasingly complicated over the years, and this course is intended as an introduction to some of the modeling techniques used by professionals in the finance field. Topics covered include construction of free cash flows, forecasting cash flows, LBO models, minimum-variance frontiers and portfolio choice subject to constraints. The emphasis throughout will be on constructing and using models in Excel with a focus on sensitivity analysis. Along the way, various Excel techniques and functions are explored as necessary.