Back

Financial Modelling: Flexibility, Dynamics, Visibility

$
1800.00
Register
3 days | 24 academic hours

Training objectives
Training program Day 1
Training program Day 2
Training program Day 3

Training objectives

  • Master the application of essential MS Excel functions in financial modelling
  • Acquire expertise in constructing financial models that are well-structured, transparent, and testable
  • Develop flexible models capable of handling multiscenario calculations
  • Enhance proficiency in analyzing calculation results, identifying target values, and deriving optimal solutions

Training program Day 1

Modelling Operational Decisions
  • Assessment of cost behavior: Regression analysis
  • Functions: SLOPE, INTERCEPT, RSQ
  • Cost forecasting
  • Profit sensitivity analysis to changes in market conditions: Factor analysis
  • Capital profitability analysis (ROCE, ROE): scenario analysis and target value setting
  • Optimization problem-solving: Optimization of product assortment, schedules, investment portfolios, and routes. Techniques for finding optimal solutions
Modelling Investment Decisions
  • Investment decision-making techniques
  • Key financial indicators for evaluating investment projects
Spinner: Data Management Tool
  • Multi-scenario calculations within a model using the Spinner tool, along with IF and CHOOSE functions
All topics are accompanied by practical exercises

Training program Day 2

Goals and Rules of Modelling
  • Objectives of financial modelling and forecasting, and areas of application
  • Stages of model development
  • “Golden rules” of modelling
Building a high-level model for forecasting the financial condition of a company based on financial statement data.
Practice: preparation of initial data and construction of a model for a growing company
  • Analysis of calculation results. Assessment of the model’s sensitivity to changes in the initial data. Evaluation of the financing needs for growth
Practice: analysis of model calculation results and selection of a financing schedule and repayment plan using Data Table, Goal Seek, and SOLVER functions.
Building a detailed financial model of a company with consideration of its industry (example: retail).
  • Model design development, analysis of relationships between calculated indicators and modules (sheets)
  • Collection, formation, and preparation of initial data for modelling
  • Modular model construction
Practice: sequential construction of financial model modules

Training program Day 3

Continuation of building the detailed financial model
  • Execution of additional tasks using Solver