Course schedules

Upcoming dates Classroom

Start date	End date	Location	Fee	Registration
19 Oct 2026	23 Oct 2026	Paris - France	€2,250 + VAT	→
2 Nov 2026	6 Nov 2026	Frankfurt - Germany	€1,625 + VAT	→
21 Dec 2026	25 Dec 2026	Barcelona - Spain	€1,925 + VAT	→
18 Jan 2027	22 Jan 2027	Amsterdam - Netherlands	€2,125 + VAT	→
15 Feb 2027	19 Feb 2027	London - United Kingdom	€2,100 + VAT	→
15 Mar 2027	19 Mar 2027	Istanbul - Türkiye	€1,425 + VAT	→
19 Apr 2027	23 Apr 2027	Vienna - Austria	€2,125 + VAT	→
17 May 2027	21 May 2027	Barcelona - Spain	€1,925 + VAT	→

Request an in-house date

Online live Remote

19 - 23 October 2026 €1,050 + VAT → 2 - 6 November 2026 €1,050 + VAT → 21 - 25 December 2026 €1,050 + VAT → 18 - 22 January 2027 €1,050 + VAT → 15 - 19 February 2027 €1,050 + VAT → 15 - 19 March 2027 €1,050 + VAT → 19 - 23 April 2027 €1,050 + VAT → 17 - 21 May 2027 €1,050 + VAT →

Why Attend

Financial professionals are often asked to provide analysis and projections of finances to help management make decisions. By attending this course, you will be able to prepare and build financial analysis models effectively, understand and analyze the time value of money, and prepare forecasted financial statements.

Course Objectives

Use financial ratio analysis to interpret organizational financial performance and position
Calculate financial ratios related to the cash flow statement
Utilize Microsoft Excel in the time value of money calculations
Apply MS Excel modeling tools and functions such as spinner, list box, option button, etc.
Forecast and build models for the three main financial statements

Designed for

This program is intended for professionals involved in Accounting and Finance.

Financial controllers, analysts, finance and accounting managers, supervisors, and finance professionals who need to interpret and analyze financial statements and use them to create financial forecast models in their organizations.

Course Methodology

The course is a hands-on workshop that applies MS Excel to model financial analysis and forecasting through different exercises and case studies.

Course content

Day1

Financial Analysis Techniques

Vertical analysis and strategy
Horizontal, trend analysis, and growth

Day2

Liquidity analysis:

Current, quick, and cash ratios, defensive interval, and cash conversion cycle

Day3

Asset management and activity ratios:

Total and fixed assets turnover

Day4

Solvency analysis:

Debt, equity, and times interest earned ratios

Day5

Profitability analysis:

Profit margin, gross margin, return on assets, return on equity, EBITDA
Day 6: Market and valuation:
Price earnings and earnings-per-share ratios
DuPont analysis: The three-step and five-step models
Limitation of ratio analysis
Day 7: Cash flow statement: Interpretation and ratio analysis
Cash flow categories: Operating, investing, and financing
Cash flow pattern; the cash cow
Day 8: Cash-flow-related ratios:
Quality of earnings
Financial management
Mandatory cash flow
Discretionary cash flow
Day 9: 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
Day 10: Model construction techniques using Excel
Data tables
Goal seek
Spinner data modeling
List box data modeling
Option box data modeling
Day 11: Modeling projected financial statements
Micro and macro factors
Day 12: 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

The certificate

SPARK Training Certificate of Completion is awarded to participants who attend and complete the full training course.