Course Overview

The Advanced Financial Modeler (AFM) is the first of three certification levels offered by the FMI. This exam preparation course forms the foundation for subsequent certification levels and focuses on the skills required to design and build integrated financial models.
The AFM exam provides participants with a unique opportunity to demonstrate their modeling proficiency through an intensive modeling exam within a controlled environment. Participants who pass the exam will achieve the Advanced Financial Modeler credential

Course Methodology

This course demonstrates core principles in Financial Modeling and utilizes Excel in performing modern and creative techniques of Modeling. Real-life case studies, individual workshops, and team presentations by participants

Course Objectives

The AFM is the foundational level for earning the most respected financial modeling certification in the industry. It sets the global standard in financial modeling proficiency and allows you differentiate yourself in an increasingly competitive financial environment. Consider how obtaining the AFM can accelerate your career:
Skill Validation: Demonstrate advanced financial modeling proficiency to yourself and employers
Personal Development: Invest in yourself by earning certifications that are challenging and revered by the industry
Career Flexibility: Obtain a skillset that is globally relevant and respected across multiple lines of business

Target Audience

The AFM program is open to anyone who has an interest in or currently works in business analysis, business planning, and financial modeling. From finance students to seasoned industry professionals, the AFM designation is ideal for those who:
  • Understand the fundamentals and methodologies of financial modeling
  • Want to hone and validate their skills
  • Work as part of a larger team to provide support for improvement or new projects
  • Work extensively with Excel in their day-to-day work to make material financial decisions

Target Competencies

  • Financial model layout and best practices
  • Intermediate-to-advanced Microsoft Excel skills
  • Excel efficiency
  • Scenarios Analysis
  • Accounting fundamentals including financial statement construction and linkages
  • Model schedules (e.g. Fixed vs Variable Costs, Working Capital, Deferred Taxes, Debt and Equity)

Course Outline

FINANCIAL MODELING BEST PRACTICES

  • Modeling as a Discipline
  • Model Planning:
  1. Error-checking techniques
  2. Performing Top/Down and Bottom-Up Approaches
  3. Model Purpose
  4. 11 Questions to ask the Modeler
  • Design and Presentation:
  1. Design Tips
  2. Headers/Footers
  3. Cover Page Rules
  4. Table of Contents
  5. Naming Conventions
  • Tab Structure:
  1. Vertical versus Horizontal Cover, Summary, Assumptions, Scenarios, Schedules Tab, Model, Output
  • Model Construction Tips:
  1. Structural Tips
  2. Formatting Tips
  3. Formula Tips
  4. Circularity in Financial Models

MODEL ATTRIBUTES

  • Dynamic
  • Flexible
  • Intuitive
  • Transparent
  • Printable
  • Transferable

PROFESSIONALS EXCEL SKILLS

  • Excel Tools
  • Custom Formatting
  • Lookup Functions
  • Absolute References
  • Past Special
  • IF Statements
  • Conditional Formatting
  • Forms & Drop-down Boxes
  • Printing

KEYBOARD SHORTCUTS

  • Navigating Shortcuts
  • Selecting Cells
  • Function Keys
  • Function Shortcuts
  • Formatting Shortcuts
  • Editing Shortcuts
  • ALT Navigation Key Shortcuts

SCENARIO ANALYSIS

  • Rationale for Scenario Analysis:
  1. Base Case
  2. Upside Case
  3. Downside Case
  • Scenario Analysis Skills:
  1. CHOOSE
  2. INDEX
  3. OFFSET
  • Saving a Model

MODEL COMPONENTS

  • Financial Statements:
  1. Income Statement
  2. Cash Flow Statement
  3. Balance Sheet
  4. Statement of Comprehensive Income
  5. Statement of Changes in Shareholders’ Equity
  6. Sector-specific Statements

MODEL SCHEDULES

  • Revenue Schedule
  • Operating Cost Schedule
  • Capex/Depreciation Schedule
  • Income Tax Schedule
  • Working Capital Schedule
  • Debt Schedule
  • Equity Schedule

ACCOUNTING, MICROSOFT EXCEL, AND FINANCIAL MODELING

Location & Dates
Call us at +971 4 430 8394