Financial Modeling

Course Code
FIN 575
Hours
1.5 hours
Type
Elective
Offered
  • Winter 21 (A)
  • Winter 22 (A)
Prerequisites
Graduate Standing and (FIN 503 or 513 or 551 or 591 or waivers)

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