Financial Modeling with Excel Training and Certification

Type: 
Training
Industry: 
FINANCIAL AND INSURANCE ACTIVITIES
64 Financial service activities, except insurance and pension funding
Date: 
14.10.2020 to 16.10.2020
Country: 
United States of America
Phone: 
+1 (480) 666-7745
E-mail: 
enquiry [at] technocerts [dot] com
Description: 

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 Financial Modeling with Excel.

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.

You will learn:

  • 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

 

For more information visit the given web-page.