Course Title: Financial Modeling with Excel Master Class

Duration: 30 Hours

Cost: KES. 45,000.00

Course Description:

This intensive course is designed to provide students with a comprehensive understanding of financial modeling techniques and their application in real-world scenarios.

Participants will learn how to build financial models from scratch, analyze financial statements, and make informed business decisions.

Module 1: Introduction to Financial Modeling

  • What is Financial Modeling?
  • Importance of Financial Modeling
  • Excel Basics for Financial Modeling
  • Building a Simple Financial Model

Module 2: Financial Statement Analysis

  • Understanding Financial Statements (Income Statement, Balance Sheet, Cash Flow Statement
  • Common-Size and Trend Analysis
  • Case Study: Analyzing Financial Statements

Module 3: Forecasting and Projections

  • Time Value of Money (TVM) Concepts
  • Forecasting Sales and Expenses
  • Building a 3-Statement Model
  • Sensitivity Analysis and Scenarios

Module 4: Valuation Techniques

  • Discounted Cash Flow (DCF) Valuation
  • Comparable Company Analysis (Comps)
  • Precedent Transactions Analysis
  • Valuation Case Study

Module 5: Advanced Financial Modeling

  • Building a Merger and Acquisition (M&A) Model
  • Leveraged Buyout (LBO) Modeling
  • Scenario Analysis for M&A and LBO Models
  • Model Auditing and Error Checking

Module 6: Excel Tips and Tricks for Financial Modeling

  • Advanced Excel Functions (e.g., IF, VLOOKUP, HLOOKUP)
  • Data Validation and Error Handling
  • Keyboard Shortcuts for Efficient Modeling
  • Excel Add-Ins for Financial Modeling

Module 7: Business Case Studies

  • Real-Life Business Case Studies
  • Industry-Specific Modeling Considerations
  • Analyzing and Presenting Model Results
  • Group Project: Create and Present a Financial Model

Module 8: Risk Analysis and Monte Carlo Simulation

  • Introduction to Risk Analysis
  • Monte Carlo Simulation Basics
  • Integrating Simulation into Financial Models
  • Managing Uncertainty in Decision-Making

Module 9: Excel Automation and Macros

  • Introduction to Macros and VBA (Visual Basic for Applications)
  • Writing Basic Macros for Financial Modeling
  • Automating Repetitive Tasks in Excel
  • Debugging and Error Handling in VBA

Module 10: Final Project and Presentations

  • Independent Financial Modeling Project
  • Peer Review and Feedback
  • Final Model Presentation
  • Course Wrap-Up and Graduation
  • Assessment
OCL Learning | Training, Consulting, Certification