Course Description

THE RATIONALE

This course provides a thorough working knowledge of a “best practice” platform meeting many organizational and project analytical needs. Students learn business modeling and analysis techniques with Microsoft Excel 2013 with the ultimate objective of transforming data and modeling assumptions into key metrics as well as bottom-line results of forecasts, simulations, and sensitivity analyses.

Market researchers, project managers, business analysts, economists, financial professionals, budgeters, venture capitalists, investment bankers, corporate treasurers, and operations heads are just a few examples of positions requiring a working knowledge of forecasting, evaluation, and analysis modeling. This course is hands-on, scenario-based, and involves relational data base construction and integration including use of Pivot Tables and Descriptive Statistics. Key tools included are trend analyses (i.e. multiple regression, exponential smoothing, etc.) as well as advanced Excel functions (i.e. OFFSET, INDIRECT, Power View, Solver, etc.)

 THE COURSE OBJECTIVES:

By the end of this training, participants will be able to:

• Explore forecasting, evaluation, and analysis modeling techniques to create bottom-line results of forecasts, simulations, and sensitivity analyses
• Understand and utilize trend analyses (i.e., multiple regression, exponential smoothing, etc.) as well as advanced Excel function
• Make optimal decision regarding investment
• Develop relational database construction and integration including use of Pivot Tables and Descriptive Statistics

THE COURSE OUTLINE

The course will cover the following:

• Business Performance Analysis
• Cash flow Forecast Models
• Excel Referencing and application
• Linking and worksheet Consolidation
• Forecasting Models
• Historical Forecast (Point Forecast)
• Trend Lines (Interval Forecast)
• Cyclicality and Seasonality
• Forecasting Financial Reports;
• Key Drivers
• Driving Financial Statements
• Alternative Approaches
• Variance Analysis
• Breakeven Analysis
• Breakeven
• Operating Leverage
• Financial Leverage
• Budget variance
• Budgeting and Control
• Example of Personal Budget
• Example of Company Budget
• Flexible budget model
• Fixed budget model.
• Portfolio Analysis
• Cost of Capital
• Capital Asset Pricing Model
• Dividend Growth Model
• Cost of Preference Share
• Cost of Debt
• Weighted Average Cost of Capital (WACC)
• Marginal WACC
• Investment Analysis
• Payback Period
• Accounting Rate of Returns
• Internal Rate of Return
• Net Present Value
• Loan Management and Loan Determination Schedule
• Benefit/Cost Ratio
• Capital Rationing
• Scenarios and Sensitivity Analysis and Charts
• Risk and Return Analysis
• Company Valuation
• Adjusted Accounting Valuation
• Dividends Valuation
• Market Valuation
• Free Cash flow Valuation
• Portfolio Analysis
• Optimization
• Elements of Optimization Models
• Linear Programming
• Margin Maximization
• Bayes’ Theorem
• Decision Tree Model
• Building Sensitivity analysis and Scenarios into Models
• Introduction and Application of Macro to enhance your Model

TARGET AUDIENCE

Officers in IT Departments, Middle-level and Senior Managers, Secretaries

Delivery Method: Combines lectures, discussions, group exercises and illustrations

Venue:

Fee:

Duration: 1 week

Course Date: April 17th – 21st 2023