Versions Compared

Old Version 51

changes.mady.by.user Marie-Line Ardito

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
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 Balance Sheets, Profit & Loss, Cash and CFROI of the group.
The dashboard provides each month end result of the group's, GBUs' or Legal Entities' overall performance. These included comparison of Actual versus Budget, Historical, BFR in all indicators of each page (refer indicator details).
Info
iconfalse
titleTarget Users
  • Comex
  • Controlling
  • Finance
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:
Corporate Finance - point 1 and 3
GBU Finance Director + copy to Corporate Finance - point 2
1 .Lead FD Role (specific role)
2 .1 GBU / Legal Entities (of the GBU)
3 .Multi GBUs / Legal Entities
Access form
Tabs

175 KPis

Home
Overview
Profit & Loss
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
    Activities
  • 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
  • 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
  • Month
    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