Financial Modelling
الحصول على الكتيب
للحصول على كتيب بكامل محتويات الدورة برجاء ملء النموذج التالي ببياناتك الصحيحة
Program Professional Framework
Financial Modelling
Program Overview
Boards, lenders and investment committees base major decisions on spreadsheet models that are often poorly structured and hard to audit. «Financial Modelling» teaches the discipline behind a reliable model: defining the question, model architecture and best-practice standards such as FAST, separating inputs, calculations and outputs, building linked three-statement models, valuation with discounted cash flow, scenario and sensitivity analysis, and systematic model review. Examples include corporate budgets, acquisitions and infrastructure investments typical of the GCC market.
Learning Outcomes
- ✓Define a model's purpose, scope and key outputs before building begins.
- ✓Structure a model with separate input, calculation and output areas following recognised best-practice standards.
- ✓Build a linked three-statement model with balancing checks.
- ✓Value a business or project using discounted cash flow and an appropriate discount rate.
- ✓Design scenario and sensitivity analysis that answers the decision makers' questions.
- ✓Review a model for logic, formula and assumption errors and document the findings.
Target Audience
- Financial analysts and modellers
- Corporate development and investment professionals
- FP&A managers
- Bankers and consultants who build or review models
Detailed Program Modules
01Purpose and Design of Models
- Defining the decision and key questions
- Model specification and scope
- Common modelling errors and their consequences
02Model Structure and Standards
- Inputs, calculations and outputs separation
- FAST and other best-practice principles
- Timing, flags and consistent formulas
03Three-Statement Modelling
- Revenue and cost forecasting
- Working capital, capex and depreciation schedules
- Debt, interest and balance sheet integrity
04Valuation
- Free cash flow to firm and equity
- WACC and terminal value
- Equity bridges and valuation outputs
05Scenarios and Sensitivities
- Scenario switches and selectors
- Data tables and sensitivity outputs
- Breakeven analysis
06Model Review and Presentation
- Integrity checks and error traps
- Structured model review process
- Presenting results to decision makers
Training Methodology
Applied Project & Assessment
Applied Project
Participants specify and build a three-statement model and DCF valuation for a provided company, add scenario switches and sensitivities, then exchange models with a peer for a structured review and present an investment recommendation.
Assessment
Short diagnostic at the start, practical tasks linked to each learning outcome, and evaluation of the applied project against published criteria.