Versions Compared

Old Version 25

changes.mady.by.user Li Lian Cheong

Saved on

compared with

New Version Current

changes.mady.by.user Marie-Line Ardito

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

Info
iconfalse
titleProcess Owner
François Carette
 Performance & Capex Reporting Manager - GEC
Corporate Financial Function
Info
iconfalse
titleD&PS Expert
Marie-Line Ardito
 

 

General Description

Finance Cockpit Dashboard is a decisional tool designed to facilitate financial analysis and business piloting. It allows Management/Finance/Controlling team to follow the Financial situation of the Group/GBUs.
It consists in indicators on
Budget,
Balance Sheets, Profit & Loss, Cash and CFROI of the group
. All these indicators are validated by the Corporate Finance team which included definitions, calculations, rules, etc before publication each month
.
The dashboard
will
provides each month end result of the group's, GBUs' or Legal Entities' overall performance. These included comparison of Actual
verses
versus Budget, Historical, BFR in all indicators of each page (refer
page
indicator details
via next section
).
It allows Management/Finance/Controlling team to follow the Financial situation of the Group/GBUs.
Period of Analysis
  • Year - 1
  • Year
  • Quarter
  • Month
Currencies
  • EUR
Info
iconfalse
titleTarget Users
  • Finance
    Comex
  • Controlling
  • Finance
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:
Corporate Finance - point 1
in Authorisations' rights
and 3
GBU Finance Director + copy to Corporate Finance - point 2
and 3 in Authorisations' rights
Authorisations' rights:
1 .Lead FD Role (
Requester's selection on
specific role)
2 .1 GBU / Legal Entities
regardless of GBUs)
  • Selected GBU (Requester's designated GBU regardless of Legal Entities)
  • Both (Requester's selections on access to specific Legal Entities and GBUs)
    • (of the GBU)
    3 .Multi GBUs / Legal Entities
    Access form
    Tabs

    175 KPis

    Home
    Profit & Loss
    Balance SheetCashCFROIMy Page17
    • Overview

    KPis

    EIBITDA
    Balance Sheet
    Industrial Working Capital
    Cash
    CFROI 
    My Report
    General Dimensions
    • Group of GBUs
    • GBU
    • Zone (BFC zone)
    • Legal Entity
    • Operating Segment
    • Group of
      GBU
    • GBU
    • Group of Activity
    • Sub Activity
    • QTD/YTD:
      • QTD - Select the past months in current quarter
      • YTD - Select the past months of current year
    • Unity: K€ or M€
    • Activities
    • Sub Activities
    • Zone (BFC zone)
    • Legal Entity

    • Phases
      Phase
      : Actual, Restated, Historical, Budget or Budget Y+1, BFC
    • Unity : K€ or M€
    • YTD/QTD:
    YTD: Select the past months of the year
    QTD: Select the past months in the current quarter
    Current Selection: Displays the selection on unity, Operating Segment, Group of GBU, GBU, Group of Activity, Sub Activity, Zone, Legal Entity.
    Note
    iconfalse
    titlePhases Details

    Actual

    Current Year's results

    Restated

    Previous Year's (Y-1) results based on Current Year's structure and rate

    Historical

    Previous Year's (Y-1) Official results published

    Budget

    Official forecast for Current Year defined in October Previous Year (Y-1)
    BFR
    4 re-forecast for Current Year : BFR03/BFR06/BFR09/BFR12 = (Official forecast for Current Year defined in October Previous Year - Total Actual Q1+Q2+Q3)
    BFC Flows
    F99
    CLOSING BALANCE
    F99AJ
    Adjusted
    FA99EX
    Exceptional
    RS99
    Closing RSB
    RS80
    Foreign exchange Gain/Loss
    F20
    INCREASE
    F23
    CAPITALIZED INTERESTS
    F53
    INTERNALLY GENERATED FIXED ASSETS
    F15
    VARIATION
    RS100
    RSB - Dec Tx Current Month
    F06
    DIVIDENDS PAID
    RS50
    RECLASSIFICATION
    C04
    NET BOOK VALUE (NBV)
    Annualized
    • [01] = 12 x [01];
    • [02] = 6 x ([01] + [02]);
    • [03] = 4 x ([M-2] + [M-1] + [M])
    Sources 
    BFC
    All except below listed managed by Corporate Finance
    Manual Files
    • BFR  – quarterly basis
    • WACC Corporate – updated by the Corporate Finance
    • WACC GBUs – updated by the Corporate Finance
    • Tax Rate – updated by the Corporate Finance
    • Maintenance rate – updated by the Corporate Finance
    • Free cash flow – updated by the Corporate Finance. Actual by month, Historical by quarter, budget of the Year and BFR by month :
      • Delta working capital others
      • Tax cash out
      • Provisions cash out
      • Others & Disc. opFree cash flow
    Period of Analysis
    • Year - 1
    • Year
    • Month
    • Quarter
    • Quarter To Date
    • Year To Date
    Currencies
    • EUR
    My Account
    Depending on your dashboard authorization(s), you can switch from GBU view to Legal Entity view (for Lead FD) by following below steps:

    Dashboard refresh frequency
    From the 4th to the 25th of each month :

    Image Added