Advanced Financial Modeling with Excel Training in Kenya

Sign Up: Here

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

• Online Training: 10 days (3- 4hrs a day)
• Classroom Training: 10 days (7 hrs a day)

Course Outline

Module 1: Introduction to Financial Modeling

• Definition and importance Finance Modelling
• Applications in various industries
• Key Concepts: Time value of money, Risk and return
• Financial statements and ratios

Module 2: Review of Basic Excel Functions and Advanced Excel Features

• Formulas and functions
• Cell referencing
• Data validation
• 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

• Sensitivity Analysis: Scenario analysis and Data tables for sensitivity
• Monte Carlo Simulation: Introduction to simulation and 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

• Industry-specific Applications - Finance, real estate, technology, etc.
• Applying learned concepts to real-world scenarios
• Peer review and feedback

Contacts

Monica C. | Training Coordinator

Cell / WhatsApp: +254 712 028 449

Email:[email protected]

Website: perk-gafrica.com

Host or Publisher Perk Group Africa