Financial Modeling

Course Code
FIN 475

1.5 hours
Winter 23 (B)
FIN 300 or 302

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.