Beacon FinTrain

Provides an array of professional business and financial training services that stem from improving a corporate's treasury workflow —all the way to efficient, finance training programs.

Course Overview

Financial modeling plays an integral part in business decision-making, with modelers informing key transactions and critical business decisions. 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. These courses are not designed to teach Excel, but rather the use of Excel in a modeling situation. Intermediate level in using Microsoft Excel and Knowledge of Accounting fundamentals are required.

For More Inquiries

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Shady Gamal Zaki

Business Development Assistant Manager

 +966534175887

 s.gamal@beacon.com.eg

Course 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

Course Outline

Financial Modeling :Introduction to Financial Modeling
What Is Financial Modeling? What is a Financial Model Used For? What do you need to be competent at to be a financial modeler? Financial Modeler skills· Best-Practice Principles Architecting What makes a good financial model? Design and Presentations Features of a strong financial model Tab structure Tips for creating a seamless Financial Model Formula Tips ; Circularity in Financial Model
Essential Tools & Formulas :Essential Tools & Formulas
Logical Functions· Lookup and Reference Functions Working with Text and Dates Macros in Financial Modelling
Building Up the Financial Model :Building Up the Financial Model
Main Section in every model Cover page Executive summary Headers,Footers, Inputs and assumptions Assumptions Documentation Methods Custom Formatting Data Validation
Revenue :Revenue
Building Up the Engine Scenarios Scenarioso Sensitivities and What-if Analysis Building Scenarios (Model Application) Revenue Schedule Setting up the Revenue Schedule Completing the Revenue Schedule
Cost of Goods Sold (COGS) :Cost of Goods Sold (COGS)
All Different Types of Costs Operating Costs Cost Schedule Operating Leverage Semi Variable Costs Repeat, Build and Link approach

Who Should Attend

This course is for finance professionals with strong finance and accounting knowledge and intermediate modeling skills. The course is relevant to 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.

Share