Financial Modeling with Excel

Financial Modeling with Excel

Step -by-step course on how to build a financial model with MS Excel. Course covers basic understanding of financial concepts. Further, builds on these concepts and provides comprehensive understanding of more complex valuation models.  It is appropriate for those working in corporate finance, consulting, financial planning, financial markets, and business analysts and also for general users of Excel for financial applications.
Help understand the intricacies of Financial Analysis and Modeling. Gain exposure to vast inventory of financial functions available in MS Excel. And leverage them in building robust Financial Models.

Delivery mode: Classroom/virtual classroom/online

Duration: Two full days

What will you learn?

When you complete this course, you will have total understanding of :

  • Excel Basis
  • Formulas and Functions
  • Advanced Excel features (Introducing Financial Formulas)
  • Accumulation Discounting and Amortization Functions
  • Working with Financial Statements

Course Content:

Getting Started with Excel

  • Basic facts about XL formulae
  • Essential Worksheet Operations

Working with Formulas and Functions

  • Introducing Worksheet Functions
  • Counting & Summing Techniques
  • Using Lookup Functions
  • Creating Charts and Graphs

Using Advanced Excel Features

  • Introducing Financial Formulas
    1. Time Value for Money
    2. Loan Calculation
    3. Investment Calculations
    4. Depreciation Calculations

Accumulation Discounting and Amortization Functions

  • Simple & complex Accumulation problems
  • Simple & complex Ammortization problems
  • Ammortization Problems

Working with Financial Statements

  • Balance Sheet
  • Income Statement
  • Cash Flow
  • Analyzing Financial Statements and Creating Management Financial Reports

Visit Calendar to know Schedule of this Training and to Register Online.Calender

Upcoming Trainings