Financial Modeling with excel

  • An excellent working knowledge of financial modeling functions in Excel that allow you to efficiently create robust and flexible models.
  • A sound understanding of financial modeling and valuation concepts.
  • Practical experience in designing solutions to real-world financial modeling challenges by building financial models in Excel.
Overview
Course Outline
Key Features
Course Objectives

Overview

Our financial modeling course provides a sound understanding of both the principles of financial modeling and the practical application of these to real-world situations by using Excel to build financial models, our course builds upon the financial modeling principles and practices learned, to apply these to company or project valuations. In this, participants improve their mastery of valuation principles and concepts, and learn how to apply these in real-life situations with competency and expertise after our three day course in FME.

Get practical, hands-on training in powerful Excel tools that will help create financial models facilitating greater analytical accuracy. Build a solid foundation in Excel techniques that can be used to manipulate large datasets of financial information.

Course outline

  • Overview of financial modeling
  • Understanding projections
  • Excel best practices foundation and exercises
  • Useful Excel shortcuts and functions
  • Gathering historical documents / information
  • Preparation of Balance Sheet, Income and Cash Flow statements
  • Ratio Analysis
  • Du Pont Analysis
  • Financial Statement Analysis
  • Valuation of Companies
  • Valuation of IPOs
  • Valuation of Merger & Acquisitions
  • Valuation of Bonds
  • Valuation of Equity
  • Leverage Buyout Analysis (LBOs)
  • Sensitivity/Scenario Analysis
  • Monte Carlo Simulation
  • Case Study

Key Features

  • 24 hours Instructor led Online Training
  • Soft copy of study materials
  • Course Completion Certificate
  • 24 PDU Certificate
  • Flexibility to choose classes
  • Real time Practical exercises and examples
  • 100% Money Back Guarantee
  • Get exposure with experienced Trainer
  • Post training support
  • 10% discount on any other Course

Course Objectives

  • An excellent working knowledge of financial modeling functions in Excel that allow you to efficiently create robust and flexible models.
  • A sound understanding of financial modeling and valuation concepts.
  • Practical experience in designing solutions to real-world financial modeling challenges by building financial models in Excel.
  • A solid foundation for Excel-based financial modeling.
  • Excel tools and techniques that are essential for modeling to make your models robust, user-friendly, and efficient.