Versions Compared

Old Version 7

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 consists 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 Budget, Historical, BFR in all indicators of each page (refer page details via next section). It allows Management/Finance/Controlling team to follow the Financial situation of the Group/GBUs.
BFC Flows
F99
CLOSING BALANCE
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])
Scope
BFC Data
Except
BFR: manual files - quarterly basis
WACC Corporate: manual file - updated by Corporate Finance
WACC GBUs: manual file - updated by Corporate Finance
Tax Rate: manual file - updated by Corporate Finance
Maintenance Rate: manual file - updated by Corporate Finance
Free Cash Flow: manual file - updated by Corporate Finance. 
  • Actual by month, Historical by quarter, Budget by the year and BFR by month
    • Delta working capital others
    • Tax cash out
    • Provisions cash out
    • Others & Disc. op
    • Free cash flow
SourcesHome
BFC
All indicators except below listed are from manual files managed by Corporate Finance
Manual Files
  • BFR
  • WACC Corporate
  • WACC GBUs
  • Tax Rate
  • Maintenance Rate
  • Free Cash Flow
Refresh Frequency
From 4th to 25th each month (Below is the different time of validation by Corporate).

Image Removed

 

 

SourcesHome
BFC
  • Overview
Manual Files
 
Refresh Frequency
Overview of GBU's Financial situation with an highligh on Net Sales, Contribution Margin, Fixed Costs, Underlying Ebitda, CAPEX, Working Capital, Simplified Cash Flow.
It provides the previous month's result comparing with BFR or Budget or Restated (see Comparaison rule)
The detailed tables contain various elements from the Net Sales to the Underlying EBITDA and from the Underlying EBITDA to the Simplified Cash Flow :
  • FY Y-1 RSB or Historical
  • Actual Month-2
  • Actual Month-1
  • Actual Month
  • Month Budget
  • QTD Actual Quarter
  • QTD Budget Quarter
  • Delta Actual-Budget QTD
  • % Delta Actual-Budget QTD
  • Actual YTD
  • Budget YTD
  • Delta Actual- Budget YTD
  • % Delta Actual- Budget YTD
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)
    • Access form
    (of the GBU)
    3 .Multi GBUs / Legal Entities
    Access form
    Key Figure Example
    Image Added
    • Total of actual "Net Sales" (Key figures) in M€ for the Month or Quarter (according to actual month)
    • Total of Budget, BFR, or restated in M€ (according to actual month) - See description of Comparison Rule)
    • Delta (in percentage) between the actual and its comparison.
      
    Comparison Rule

    Image Added

      
    • 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€
    • Phase: Actual, Restated, Historical, Budget, BFC
    Current Selection: Displays the selection on unity, Operating Segment, Group of GBU, GBU, Group of Activity, Sub Activity, Zone, Legal Entity.
    General Dimensions

    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)
    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
    My Account
    Image RemovedDepending on your dashboard authorization(s), you can switch from GBU view to Legal Entity view (for Lead FD) by following below steps:
    Image Removed