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

• Building a Merger and Acquisition (M&A) Model
• 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

• 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