Financial Analysis Modeling and Forecasting (F01) Training Course

Financial Analysis Modeling and Forecasting

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…

5 daysClassroom or online

13Upcoming dates

7Cities

£2,750Fees from

Course overview

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 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 Objectives

By the end of the course, participants will be able to:

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

Target Audience

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.

Target Competencies

Understanding and performing financial analysis
Performing vertical, horizontal, and trend analysis
Financial forecasting
Modeling financial statements
Applying Excel functions and tools

Course outline

1Day 1: Financial Analysis Techniques
- Vertical analysis and strategy
- Horizontal, trend analysis, and growth
2Day 2: Liquidity analysis & Asset management and activity ratios and more
- 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
3Day 3: Cash-flow-related ratios & Financial calculations in MS Excel
- 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
4Day 4: Model construction techniques using Excel & Modeling projected financial statements
- 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
5Day 5: 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

Dates and fees

13 upcoming dates in 7 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF

December 2026

21DEC 21 - 25 Dec 2026Mon to Fri · 5 daysNext session

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

January 2027

18JAN 18 - 22 Jan 2027Mon to Fri · 5 days

AmsterdamNetherlands · Classroom

£4,250per delegate2+ people: £3,400 each

February 2027

15FEB 15 - 19 Feb 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£2,750per delegate2+ people: £2,200 each

March 2027

15MAR 15 - 19 Mar 2027Mon to Fri · 5 days

IstanbulTurkey · Classroom

£2,850per delegate2+ people: £2,280 each

April 2027

19APR 19 - 23 Apr 2027Mon to Fri · 5 days

ViennaAustria · Classroom

£4,250per delegate2+ people: £3,400 each

May 2027

17MAY 17 - 21 May 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

June 2027

21JUN 21 - 25 Jun 2027Mon to Fri · 5 days

ParisFrance · Classroom

£3,250per delegate2+ people: £2,600 each

July 2027

19JUL 19 - 23 Jul 2027Mon to Fri · 5 days

FrankfurtGermany · Classroom

£3,250per delegate2+ people: £2,600 each

August 2027

16AUG 16 - 20 Aug 2027Mon to Fri · 5 days

BarcelonaSpain · Classroom

£3,850per delegate2+ people: £3,080 each

September 2027

20SEP 20 - 24 Sep 2027Mon to Fri · 5 days

AmsterdamNetherlands · Classroom

£4,250per delegate2+ people: £3,400 each

October 2027

18OCT 18 - 22 Oct 2027Mon to Fri · 5 daysOur home city

LondonUnited Kingdom · Classroom

£2,750per delegate2+ people: £2,200 each

November 2027

15NOV 15 - 19 Nov 2027Mon to Fri · 5 days

IstanbulTurkey · Classroom

£2,850per delegate2+ people: £2,280 each

December 2027

20DEC 20 - 24 Dec 2027Mon to Fri · 5 days

ViennaAustria · Classroom

£4,250per delegate2+ people: £3,400 each

Live online, on the same dates

Join the class in real time from your office or home: live sessions with the trainer, group discussion, course materials and a certificate of completion. Joining details are emailed before the course starts.

December 2026

21DEC 21 - 25 Dec 2026Mon to Fri · 5 daysNext session

Live onlineVirtual classroom · join from anywhere