Global Learning for Operational Leaders
Course F01
Financial Analysis Modeling and Forecasting
Financial professionals are often asked to provide analysis and projections of finances to help management make decision... The outline covers Financial Analysis Techniques, Liquidity analysis, Asset management and activ...
Introduction
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
What you will achieve
Learning 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
Who should attend
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
Methodology
Learning approach
- 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
Course outline and key learning areas
Module 1
Financial Analysis Techniques
- Vertical analysis and strategy
- Horizontal, trend analysis, and growth
Module 2
Liquidity analysis
- Current, quick, and cash ratios, defensive interval, and cash conversion cycle
Module 3
Asset management and activity ratios
- Total and fixed assets turnover
Module 4
Solvency analysis
- Debt, equity, and times interest earned ratios
Module 5
Profitability analysis
- Profit margin, gross margin, return on assets, return on equity, EBITDA
FAQ
Frequently asked questions
What does Financial Analysis Modeling and Forecasting (F01) cover?
This course covers Accounting and Finance through a structured five-day outline focused on practical application, discussion, and implementation planning.
When is the next available session?
The next scheduled session starts on 18 - 22 May 2026, with additional classroom dates and mirrored Online / Live options listed in the course schedules section.
Who should attend this course?
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
How can I register for a session?
Use any Register button next to the available course dates to open the participant registration page and submit your booking request for the selected session.
Is this course available online as well as classroom-based?
Yes. The course detail page includes both classroom sessions and Online / Live sessions, with online options aligned to the same course dates for easier planning.
Where are classroom sessions delivered?
Current classroom venues include Amsterdam, London, Istanbul, Vienna, Barcelona, Paris, Frankfurt.
Still Have Questions?
Contact the academy team for course details, delivery options, and delegate guidance.
Related training courses
Continue building your improvement capability
Quick request
Send quick request
Send a fast enquiry about this course and the academy team will get back to you.