We apologize for any inconvenience you may experience while using the website as it is currently undergoing updates.

Ok!

Cities

Zurich

Financial Analysis, Modelling & Forecasting

ID  295

Finance and Accounting Training Courses

Financial Analysis, Modelling & Forecasting

Zurich

Hotel Name
Hotel Meeting Room

07 Apr 2025 : 11 Apr  2025

25 Hours

5450 USD

Course Application Form

Candidate Data

Candidate full name *
Email *
Private phone number *

Work phone number

Country & City *
Company / Employer *

Invoice Recipient Data

Recipient name *
Recipient phone number *

Recipient email

Recipient work address details



Sending course brochure to my e-mail

Please leave us your contacts, and we will call you back as soon as possible

Full name *
Email *

Private phone number



Call me back

Please leave us your contacts, and we will call you back as soon as possible

Full name *
Private phone number *
Company / Employer *


Course Inquiry

Please provide us with your contacts with your inquiry, and we will answer it as soon as possible

Full name *
Email *
Private phone number *
Country & City *
Company / Employer *

Your Inquiry



In-house proposal

Please provide us with your contacts and the details of the needed in-house proposal, and we will contact you as soon as possible

Full name *
Email *
Private phone number *
Country & City *
Company / Employer *

Your Inquiry



Course-options

Training Details

Introduction

A thorough grasp of the principles of financial analysis is a key competency needed for effective management of a business. This 5 day interactive program goes far beyond the typical financial analysis program. It uses both the principles of analysis and the power of Excel® to identify the strategic drivers that can dramatically enhance the shareholder value of your organization. Using Excel®, delegates will:

  • Develop the basics of strategic financial planning
  • Apply the latest financial analysis techniques
  • Use the tools of finance, such as the time value of money
  • Determine key performance indicators in order to manage the drivers of business success
  • Create tools to use within their own business

Seminar Objectives

On completion of this seminar delegates will be able to:

  • Identify the key steps in developing a financial model
  • Analyse a company’s annual report identifying key performance indicators in order to understand what the numbers are really saying and make projections of future performance
  • Understand the theory of interest and the time value of money and their applications
  • Develop an Economic Value-Added model to see the organization from the shareholders’ perspective
  • Project the benefit of Capital Investment
  • Learn how to use Excel® tools such as Solver, Goal Seeker, and Scenario

Training Methodology

The training comprises teaching sessions covering each topic with demonstrations of the applications on each of the topics. Delegates then use the templates prepared in order to apply the knowledge gained on each section to short case studies, using Excel®. Additional practice cases are available for delegates who may develop the proficiencies more swiftly.

Organisational Impact

Delegates will be confronted with the issues in financial management and analysis which are needed in order to be effective financial managers. They will emerge with:

  • A thorough understanding of the objectives of profitability and efficiency, essential for companies to succeed in a competitive environment
  • The skill to use Excel® as a tool to assist in resolving issues
  • Skills in basic modelling techniques which will enable them to build models appropriate to their company and industry.
  • A greater understanding of the financial drivers of an organisation
  • The ability to create “what if?” scenarios
  • The skills to impact upon return on investment

Personal Impact

By attending the seminar each person will:

  • Develop an improved understanding of financial drivers
  • Recognise the necessity of return on investment as an imperative for the company by which they are employed
  • Improve their knowledge of the many applications of Excel® and their confidence in using this package
  • Improve their career prospects
  • Impact upon shareholder value
  • Develop greater confidence in discussing financial strategy

Who Should Attend?

  • All financial professionals
  • Financial management
  • Department heads
  • Internal auditors
  • Project professionals
  • Sales and marketing professionals
  • R&D professionals
  • and anyone who needs to understand the short and long-term financial impact of key decisions

Programme Outline

Day 1 – Introduction and overview of Financial Modelling and the International Business Environment

  • Define the Terms Model and Financial Model
  • Learn the 10 steps to create good Financial Models
  • Use Flowcharting Techniques to improve your model
  • Overview of the strategic and operational aspects of a global business entity
  • The Organizational Planning Model
  • The Product/Decision/Information Cycle
  • The Objectives of Financial Analysis
  • Creating wealth by adding value
  • Basic metrics of wealth creation and financial performance

Day 2 – Analysing the Annual Report and Creating Shareholder Value

  • Ratio Analysis – The heart of Financial Analysis
  • Use Excel® templates to calculate and interpret liquidity, leverage and profitability ratios
  • Interpret the results of ratio analysis from an accrual accounting perspective
  • The inter-relationship between the DuPont Formula and EVA®
  • How to use the Altman Z-Score
  • Use various investment surveys to benchmark the results of financial analysis
  • What constitutes “Shareholder Value?”
  • Finding the cost of equity
  • Determine the Cost of Debt, Preferred Equity and Common Equity
  • Calculate Weighted Average Cost of Capital (WACC)
  • Develop the EVA© Model
  • Impact of Acquisitions on WACC

Day 3 – The Time Value of Money and the Steps in Building Financial Models

  • The impact time has on the value of money
  • Understand the various interest calculations
  • Using WACC and ROIC as benchmarks
  • Use Excel®, to determine Present Value, Future Value, Net Present Value, Internal Rate of Return, Modified Internal Rate of Return
  • Using IRR as a basis for capital project evaluation
  • Situations that require models
  • Models and Shareholder Value (EVA®)
  • Identification of Forecast Validation Criterion
  • Determination of Model and Forecast Horizons
  • The recognition of risk in forecasts
  • The Role of Assumptions in Financial Forecasting

Day 4 – Evaluating Capital Project Proposals and Effective Management of Historical Data Using Excel®

  • Identify the various types of capital projects
  • Discuss the capital project evaluation process
  • Determining the initial and subsequent capital project cash flows
  • Development of the “Hurdle Rate” for capital projects
  • Discuss the use of “Terminal Value” in evaluating capital projects
  • Use Excel® to evaluate capital projects by applying NPV, IRR, and Discounted Payback models
  • Understanding the Approaches Used to Build Financial Forecasting Models
  • Recognizing the Basic Patterns Inherent in Historical Data
  • Using the Exploratory Data Analysis Tools Available in Excel®
  • Key Factors in Determining the Proper Time Horizon to Choose for Your Model
  • Determining Degrees of Reliability in Model Projections
  • Selecting the Degree of Robustness and Sensitivity of the Model

Day 5 – Use of Time Series Analysis and Evaluating Investment Portfolio’s

  • Development of Time Series Models using histograms, moving averages, exponential smoothing, and regression analysis
  • Mastering the use of Exponential Smoothing as a Data Analysis tool
  • Validation of Time Series Analysis
  • Appreciate the Meaning and Importance of Sensitivity Analysis
  • Developing “What-if” Scenarios in Your Financial or Operational Models
  • Using the Excel tools “Scenario and Goal Seek”
  • Principles of risk measurement in individual shares
  • Graphing expected return and risk using variance analysis
  • Modern portfolio theory using the capital asset pricing model
  • Managing a balanced portfolio
  • Use Excel® to determine the beta of listed share on a securities market

Day 1 - Asset Cost Management Introduction

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 2 - Laying the Groundwork

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 3 - Applying the Value based Process

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

Day 4 - Ensuring the Continuity of the Value-based Process

Maintenance & Reliability Best Practices are critical for every successful individual and company. This workshop delivers many practical and new Maintenance and Reliability Best Practices concepts and tools. You will discuss these concepts and practice using practical tools in case studies and discussion groups. The costs associated with equipment downtime and reduced production can be significant. Learning how to effectively manage all aspects of your industrial facility is a must.This workshop is a combination of instructor lead topic areas and class discussions. Interactive discussions will allow you to hear and learn best in class applications relating to maintenance planning and cost management strategies. You will have the opportunity to ask lots of questions in order to consider how best to apply these tools and techniques in your organization.

The European Quality of Training and Management Consulting relies on advanced methodology in developing skills and enhancing the effectiveness of human resources. The company adopts modern methods to achieve these goals. In order to achieve its objectives, European Quality follows the following steps in a precise and professional manner:

  • Lectures and Visual Presentations:

    • Theoretical lectures are presented through PowerPoint presentations, videos, and short films, providing a comprehensive and enjoyable learning experience.

  • Scientific Assessment:

    • Trainees are thoroughly assessed before and after the training program to ensure the desired objectives are achieved and to provide necessary guidance.

  • Brainstorming and Role-playing:

    • Innovation and problem-solving are encouraged through brainstorming sessions and role playing experiences.

  • Practical Cases:

    • Practical learning is emphasized through cases relevant to the subject matter and the nature of work for the trainees, contributing to the development of practical skills.

  • Final Evaluation and Certificates:

    • A comprehensive assessment is conducted at the end of the program. Trainees are awarded attendance and participation certificates recognized by the European Quality for Training and Administrative Consultations, provided they have completed at least 80% of the program days.

  • Training Materials:

    • Professional trainers and experts in various fields create scientific and practical training materials, which are printed and retained, and distributed on CD or flash drives to ensure easy access to the content.

  • Post-Training Follow-up:

    • European Quality for Training and Administrative Consultations provides continuous support after the training program. This support includes additional consultancy sessions or workshops to ensure the continuity of learning and the application of acquired skills in the working environment.

  • Customized Training Programs:

    • Training programs are designed to meet the needs of individual companies and institutions. Client needs are carefully analyzed to ensure that the training content aligns with their specific objectives and achieves the desired impact.

  • Utilizing Technology:

    • Training incorporates modern techniques such as online platforms and distance learning to provide flexible and effective learning experiences. Participants can access educational resources online and engage in discussions and online workshops.

  • Specialized Trainers:

    • Trainers and lecturers are carefully selected to ensure they have high expertise in their fields. Experience and professionalism are added to the training to ensure the delivery of high-quality content and effective learning experiences.

  • Encouraging Participation:

    • European Quality encourages active participation and interaction during training sessions. Interactive activities such as group discussions and collective exercises are organized to stimulate effective participation in the learning process.

  • Focus on Personal Transformation:

    • Participants are encouraged to think critically and develop problem-solving skills and decision making abilities. They are guided towards achieving personal and professional transformation, leading to improved performance in their work areas.

  • Continuous Assessment:

    • Continuous assessments are provided to evaluate participants performance and their understanding of the training materials. This assessment is used to modify the training program if necessary and ensure the desired results are achieved.

  • Terms and Conditions:

    • Terms and conditions apply to all training programs. It is assumed that registering for any training program implies the participants agreement to these terms, including registration, payment, and cancellation policies.

  • Prices and Discounts:

    • It is noted that the prices displayed on the website do not include a 5% value added tax. All prices are subject to discounts according to the companys policies.

European Quality of Training and Management Consulting reserves the right to change the location of the training program, change the accredited lecturers for program delivery, hold, or cancel the program in line with the companys vision and program conditions and our quality policy.

European Quality for Training and Consultancy is certified

ISO 9001-2015

All rights reserved

Course Options

?>
Training other dates & Locations
86
27 Jan 2025   :  31 Jan 2025
London
4950$
02 Feb 2025   :  06 Feb 2025
Dubai
2950$
03 Feb 2025   :  07 Feb 2025
Madrid
4950$
09 Feb 2025   :  13 Feb 2025
Kuwait
3250$
10 Feb 2025   :  14 Feb 2025
Barcelona
4950$
16 Feb 2025   :  20 Feb 2025
Dubai
2950$
17 Feb 2025   :  21 Feb 2025
Beijing
4950$
23 Feb 2025   :  27 Feb 2025
Amman
2950$
24 Feb 2025   :  28 Feb 2025
Jakarta
3450$
02 Mar 2025   :  06 Mar 2025
Jeddah
2950$
02 Mar 2025   :  06 Mar 2025
Dubai
2950$
07 Apr 2025   :  11 Apr 2025
Zurich
5450$
07 Apr 2025   :  11 Apr 2025
Jakarta
3450$
13 Apr 2025   :  17 Apr 2025
Dubai
2950$
14 Apr 2025   :  18 Apr 2025
Amsterdam
4950$
20 Apr 2025   :  24 Apr 2025
Sharm El Sheikh
2950$
20 Apr 2025   :  24 Apr 2025
Casablanca
3950$
28 Apr 2025   :  02 May 2025
Paris
4950$
04 May 2025   :  08 May 2025
Dubai
2950$
05 May 2025   :  09 May 2025
Vienna
4950$
12 May 2025   :  16 May 2025
Munich
4950$
18 May 2025   :  22 May 2025
Manama
2950$
18 May 2025   :  22 May 2025
Dubai
2950$
25 May 2025   :  29 May 2025
Alkhobar
2950$
26 May 2025   :  30 May 2025
Toronto
5950$
02 Jun 2025   :  06 Jun 2025
Istanbul
2950$
08 Jun 2025   :  12 Jun 2025
Salalah
3450$
09 Jun 2025   :  13 Jun 2025
Stockholm
4950$
16 Jun 2025   :  20 Jun 2025
Geneva
4950$
16 Jun 2025   :  20 Jun 2025
Boston
6950$
23 Jun 2025   :  27 Jun 2025
Roma
4950$
29 Jun 2025   :  03 Jul 2025
Dubai
2950$
30 Jun 2025   :  04 Jul 2025
Prague
4950$
30 Jun 2025   :  04 Jul 2025
San Francisco
6950$
06 Jul 2025   :  10 Jul 2025
Dubai
2950$
07 Jul 2025   :  11 Jul 2025
Dublin
4950$
14 Jul 2025   :  18 Jul 2025
Athens
4950$
14 Jul 2025   :  18 Jul 2025
Hong Kong
5950$
21 Jul 2025   :  25 Jul 2025
California
6950$
21 Jul 2025   :  25 Jul 2025
Washington
6950$
27 Jul 2025   :  31 Jul 2025
Riyadh
2950$
27 Jul 2025   :  31 Jul 2025
Cairo
2450$
03 Aug 2025   :  07 Aug 2025
Dubai
2950$
04 Aug 2025   :  08 Aug 2025
Kuala Lumpur
3950$
10 Aug 2025   :  14 Aug 2025
Doha
3650$
11 Aug 2025   :  15 Aug 2025
London
4950$
18 Aug 2025   :  22 Aug 2025
Madrid
4950$
24 Aug 2025   :  28 Aug 2025
Kuwait
3250$
25 Aug 2025   :  29 Aug 2025
Beijing
4950$
31 Aug 2025   :  04 Sep 2025
Amman
2950$
01 Sep 2025   :  05 Sep 2025
Milan
4950$
07 Sep 2025   :  11 Sep 2025
Dubai
2950$
07 Sep 2025   :  11 Sep 2025
ON LINE
1750$
08 Sep 2025   :  12 Sep 2025
Jakarta
3450$
08 Sep 2025   :  12 Sep 2025
Zurich
5450$
14 Sep 2025   :  18 Sep 2025
Sharm El Sheikh
2950$
14 Sep 2025   :  18 Sep 2025
Jeddah
2950$
22 Sep 2025   :  26 Sep 2025
London
4950$
22 Sep 2025   :  26 Sep 2025
Amsterdam
4950$
22 Sep 2025   :  26 Sep 2025
Lisbon
4950$
28 Sep 2025   :  02 Oct 2025
Dubai
2950$
28 Sep 2025   :  02 Oct 2025
Casablanca
3950$
06 Oct 2025   :  10 Oct 2025
Paris
4950$
06 Oct 2025   :  10 Oct 2025
Florida
6950$
13 Oct 2025   :  17 Oct 2025
Geneva
4950$
13 Oct 2025   :  17 Oct 2025
Cape Town
5450$
20 Oct 2025   :  24 Oct 2025
Munich
4950$
20 Oct 2025   :  24 Oct 2025
Vienna
4950$
26 Oct 2025   :  30 Oct 2025
Dubai
2950$
27 Oct 2025   :  31 Oct 2025
Istanbul
2950$
27 Oct 2025   :  31 Oct 2025
Cyprus (Larnaka)
4950$
03 Nov 2025   :  07 Nov 2025
Barcelona
4950$
03 Nov 2025   :  07 Nov 2025
Toronto
5950$
09 Nov 2025   :  13 Nov 2025
Alkhobar
2950$
09 Nov 2025   :  13 Nov 2025
Manama
2950$
17 Nov 2025   :  21 Nov 2025
Stockholm
4950$
23 Nov 2025   :  27 Nov 2025
Dubai
2950$
24 Nov 2025   :  28 Nov 2025
Boston
6950$
30 Nov 2025   :  04 Dec 2025
Dubai
2950$
01 Dec 2025   :  05 Dec 2025
Roma
4950$
07 Dec 2025   :  11 Dec 2025
Marrakech
3950$
08 Dec 2025   :  12 Dec 2025
Prague
4950$
15 Dec 2025   :  19 Dec 2025
Dublin
4950$
22 Dec 2025   :  26 Dec 2025
Athens
4950$
28 Dec 2025   :  01 Jan 2026
Dubai
2950$
29 Dec 2025   :  02 Jan 2026
Tbilisi
4950$

Result -->

12 Courses

Download Result List

A

Z

Treasury and Cash Management

ID 662

One week

Course Details

Dates & Locations

Treasury and Risk Management

ID 861

One week

Course Details

Dates & Locations

Accounts Payable From Accounting to Management (Planning, Organizing and Achieving Best Practices)

ID 598

One week

Course Details

Dates & Locations

Accounts Payable: Accounting and Management Best Practices

ID 761

One week

Course Details

Dates & Locations

Payroll Accounting

ID 762

One week

Course Details

Dates & Locations

Corporate Finance

ID 40

One week

Course Details

Dates & Locations

Finance for Managers

ID 41

One week

Course Details

Dates & Locations

International Financial Reporting Standards

ID 42

One week

Course Details

Dates & Locations

Budgeting, Forecasting and the Planning Process

ID 43

Two weeks

Course Details

Dates & Locations

The Financial Excellence Programme

ID 44

Two weeks

Course Details

Dates & Locations

Financial Analysis, Planning & Control

ID 45

Two weeks

Course Details

Dates & Locations

Oil & Gas Accounting & Performance Measurement

ID 46

One week

Course Details

Dates & Locations