Foundations of Financial Analysis
• Interpreting balance sheets, income statements, and cash flow statements
• Horizontal and vertical analysis
• Ratio analysis: profitability, liquidity, efficiency, solvency
• Linking financial metrics to operational drivers

Financial Modelling Principles
• Structure and design of Excel-based financial models
• Input, processing, and output best practices
• Building dynamic assumptions and logical flows
• Auditing and troubleshooting models

Forecasting Techniques and Applications
• Forecasting revenues, costs, and capital expenditures
• Cash flow forecasting and liquidity planning
• Time series analysis and regression techniques
• Integrating historical trends with market assumptions

Scenario Planning and Sensitivity Analysis
• Developing best-case, worst-case, and base-case scenarios
• Evaluating the impact of variable changes on financial outcomes
• Monte Carlo simulation basics for advanced forecasting
• Building dashboards and reports for scenario comparison

Valuation and Investment Appraisal
• Calculating NPV, IRR, and other investment metrics
• Break-even and cost-volume-profit analysis
• Capital budgeting for project finance
• Assessing project viability under uncertainty

Advanced Excel for Modelling
• Using data tables, pivot tables, and charts
• Lookup and reference functions
• Logic, math, and financial functions
• Dashboard creation for decision support

This course is designed to bridge the gap between technical modelling skills and strategic financial planning, helping professionals drive more accurate forecasts and insightful analysis to support business resilience and growth.

Financial Analysis, Modelling & Forecasting Training Course in Cairo

Available Dates

Custom Date Selection

Available Cities

Objectives and Target Group

Course Content