Course Methodology

This course uses hands-on applications of financial modeling in Excel in addition to demonstrating theoretical core topics. The course also features real-life case studies and presentations by participants.

Course Objectives

By the end of the course, participants will be able to:

• Prepare effective financial models utilizing powerful Excel functions
• Use core financial modeling techniques
• Forecast investments, and calculate valuations of projects and companies in an effective manner
• Develop comprehensive financial models to support investments decisions
• Recognize special modeling and valuation considerations and best practices

Target Audience

Corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.

Target Competencies

• Learning advanced Excel
• Performing capital budgeting analysis
• Forecasting cash flow
• Calculating cost of capital
• Practicing financial modeling
• Understanding scenario analysis
• Calculating free cash flow

Note

This is a hands-on training course using laptops, participants need to bring their own laptops equipped with a fully functioning version of MS Excel 2010/2013.