Corporate Financial Function
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).
  • Comex
  • Controlling
  • Finance
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
  • free table
General Dimensions
  • Group of GBUs
  • GBU
  • Operating Segment
  • Group of Activities
  • Sub Activities
  • Zone (BFC zone)
  • Legal Entity

  • Phases : Actual, Restated, Historical, Budget, 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.

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 :