Advanced Financial Statements Analysis & Forecasting (1 Week)

Advanced  Financial  Statements Analysis  &  Forecasting

Download Brochure
AI Course Intro
Dates & Locations
Online Contact

Introduction

In today’s world, finance professionals are challenged by providing management with a detailed analysis of the
impact of the organization’s financial decisions. Therefore, finance professionals need to be skilled at reading
Through the numbers on the financial statements, analyzing the figures, interpreting the various ratios, and
presenting this analysis in a dynamic manner. This course takes you from the first step of understanding the
relationships between the different elements of financial statements, through the process of calculating and
Analyzing the financial ratios, to the last step of presenting recommendations. While applying Excel tools and
Techniques, various real-life examples of published financial statements will be used throughout the course.

Training Objectives

  • Apply the framework of financial statements analysis
  • Use ratio and financial analysis
  • Interpret company financials and sector position
  • Appraise the process of company evaluation and analysis
  • Analyze real-life financial statements from companies traded on the world
  • Prepare financial analysis template models

Course Outlines

Day 1
ِRequired components of financial statement analysis

  • Role of financial reporting and analysis
  • Core financial statements and the importance of the annual report
  • The important role of notes and supplementary information
  • Objectives of financial statements audit
  • Types of audits
  • The financial statement analysis framework
  • The accounting cycle
  • Financial reporting mechanics
  • Relationship, elements, and classification of financial statements

Financial reporting standards

  • Importance of reporting standards in security analysis and valuation
  • The standards-setting bodies
  • International Financial Reporting Standards (IFRS) versus Generally Accepted Accounting Principles (GAAP)

Day 2

An inside look at financial statements

  • Income statement components
  • The three important components of income statements
  • Revenue and expense recognition
  • Balance sheet components:
              – Measurement and classification
              – The five important components of a balance sheet
  • Statement of changes in owner’s equity
  • Cash flow statement:
               – Operating, investing, and financing activities
            – Direct versus indirect methods in cash flow preparation
            – Reading and interpreting cash flow
            – The cash-rich standard

Day 3

Mechanisms of financial analysis techniques

  • Vertical analysis and strategy: balance sheet and income statement approaches
  • 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
  • Market and valuation:
                   – Price-earnings and earnings-per-share ratios
  • DuPont analysis: the three-step and five-step models
  • Limitation of ratio analysis

Day 4

Boosting efficiency in your department

  • The 10 must-have Excel tips
  • Working with text files
  • Looking up records from a database
  • Validating data and controlling data input
  • Reconciliations and accounts analysis using pivot tables
  • Creating management reports and dashboards

Day 5

Financial forecasting techniques for analysts

  • Income statement forecasting
  • Revenue
  • Cost of sales
  • Operating expenses

Balance sheet forecasting

  • Fixed assets
  • Working capital
  • Retained earnings and dividend policy

Cash flow statement forecasting

  • Operating cash flows
  • Free cash flows to the firm
  • Free cash flow to equity

DATES & LOCATIONS

AMSTERDAM

REF: FI-1101
€4500
€ 4000 Individual fee
  • COURSE DATES
  • 02 DEC - 06 DEC 2024
  • 16 DEC - 20 DEC 2024
  • 13 JAN - 17 JAN 2025
  • 20 JAN - 24 JAN 2025
  • 03 FEB - 07 FEB 2025
  • 17 FEB - 21 FEB 2025
  • 03 MAR - 07 MAR 2025
  • 17 MAR - 21 MAR 2025
  • 07 APR - 11 APR 2025
  • 12 APR - 16 APR 2025
Register Now
Special Price for Groups

ISTANBUL

REF: FI-1101
€4000
€ 3500 Individual fee
  • COURSE DATES
  • 02 DEC - 06 DEC 2024
  • 16 DEC - 20 DEC 2024
  • 13 JAN - 17 JAN 2025
  • 20 JAN - 24 JAN 2025
  • 03 FEB - 07 FEB 2025
  • 17 FEB - 21 FEB 2025
  • 03 MAR - 07 MAR 2025
  • 17 MAR - 21 MAR 2025
  • 07 APR - 11 APR 2025
  • 12 APR - 16 APR 2025
Register Now
Special Price for Groups

Special Price for Groups

Contact Us

Fill out the form below and we will cantact you as soon as possible