Building Financial Modeling

Overview

To make your way in this AFM preparation program, there is a minimum required level of Excel, you have to be familiar with and regularly using Microsoft Excel, comfortable with using formulas, and know their way around the basic functions of Excel. It is assumed that students will know how to link between worksheets, and create some formulas.

Contact us form

Outcome

Build a set of integrated financial statements based on financial accounting principles

Use of Excel functions required for integrated financial statements and performance measures

Structuring error check networks

Build scenarios and sensitivities into models

Details

Developed by: Beacon FinTrain
Standard Total Hours: 30 Hrs
Language: English - Bilingual "English & Arabic"
Modalities: 
Register Now

Outline

  • What Is Financial Modeling?
  • What is a Financial Model Used For?
  • What do you need to be competent at to be a financial modeler?

  • Logical Functions
  • Lookup and Reference Functions
  • Working with Text and Dates
  • Macros in Financial Modelling

  • Main Section in every model
  • Front End
  • Cover page
  • Executive summary
  • Headers & Footers
  • Inputs and assumptions
  • Assumptions Documentation Methods
  • Custom Formatting
  • Data Validation

  • Building Up the Engine Scenarios
  • Scenarios
  • Sensitivities and What-if Analysis
  • Building Scenarios (Model Application)
  • Revenue Schedule
  • Setting up the Revenue Schedule
  • Completing the Revenue Schedule

  • All Different Types of Costs
  • Operating Costs
  • Cost Schedule
  • Operating Leverage
  • Semi Variable Costs
  • Repeat, Build and Link approach

Read More

Who Should Attend

  • Finance professionals with strong finance and accounting knowledge and intermediate modeling skills
  • investors, analysts, accountants, and any other finance professionals responsible for maintaining and developing unfamiliar models or those who want to be able to solve advanced modeling problems

Why Beacon

Quality

Beacon FinTrain prioritizes excellence in every service, ensuring top-notch, reliable, and consistent outcomes that meet and exceed client expectations.

Specialization

We focus on finance, offering expert knowledge and bespoke solutions that cater to the unique needs of finance professionals in the Middle East and Africa.

Punctuality

Time is money. We respect deadlines, delivering precise and timely results to help our clients stay ahead in the fast-paced financial world.

Guidance

Beacon FinTrain is a guiding light in finance, providing insightful advice and support to navigate the complexities of financial markets and regulations.

Integrity

We uphold the highest ethical standards, fostering trust and transparency in all our dealings to build lasting relationships with clients.

Flexibility

Adapting to the dynamic finance sector, we offer versatile services and solutions that align with the evolving needs of our clients.