Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Financial Modeling Training in Lagos, Nigeria

EduPristine Inc.

Sunday, June 4, 2017 from 9:00 AM to 5:00 PM (CAT)

Financial Modeling Training in Lagos, Nigeria
Available Dates
No tickets available for upcoming dates

Ticket Information

Ticket Type Sales End Price Fee Quantity
Limited offer Ended $450.00 $12.24

Share Financial Modeling Training in Lagos, Nigeria

Event Details

EduPristine Inc. is coming up with a 2 full days Financial Modeling Bootcamp in Lagos.

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

Unique Offerings of EduPristine's Financial Modeling MasterClass:

  • 2 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 Lagos, Nigeria? Contact EduPristine Inc.

When & Where

African Sun Amber Hotel Mutare

Mutare, Manicaland Province

Sunday, June 4, 2017 from 9:00 AM to 5:00 PM (CAT)

  Add to my calendar


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:

  Contact the Organizer

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.