Advanced Financial Modeling

Catalog description

This course provides students the opportunity to learn advanced financial analysis and strategic problem solving by completing a set of projects in a workshop format. Examples of project types include: data analysis and decision-making using advanced Excel skills; financial analysis and modeling; financial planning and analysis (FP&A) and forecasting and valuation. The course adopts a "learn-by-doing" approach to financial modeling so that students gain a deeper understanding of financial concepts and learn critical financial problem-solving skills. Students will apply theories from Accounting, Corporate Finance, Economics, Entrepreneurship, and Investments to several real-world financial modeling cases from diverse industries. The aim is to enable students to perform analyses used to achieve real-world financial goals. Students will work independently with one-on-one support from a financial executive who will provide guidance throughout the course. The course will culminate with a presentation of findings to corporate partners for feedback. The course integrates a finance curriculum with a tutorial in Visual Basic for Applications (VBA) , a key building block for financial analysts and others. This is a unique opportunity to work closely with experienced finance professionals, gain invaluable on-the-job work experience and meet potential employers.