Templates > Corporate Finance > Profit & Loss > Income Statement > Income Statement: What-if Analysis

Presentation

This dashboard page allows you to easily perform simulations and what-if analysis on your Top P&L KPIs

For each of the following Profit & Loss KPI, you can simulate a change by applying a change factor (in %):

• Total Revenues
• COGS
• OpEx
• Deprec. & Amort.
• Interests & Taxes

Then, you will be able to see what would be the impact on the following KPIs:

• Gross Margin
• Gross Margin %
• OpEx to Revenues ratio
• Operating Income
• Operating Income %
• Net Income
• Net Income %

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: