Skip Main Navigation
Page Content

Save This Event

Event Saved

Financial Modeling Training in Beirut, Lebanon

EduPristine Inc.

Saturday, March 18, 2017 at 9:00 AM - Sunday, March 26, 2017 at 5:00 PM (EET)

Financial Modeling Training in Beirut, Lebanon

Ticket Information

Ticket Type Sales End Price Fee Quantity
Limited Offer Dec 27, 2016 $999.00 $19.95

Who's Going

Loading your connections...

Share Financial Modeling Training in Beirut, Lebanon

Event Details

EduPristine Inc. is coming up with a 4 full days Financial Modeling Bootcamp in Beirut.

After completing the course, you can expect to:

  • Design & Structure various financial problems and translate them to Excel
  • Learn the process to create robust, easy-to-maintain financial models in Excel
  • Learn smart use of Excel and VBA macros for preparing models
  • Implement Sensitivity Analysis
  • Learn Charting techniques and Create Dashboards
  • Understand techniques to quickly audit robust models
  • Strengthen Decision Making & Business Modeling Skills

Day Wise Schedule:

Day 1 – Financial Modeling Fully Integrated Model

Financial Modeling Principles:

  • Overview:
    • o   Overview of Fully Integrated Model
    • o   Keyboard shortcuts for efficient model building
    • o   Formulas and cross referencing
    • Creating a financial model template
      • o   Formatting numbers in Excel
      • o   Conditional formatting
      • o   Creating a consistent template for modeling
      • Historical financial statement modeling (P&L and B/S)
        • o   Data Gathering from Annual Reports (10K filling)
        • o   Creating the historical statements and linking derived numbers

Modeling Growth Drivers, Depreciation, Cost Drivers, Asset & Debt Schedules:

  • Calculating growth drivers
    • o   Gathering Data for growth drivers from research reports and other sources
    • o   Calculating P&L growth numbers/ CAGR
    • o   Calculating P&L ratios
    • o   Calculating Balance Sheet ratios
    • Building assumptions and projections
      • o   Building assumptions for P&L and B/S
      • o   Linking assumptions for P&L (Except depreciation and Interest)
      • o   Linking assumptions for Balance Sheet (Except Fixed Assets and Debt)
      • Building the Asset and depreciation schedule

Day 2 – Financial Modeling Fully Integrated Model

Valuation Principles:

  • Building Debt & Interest schedule (Without circular referencing)

Projecting Cash Flow Statement:

  • Building Cash flow statement
    • o   Understanding cash from operations, investing and financing activities
    • Building interest on excess cash and cash revolver
      • o   Using Excel for Iteration – Goal Seek & circular referencing
      • o   Linking cash revolver and interest to Cash flow, B/S and P&L
      • o   Formula navigation and debugging errors in excel
      • o   Handling errors in Excel – Iserror function

Financial Ratio Analysis:

  • Building rations for analysis
    • o   Understanding liquidity ratios
    • o   Understanding profitability ratios

Valuation using DCF & Comps:

  • Updating integrated model for valuation analysis
    • o   Understanding and building trading comps
    • o   Understanding and building transaction comps
    • o   Understanding and building DCF (Discounted Cash Flow)
    • o   Building free cash flow to firm & equity
    • o   Understanding and estimating levered and unlevered beta
    • o   Understanding & estimating WACC
    • o   Understanding terminal value
    • o   Using data-validation to improve sheet structure

Day 3 – Financial Modeling Fully Integrated Model

Advanced Tools in Excel for Auditing Financial Models:

  • Introduction and context in Advanced functions for modeling
    • o   Named ranges as methodology for modeling
    • o   Case: Selecting the relevant revenue
    • o   Use Index to get the relevant value
    • o   Case: Portfolio analysis
    • o   Case: Creating flexible models for scenarios
    • o   Case: Flexible model generation
    • o   Deferred Tax and Loss carried forward

Mastering Financial Functions:

  • Formula Auditing
    • o   Excel Audit shortcuts
    • o   Formula Auditing: Road Model
    • o   Evaluate Formula

Advanced Functions, Tools & Charting:

  • Advanced Charting Technique:
    • o   Building Primary & Secondary Axis in a Chart
    • o   Tracking the progress of the construction of the commercial property: Radar Charts
    • o   Summary of Valuation
    • o   Creating Football Charts
    • o   Stacked bar charts

Day 4 – Financial Modeling Fully Integrated Model

Understanding Macros & VBA:

  • Introduction to Macros & Advanced Application Building in Excel
    • o   Introduction and context
    • o   Key concepts in Macros
    • o   Macros as recorded Robots
    • Designing application to gather user data
      • o   Implementing user forms in Excel Macros
      • o   Linking forms to excel cells
      • o   Building flexible charts in excel

Understanding Macros & VBA for Financial Modeling:

  • Understanding VBA and debugging
    • o   Understanding the relevant language constructs
    • o   Example: Write your First Macro
    • o   Errors in VBA
    • o   Steps into VBA
    • o   Writing VBA codes
    • o   Random Number Generator: Use of loop, Excel functions
    • o   Message box, input box

Implementing Monte Carlo Simulation:

  • Advanced Financial Applications
    • o   Breaking circular loops
    • o   Monte Carlo Simulation

Unique Offerings of EduPristine's Financial Modeling MasterClass:

  • 4 Full Days Classroom Training by Industry Experts
  • 20 hours of Video Tutorials
  • Sample Financial Models, Example Workbooks, PDF guides
  • Unfilled and Filled Excel Templates for Practice
  • 24 x 7 support for Doubt Clearing

Please enrol yourself at the earliest since regisrtation is going to close soon.
Looking forward for your active participation.

Have questions about Financial Modeling Training in Beirut, Lebanon? Contact EduPristine Inc.

Save This Event

Event Saved

When & Where


Ramada Hotel Beirut

Beirut, Beirut Governorate
Lebanon

Saturday, March 18, 2017 at 9:00 AM - Sunday, March 26, 2017 at 5:00 PM (EET)


  Add to my calendar

Organizer

EduPristine Inc.

About EduPristine Inc.:

EduPristine holds a profound history in training professionals across the globe. We have been an International Authorized Training provider for various professional courses since past 8+ years and have helped 95000+ working professionals.

It is registered with PMI-USA, IASSC, AXELOS, PEOPLECERT, HRCI, DMA-UK, Google, GARP, PRMIA, CFA Institute as international registered training provider and this makes us the most trusted name in the USA, Middle East, Africa, UK, Germany, Australia, Singapore, Hong Kong, Kenya, and South Africa.

 

Company Profile: http://downloads.edupristine.com/Documents/Corporate_PPT.pdf

  Contact the Organizer
Financial Modeling Training in Beirut, Lebanon
Things to do in Beirut Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.