Food Security and Agriculture

Training Course on Advanced Financial Modeling with Excel

Course Overview

This comprehensive training course is designed to equip participants with essential skills in financial modeling using Microsoft Excel. Financial modeling is a crucial skill for finance professionals, analysts, and decision-makers, enabling them to make informed and strategic business decisions. Throughout the course, participants will gain hands-on experience in building financial models, analyzing data, and creating insightful reports.

Course Duration: 10 days

Course Outline

Module 1: Introduction to Financial Modeling

1.1 Overview of Financial Modeling

  • Definition and importance
  • Applications in various industries

1.2 Key Concepts

  • Time value of money
  • Risk and return
  • Financial statements and ratios

Module 2: Excel Basics for Financial Modeling

2.1 Review of Basic Excel Functions

  • Formulas and functions
  • Cell referencing
  • Data validation

2.2 Advanced Excel Features

  • Named ranges
  • Data tables and scenarios
  • Goal Seek and Solver

Module 3: Building Financial Statements

3.1 Income Statement Modeling

  • Revenue projections
  • Expense forecasting
  • Depreciation and amortization

3.2 Balance Sheet Modeling

  • Asset, liability, and equity forecasting
  • Working capital management

3.3 Cash Flow Statement Modeling

  • Operating, investing, and financing activities
  • Free cash flow calculations

Module 4: Advanced Excel Tools for Analysis

4.1 Sensitivity Analysis

  • Scenario analysis
  • Data tables for sensitivity

4.2 Monte Carlo Simulation

  • Introduction to simulation
  • Building simulations in Excel

Module 5: Valuation Techniques

5.1 Discounted Cash Flow (DCF) Modeling

  • Estimating cash flows
  • Determining discount rates
  • Terminal value calculations

5.2 Comparable Company Analysis (CCA)

  • Identifying comparable companies
  • Analyzing valuation multiples

Module 6: Financial Model Audit and Error Checking

6.1 Best Practices for Model Design

  • Modularity and flexibility
  • Documenting assumptions and formulas

6.2 Model Auditing Techniques

  • Error-checking and validation
  • Debugging and troubleshooting

Module 7: Automation with Macros and VBA

7.1 Introduction to Macros

  • Basic recording and execution

7.2 VBA (Visual Basic for Applications) Fundamentals

  • Variables, loops, and conditions
  • Creating custom functions

7.3 Automation in Financial Modeling

  • Streamlining repetitive tasks
  • Building interactive dashboards

Module 8: Real-life Case Studies and Projects

8.1 Industry-specific Applications

  • Finance, real estate, technology, etc.

8.2 Group Projects

  • Applying learned concepts to real-world scenarios
  • Peer review and feedback

Note: This outline provides a general structure for a 10-day training program on Advanced Financial Modeling with Excel. The specific content, activities, and duration of each session may be adjusted based on the target audience, learning objectives, and available time.

Classroom Training Schedule

Start Date End Date Location Cost Apply
Jun 03, 2024 Jun 14, 2024 Nairobi $ 1800 Register
Jul 08, 2024 Jul 19, 2024 Nairobi $ 1800 Register
Aug 12, 2024 Aug 23, 2024 Nairobi $ 1800 Register
Sep 16, 2024 Sep 27, 2024 Nairobi $ 1800 Register
Oct 21, 2024 Nov 01, 2024 Nairobi $ 1800 Register
Nov 25, 2024 Dec 06, 2024 Nairobi $ 1800 Register

Virtual Training Schedule

Start Date End Date Location Cost Apply
May 13, 2024 May 24, 2024 Online $ 700 Register
Jun 17, 2024 Jun 28, 2024 Online $ 700 Register
Jul 22, 2024 Aug 02, 2024 Online $ 700 Register
Aug 26, 2024 Sep 06, 2024 Online $ 700 Register
Sep 30, 2024 Oct 11, 2024 Online $ 700 Register
Nov 04, 2024 Nov 15, 2024 Online $ 700 Register
Dec 09, 2024 Dec 20, 2024 Online $ 700 Register

Registration Process

Enrolling in our training programs is effortless! Upon submitting your details on the course registration link, a representative will get in touch with the relevant information.

Group Discounts

Boost your team's skills and maximize value with our attractive group discounts. Enroll 3 or more participants and enjoy significant discounts on any of our training programs.

Course Language

This Training course is offered in ENGLISH . Please indicate the language of choice during registration.

Training Approach

Our instructor-led trainings use well guided presentations, practical exercises, and group acivities. Participants are encouraged to bring any data relevant to their job responsibilities. Training manuals and additional reference materials are provided to the participants.


Upon completion of training, the participant will be issued with a certificate of Completion.

Post Training Support

Our commitment our clients success extends beyond the training program. We offer ongoing 3 months support through Q&A sessions, online forums, and access to our expert instructors.

Tailor-Made Course

We design customized training programs and inhouse workshops to meet specific training needs and organizational goals. Contact us to find out more: