Sale!

FINANCIAL MODELING-RIYADH

$1,099.00 $799.00

Financial Modeling With CertBuddyz

Professionals in the field of finance and other related categories have a constant task of working on substantially large numbers. MS Excel is used on a day to day basis to create required financial models in order to analyze the financial statements. After undergoing our training programme the participants will be able to work efficiently at a noteworthy speed.

Mode Of Learning: Classroom Training
Duration: 4 days
Dates: 7th, 8th September, 2018 & 14th, 15th September, 2018

Description

Financial Modeling With CertBuddyz

Professionals in the field of finance and other related categories have a constant task of working on substantially large numbers. MS Excel is used on a day to day basis to create required financial models in order to analyze the financial statements. After undergoing our training programme the participants will be able to work efficiently at a noteworthy speed.

The objective of this training programme is to teach the participants basics of MS Excel in order to help them create the required financial models. Post the training programme, the participants will be able to demonstrate their skills by building financial models that are robust and provide the projections that are used to analyze the company from various parameters

COURSE OVERVIEW

• 4 Days intensive classroom training
• Contemporary case study based teaching and study materials
• One to one interaction with the trainer
• Doubt solving session by expert even after the training
• Certificate of participation
• Networking (opportunity to meet professional from other fields)
• Practice worksheet for excel

COURSE CURICULLUM

Day 1

Day 2

 Excel as a Tool for Financial Modeling

 Projecting Cash Flow Statement

 Referencing & Excel Shortcuts for Financial Modeling

 Circular References in Cash and Interest

 Building Layout for Scalable Financial Model

 Analyzing Financial Statements with Ratios

 Building Growth Drivers for Revenue

 Corporate Finance Concepts for Financial Modeling

 Building Growth Drivers for Cost

 Key Valuation Concepts

 Building Asset and Debt Schedule

 Valuation Using DCF and Comps

 Projecting P&L and Balance Sheet

 Scenario Analysis and Building Dashboards

Day 3

Day 4

 Advanced Tools in Excel for Auditing Financial Models

 Understanding Macros

 Auditing Large Models and Complicated Formula

 Creating Flexible Dashboards & Charts Using Form Controls

 Advanced Excel Functions to Create Flexible

     Financial Models Using Index, Match and Offset Functions

 Introduction to VBA for Financial Modeling

 Mastering Financial Functions – Lease Analysis for Facebook

 Recording Macros to Break Circular References

 Advanced Charting Techniques in Excel – Creating Football Field

 Implementing Monte Carlo Simulation for Revenue Analysis –I

 Creating Dashboard for Financial Data

 Implementing Monte Carlo Simulation for Revenue Analysis –II

 

 

TARGET AUDIENCE

If you are interested in this course, you need to have working knowledge of MS Excel, cash flow statement, income statement, balance sheets and Finance.