Financial Analysis Modeling and Forecasting

Why Attend

Financial professionals are often asked to provide analysis and projections of finances to help management make decisions. By attending this course, you will be able to prepare and build financial analysis models effectively, understand and analyze the time value of money, and prepare forecasted financial statements.

Course Methodology

The course is a hands-on workshop that applies MS Excel to model financial analysis and forecasting through different exercises and case studies.

Course Objectives

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

• Use financial ratio analysis to interpret organizational financial performance and position
• Calculate financial ratios related to the cash flow statement  
• Utilize Microsoft Excel in the time value of money calculations
• Apply MS Excel modeling tools and functions such as spinner, list box, option button, etc.
• Forecast and build models for the three main financial statements

Target Audience

Financial controllers, analysts, finance and accounting managers, supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create financial forecast models in their organizations.

Target Competencies

• Understanding and performing financial analysis
• Performing vertical, horizontal, and trend analysis
• Financial forecasting
• Modeling financial statements
• Applying Excel functions and tools

Note

This training course is a workshop that relies extensively on using laptops. Participants must bring their own laptops equipped with Excel 2016 or a later version.