Financial Modeling

Course Code
FIN 575
1.5 hours
  • Winter 20 (A)
  • Winter 21 (A)

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.

Taught By
Qin Lei
  • Adjunct Assistant Professor