Financial Modeling with Excel Training

Welcome to the Financial Modeling Training Program!

In this course, you will embark on a journey to master the art of financial modeling using Microsoft Excel. Whether you’re a finance professional, student, or aspiring analyst, this training will equip you with the essential skills to construct robust financial models.

Throughout the program, you’ll delve into creating income statements, balance sheets, and cash flow statements. Gain proficiency in Excel functions, formula intricacies, and scenario analysis. By the end, you’ll have the expertise to project and analyze financial performance, aiding strategic decision-making.

Course Objectives

By the end of the course, participants will be able to:

  • Prepare effective financial models utilizing powerful Excel functions
  • Use core financial modeling techniques
  • Forecast investments, and calculate valuations of projects and companies in an effective manner
  • Develop comprehensive financial models to support investments decisions

Target Participants

This courses is aimed at corporate finance professionals, CFOs, financial controllers, finance managers, financial analysts and business development analysts.

Course Duration

Live Online Training24 Hours
Class Room Training21 Hours
Training Options

Course Outline

  • Introduction to Financial Modeling in Excel
  • Key Excel functions used in Financial modeling
  •  Advanced range names, including formulas and naming conventions
  • Pivot Tables
  • Scenarios, sensitivity, data tables
  • Best practice guidelines and spreadsheet modeling standards

Financial Modeling Overview

  • Modeling fundamentals
  • Steps in model building
  • Key concepts

Model Components

  • Capital budgeting & depreciation modeling
  • Debt modeling
  • Capital Structure
  • Ratio analysis
  • Tax considerations
  • Inflation
  •  Reporting considerations: changing timescales, changing currencies, units

Specific Purpose Modeling

  • Company valuation & financial statement simulation
  • Project finance modeling
  • Mergers & Acquisitions Analysis
  • Divestiture

Advanced Financial Modeling Applications

  • Multi-variable Monte Carlo Simulations
  •  Advanced MapReduce
  • Introduction to VBA Macros: useful functions and macros, and how to apply these to models
  •  Advanced Charting techniques
  • Advance Excel Dashboards

Training Approach

This Financial Modeling with Excel Training is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

Training manuals and additional reference materials are provided to the participants.

Financial Modeling Certification

Upon successful completion of this course, participants will be issued with a certificate.

Financial Modeling Course Fees:

USD 300.00/Kes. 32,000.00 | Discount for Groups