/uploads/packs/000011/PL KPI Perf W.PNG

 

Presentation

This dashboard shows the performance of any of your Income Statement KPIs, how this performance evolves over time and who contributes to this performance.

At the top left, you can visualize the performance of the KPI your selected.

 

At the top right, you can visualize the evolution of your performance across months (vertical bars). You can look at data in month-to-date or year-to-date (based on your selection in "Performance Scope").

The line shows the evolution of the reference (it can be previous year or budget depending on your selection in "Performance Scope").

Each bar is colored based on the variance percentage (Δ%) between the KPI value and its reference.

 

At the bottom, you can see the performance of the KPI you selected, split by the dimension your selected.

For each element of the dimension, it shows:

  • The KPI value
  • The variance (Δ) between the KPI value and its reference
  • The variance % (Δ%) between the KPI value and its reference

An easy way to better understand who contribute to the overall performance.

 

Select KPI

'Select KPI' selector allows you to easily switch from one KPI to another, so you can analyze your data from any point of view.

The list of available KPIs is defined during the configuration of your dashboard in LinPack.

In your Income Statement dashboard, you will be able to select the following KPIs:

  • Opex & Deprec. & Amort. OpEx + Depreciations + Amortizations
  • Total Revenues Sum of Revenues
  • COGS Cost of goods sold (COGS, also known as 'Cost of Sales') refers to the direct costs attributable to the production of the goods sold in a company. This amount includes the cost of the materials used in creating the good along with the direct labor costs used to produce the good. It excludes indirect expenses such as distribution costs and sales force costs.
  • Gross Margin Amount left over from Revenues after Costs of Goods Sold are subtracted (also called 'Gross Profit'): Revenues - COGS
  • Gross Margin % Gross Margin / Revenues (%)
  • OpEx Operating Expenses: Expenditures (that is, cash out) that a company makes to generate income (also called 'SG&A Expenses'): S&M Expenses, R&D Expenses, G&A Expenses
  • OpEx to Revenues ratio OpEx / Revenues (%)
  • Operating Income Earnings before interest and taxes -> profits before taking away interest charges and tax payments: Gross Margin - (OpEx + Depreciations + Amortizations)
  • Operating Income % Share of Operating Income on Total Revenues: Operating Income / Revenues (%)
  • Net Income Net Income: Operating Income - (Interests + Taxes)
  • Net Income % Net Income / Revenues (%)
  • Deprec. & Amort. Amortizations and depreciations are methods of prorating the cost of business assets over the course of their useful life
  • Interests & Taxes Sum of Interests & Taxes
  • (+ any KPI you want to add to your Income Statement dashboard)

 

Select Dimension

'Select Dimension' selector allows you to easily switch from one dimension (analytical axis) to another, so you can analyze your data from any point of view.

The list of available dimensions is defined during the configuration of your dashboard in LinPack.

In your Income Statement dashboard, you will be able to select the following dimensions:

  • MonthMonth (Date type)
  • Legal Entity, CompanyLegal Entity, Company
  • Cost Center, Department, DivisionCost Center, Department, Division

 

Select Current Period

'Current Month' and 'Current Year' selectors allow you to easily select what is the period (month and year) you want to analyze.

 

Select Performance Scope

'Performance Scope' selector allows you to easily switch from one type of Performance Analysis to another.

Just pick-up what you want to analyze:

There are five types of Performance Analysis available:

  • Current Month vs Previous Month (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Nov-2016)
  • Current Month vs Same Month, Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze Nov-2017 vs Oct-2017)
  • Current Month: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual Nov-2017 vs Target Nov-2017)
  • Year-to-Date: Current Year vs Previous Year (e.g. if you selected Nov-2017 as being your current month, you will analyze YTD Nov-2017 vs YTD Nov-2016)
  • Year-to-Date: Actual vs Target  (e.g. if you selected Nov-2017 as being your current month, you will analyze Actual YTD Nov-2017 vs Target YTD Nov-2017)

Note: 'Current Month: Actual vs Target' and 'Year-to-Date: Actual vs Target' are only available in the list if at least one of your KPIs is defined as having a related Target.

 

Filter your data

This data visualization comes with four top filters:

In your Income Statement dashboard, you will be able to filter on:

  • Legal Entity, CompanyLegal Entity, Company
  • Cost Center, Department, DivisionCost Center, Department, Division

Other #DataViz in "Income Statement" Pack

Home

Income Statement Home

Income Statement Home
Income Statement Home Income Statement Home
Get a Home Page for your Income Statement dashboard

Cockpit

Income Statement Cockpit

Income Statement Cockpit
Income Statement Cockpit Income Statement Cockpit
Get instant overview of your Profit & Loss KPIs: Revenues, Gross Margin, Gross Margin %, Operating Expenses, Operating Income, Operating Income %, OpEx to Revenues Ratio, COGS, Net Income

Income Statement Top KPIs Breakdown

Income Statement Top KPIs Breakdown
Income Statement Top KPIs Breakdown Income Statement Top KPIs Breakdown
Get a transverse view on your top 6 Income Statement KPIs, split by the dimension of your choice

Income Statement Top KPIs Evolution

Income Statement Top KPIs Evolution
Income Statement Top KPIs Evolution Income Statement Top KPIs Evolution
Visualize how your Income Statement KPIs are evolving (Month-to-Date, Year-to-Date)

Financial Analytics

Income Statement

Income Statement
Income Statement Income Statement
Get an instant overview of your main Profit & Loss KPIs

Income Statement - What-if Analysis

Income Statement - What-if Analysis
Income Statement - What-if Analysis Income Statement - What-if Analysis
Easily perform simulations and what-if analysis on your Top P&L KPIs

Income Statement: Waterfall

Income Statement: Waterfall
Income Statement: Waterfall Income Statement: Waterfall
Waterfall visualization of your Income Statement: unpack financial trends and understand drivers of change over time

Behavioral Analytics

Income Statement KPI Performance

Income Statement KPI Performance
Income Statement KPI Performance Income Statement KPI Performance
Visualize the overall performance of any of your Income Statement KPIs: what is the performance, how does this performance evolve, who contributes to this performance

Trends Analytics

Income Statement Trends Analysis

Income Statement Trends Analysis
Income Statement Trends Analysis Income Statement Trends Analysis
Visualize the evolution of any of your Income Statement KPIs: Trends, Performance & Year over Year

Distribution Analytics

Income Statement Segmentation Analysis

Income Statement Segmentation Analysis
Income Statement Segmentation Analysis Income Statement Segmentation Analysis
Visualize the value of any of your Income Statement KPIs, split by the dimension you selected (market share analysis)

Income Statement Pareto Analysis

Income Statement Pareto Analysis
Income Statement Pareto Analysis Income Statement Pareto Analysis
Perform a Pareto Analysis on any of your Income Statement KPIs: the 80/20 rule.

Other Packs