Versions Compared

Old Version 44

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).
Period of Analysis
  • Year - 1
  • Year
  • Quarter
  • Month
Currencies
  • EUR
Info
iconfalse
titleTarget Users
  • Comex
  • Controlling
  • Finance
Info
iconfalse
titleAuthorization & Rights
All the accesses must be validated by:
Corporate Finance - point 1 and 3
in Authorisations' rights
GBU Finance Director + copy to Corporate Finance - point 2
in Authorisations' rights
Authorisations' rights:
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
EIBITDA
Balance Sheet
Industrial Working Capital
Cash
CFROI 
My Report
TabsHomeProfit & LossBalance SheetCashCFROIMy Page

175

KPis

  • Overview
 
  • free table

 

 

General Dimensions
General Dimensions
  • Group of GBUs
  • GBU
  • Operating Segment
  • Group of Activities
  • Sub Activities
  • 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
  • Phases : 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