Financial Modeling

Course Code
FIN 475
Hours
1.5 hours
Type
Elective
Offered
  • Fall 16 (A)
  • Winter 18 (B)

Financial Modeling --- This course aims at establishing a practical bridge between financial theories and real-world problems for professionals in investment banking, private equity and investment management. This course covers (1) construction of free cash flows; (2) forecasting financial statements; (3) construction and analysis of leveraged buyout models; (4) construction and analysis of mergers and acquisitions models. The emphasis throughout is on constructing and using models in Excel with a focus on sensitivity analysis. Along the way, we explore various Excel techniques and functions when needed without worrying about the Microsoft event-driven programming language known as Visual Basic of Applications.

Taught By
Qin Lei
  • Adjunct Assistant Professor