Course Outline

Financial Analysis Techniques
- Vertical analysis and strategy
- Horizontal, trend analysis, and growth
- Liquidity analysis:
  - Current, quick, and cash ratios, defensive interval, and cash conversion cycle
- Asset management and activity ratios:
  - Total and fixed assets turnover
- Solvency analysis:
  - Debt, equity, and times interest earned ratios
- Profitability analysis:
  - Profit margin, gross margin, return on assets, return on equity, EBITDA
- Market and valuation:
  - Price earnings and earnings-per-share ratios
- DuPont analysis: The three-step and five-step models
- Limitation of ratio analysis
Cash flow statement: Interpretation and ratio analysis
- Cash flow categories: Operating, investing, and financing
- Cash flow pattern; the cash cow
- Cash-flow-related ratios:
  - Quality of earnings
  - Financial management
  - Mandatory cash flow
  - Discretionary cash flow
Financial calculations in MS Excel
- Time value of money:
  - Present Value (PV) and Net Present Value (NPV)
  - Internal Rate of Return (IRR) and Multiple IRR (MIRR)
  - Using XNPV and XIRR
- Effective yields and returns
Model construction techniques using Excel
- Data tables
- Goal seek
- Spinner data modeling
- List box data modeling
- Option box data modeling
Modeling projected financial statements
- Micro and macro factors
- Forecasting sales
  - Estimating market demand
  - Estimating company demand
  - Developing sales forecast
- Forecasting cost of sales
- Forecasting operating expenses
- Forecasting key assets and liabilities accounts
- Modeling the income statement
- Modeling the balance sheet
- Modeling the cash flow statement

Schedule & Fees

2026 Schedule & Fees

USD 2,600

Per participant

20 - 24 Dec, 2026
English

USD 2,600

Per participant

20 - 24 Dec, 2026
Arabic

2027 Schedule & Fees

USD 2,600

Per participant

10 - 14 Jan, 2027
English

USD 2,600

Per participant

10 - 14 Jan, 2027
Arabic

USD 2,600

Per participant

21 - 25 Mar, 2027
English

USD 2,600

Per participant

21 - 25 Mar, 2027
Arabic

USD 2,600

Per participant

11 - 15 Apr, 2027
English

USD 2,600

Per participant

11 - 15 Apr, 2027
Arabic

USD 2,600

Per participant

20 - 24 Jun, 2027
English

USD 2,600

Per participant

20 - 24 Jun, 2027
Arabic

USD 2,600

Per participant

11 - 15 Jul, 2027
English

USD 2,600

Per participant

11 - 15 Jul, 2027
Arabic

USD 2,600

Per participant

19 - 23 Sep, 2027
English

USD 2,600

Per participant

19 - 23 Sep, 2027
Arabic

USD 2,600

Per participant

10 - 14 Oct, 2027
English

USD 2,600

Per participant

10 - 14 Oct, 2027
Arabic

USD 2,600

Per participant

19 - 23 Dec, 2027
English

USD 2,600

Per participant

19 - 23 Dec, 2027
Arabic

Financial Analysis Modeling and Forecasting

Why Attend

Course Methodology

Course Objectives

Target Audience

Target Competencies

Note

Course Outline

Schedule & Fees

2026 Schedule & Fees

2027 Schedule & Fees

Related Courses