Financial Modeling

Course Code
FIN 475
1.5 hours
  • Fall 16 (A)

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