Partner

Certified Financial Modelling Professional

Rating:
4.8
English
Advanced
Video preview
LIVE VIRTUAL
TRAINING
FACE 2 FACE
ON SITE TRAINING
COACHING
& MENTORING
SELF-PACED
TRAINING
Select Date
DownloadDownload Brochure

Course Overview

This course introduces participants to the concept of building an integrated financial model, which includes a cash flow statement, a balance sheet, and an income statement. It uses best-practice techniques to ensure that the model is both accurate and efficient.

The participants will also learn how to test the assumptions used, as well as how to document and check the model for errors. This course will introduce the participants to the fundamentals of building financial models using Excel. It will also help them develop an understanding of financial relationships. In addition, it will introduce them to the multiple functions of excel, such as financial forecasting.

Key Takeaways

1
Develop a thorough mastery of excel and VBA software(s) for financial modelling purposes
2
Apply the needed tools to build models that are less time and effort consuming
3
Apply the best practices in modelling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement)
4
Implement over 1 million rows of data in seconds with Power Pivot Data Mashup and Data Exploration
5
Learn how to get from the basics of VBA to building a loan amortization table using a VBA macro

International Academy of Business and Financial Management
Brand Logo
The International Academy of Business and Financial Management™ is one of the world’s fastest growing professional association with more than 200,000 members, associates and affiliates in 145 countries. IABFM™ hosts and organizes certification training worldwide and offers exclusive board designations to candidates who meet the highest professional standards and assessment criteria. The IABFM is credited by the American National Standards Institute (ANSI) the International Standards setting authority.

Course Outline

Day 2
Exploring Excel Functions

Financial, date and time, statistical, lookup and reference, database, text, logical, information

Data validation

Basic, intermediate and advanced functions

Conditional addition and counting functions Pivot Tables, Power Pivot, & Data Validation

Introduction to Pivot Tables

Creating a Pivot Table Report

The Pivot Table Wizard

Percentage of column, percentage of raw, and percentage of previous

Retrieving data from external sources Including access and internet

 Pivot charts manipulation

Part 2
Creating Financials from Raw Data

How to link to pivot tables

COUNTIF, SUMIF, AVERAGEIF

Financials (revenue, expense, profit)

Interrelationships within a model

Logical arrangement of the parts

Model design and structure

Attributes of good excel models

Day 3
Best Practices of Model Building

Interrelationships within a model

Logical arrangement of the parts

Setting toggles

Model design and structure

Attributes of good excel models

Capital Investment Modelling

Revenue, expense, profit

Depreciation, taxes

NPV, IRR, PI

Efficiency ratios

Profitability ratios

Static vs dynamic analysis

Building one variable data tables

Building two variable data tables

Day 4
Forecasting

Income statement

Balance sheet

Cash flow statement

Modelling the connection between the income statement and the balance sheet

Using plugs to balance the balance sheet

Modelling the provision for taxes

Flows in the cash flow statement (operations, investment, financing)

Structuring a cash sweep

Modelling payment of successive debt tranches

Dashboards

Making your own KPI’s

Simulations

Monte Carlo

Day 5
Optimization

Optimization solutions with Excel Solver

Installing the solver add-in

Goal seek

Solver parameters

Decision variables and constraints

Tolerance levels

Solving problems with integer constraints

Visual Basic (VBA)

→ What is a macro?

→ Creating a simple macro

→ Assigning a shortcut key to a macro

→ Looking inside a macro

→ Manipulating recorded properties

Updated Features & Attributes

→ Power BI

→ Power Query

→ Data analysis toolpak

Who Should Attend?

his program is designed for delegates from middle management teams (assistant manager and above). Familiarity with Excel is an advantage.
CISM exam is designed specifically for Information Security Managers and administrators, or anyone seeking an overall understanding of essential security risks and controls.

FAQ

What language will the course be taught in and what level of English do I need to take part in an LEORON training program?
Most of our public courses are delivered in English language. You need to be proficient in English to be able to fully participate in the workshop and network with other delegates. For in-house courses we have the capability to train in Arabic, Dutch, German and Portuguese.
Are LEORON Public courses certified by an official body/organization?
LEORON Institute partners with 20+ international bodies and associations.We also award continuing professional development credits (CPE/PDUs) for:1. NASBA (National Association of State Boards of Accountancy) 2. Project Management Institute PDUs 3. CISI credits 4. GARP credits 5. HRCI recertification credits 6. SHRM recertification credits
What is the deadline for registering to a public course?
The deadline to register for a public course is 14 days before the course starts. Kindly note that occasionally we do accept late registrations as well, but this needs to be confirmed with the project manager of the training program or with our registration desk that can be reached at +91 4 95 5711 or [email protected]
What does the course fee cover?
The course fee covers a premium training experience in a 5-star hotel, learning materials, lunches & refreshments, and for some courses, the certification fee and membership with the accrediting bodies.
Does LEORON give discounts?
Yes, we can provide discounts for group bookings. If you would like to discuss a discount on a corporate level, we will be happy to talk to you.

Reviews

  • Review:
    IAMM Internal Audit Maturity Model
    In recognition of their dedication and contribution supporting IKEA Saudi Arabia in arranging training programs during 2017 & 2018, looking forward for more development and exciting effort this year. On behalf of IKEA Saudi Arabia, THANK YOU!
    Dalal Kutbi
  • Review:
    Certified Professional in Quality and Patient Safety
    Dating back to 2014, Mobily’s “LEORON” experience has grown from a single collaboration to a long-term partnership. We consider “LEORON” Institute as a strategic partner, whose contribution has been nothing but premium in equipping our staff with field-based knowledge and information. Past three years have resulted with an expanded collaboration with superior customer service and support. Best Regards,
    Turki S. Alsahaan
  • Review:
    Certified Professional in Quality and Patient Safety
    Since the partnership was signed between BAE Systems Saudi Development & Training and LEORON in 2017, we have been working together to offer the Saudi market a complete portfolio of training solutions benefiting from the wide and extensive experience of both parties. Recognizing the great success of this partnership, we are looking for further collaborations in the future that will position both companies as one of the leading training providers in Saudi Arabia. We thank the LEORON team for their full cooperation and continuing support, and look forward to further success together in the years to come.
    Emad Alrajih
  • Review:
    Certified Professional in Quality and Patient Safety
    We have been working with LEORON for the past two years and will be working with them again this upcoming year. The programs they delivered were fruitful and exciting and our organization has received positive feedback from the participants. What our organization aims to do is to provide at no cost training for all the private sector employees so that they may benefit from our offered programs in Innovation and Professional development. Leoron has helped us achieve this goal. We look forward to continuing this service and wish them the best of luck. Regards,
    Nasser M. Al-Subaie