Balance Sheet Analysis dashboard

To access the Balance Sheet Analysis dashboard, go to the dashboards homepage. Select the folder icon or the Browse Collections & Dashboards > CFO dashboards > Balance Sheet Analysis dashboard.

This dashboard is based on Global Ledger subject areas.

These are the dashboard filters:

  • Calendar
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • HR Organization for Finance Enterprise Group

These are the KPIs on the dashboard:

  • Return On Assets
  • Working Capital Ratio
  • Return On Equity
  • Debt to Equity Ratio

The dashboard contains these reports:

Report name Description Chart style
Return on Asset Trend Shows the return on asset value for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard Column
Working Capital Ratio Trend: Shows the working capital ratio for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard Line
Return on Equity Shows the return on equity for calendar period level 3 for rolling 12 months based on selected year and period on the dashboard Column
Debt to Equity Trend Shows the debt to equity ratio for calendar period level 03 for rolling 12 months based on selected year and period on the dashboard Area
Balance Sheet

Shows the YTD Actual Functional amount for the balance sheet account levels. The account levels are taken from the chart defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

Designer

Return on Asset Trend report

To access the Return on Asset Trend report, go to Visualizer. Select Infor > CFO Dashboards > Balance Sheet Analysis Dashboard > Return on Asset Trend.

These are the report elements and their sources or expressions:

  • Return On Asset - shows the Return on asset value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Asset and Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.

    The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Asset Type of Accounts for Year and Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)/2].

    Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.

    The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Asset Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].

  • Calendar Period Level 03 - shows the Calendar Period Level 03 value
  • Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard

Working Capital Ratio Trend report

To access the Working Capital Ratio Trend report, go to Visualizer. Select Infor > CFO Dashboards > Balance Sheet Analysis Dashboard > Working Capital Ratio Trend.

These are the report elements and their sources or expressions:

  • Working Capital Ratio - shows the Working Capital Ratio value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    Summary Current Assets Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_ASSETS variable and Summary Current Liabilities Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_LIABILITIES variable.

    Both of these summary accounts must be from the Chart Structure defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable.

    The formula is [YTD Actual Functional amount of Summary Current Assets Account ] / [ (Actual Functional amount of Summary Current Liabilities].

  • Calendar Period Level 03 - shows the Calendar Period Level 03 value for the calendar selected on the dashboard
  • Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected on the dashboard

Return On Equity report

To access the Return On Equity report, go to Visualizer. Select Infor > CFO Dashboards > Balance Sheet Analysis Dashboard > Return On Equity.

These are the report elements and their sources or expressions:

  • Return On Equity - shows the Return on Equity value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Equity & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.

    The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Equity Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)].

    Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.

    The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Equity Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].

  • Calendar Period Level 03 - shows the Calendar period level 03 value
  • Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard

Debt to Equity Trend report

To access the Debt to Equity Trend report, go to Visualizer. Select Infor > CFO Dashboards > Balance Sheet Analysis Dashboard > Debt to Equity Trend.

These are the report elements and their sources or expressions:

  • Debt to Equity - shows the Debit to Equity value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Equity & Liabilities Accounts taken for calculating this value will be taken from chart structure defined FSM_ALL_KPI_SUMMARY_ACCT_CHART.

    The formula is [YTD Actual Functional amount of Summary Liabilities Type of Accounts ] / [ (Actual Functional amount of Equity Type of Accounts].

  • Calendar Period Level 03 - shows the Calendar period level 03 value
  • Month Sequence Range - filters the Fiscal Months Sequence for 12 Rolling Periods based on the Year, Year/Month filter options selected in dashboard

Balance Sheet report

To access the Balance Sheet report, go to Designer. Select Infor > CFO Dashboards > Balance Sheet Analysis Dashboard > Simple Balance Sheet.

These are the report elements and their sources or expressions:

  • Account Level 02 Description - shows the Account Level 02 Description
  • Account Level 03 Description - shows the Account Level 03 Description
  • Account Level 04 Description - shows the Account Level 04 Description
  • Level 02 Total - shows YTD Actual Functional Amount
  • Level 03 Total - shows YTD Actual Functional Amount
  • Level 04 Total_1 - shows YTD Actual Functional Amount
  • Report Filter - filters the Report to show data only for Balance Sheet Chart Section Accounts. Balance Sheet Accounts is filtered only for the chart structure assigned in FSM_ALL_KPI_SUMMARY_ACCT_CHART variable

KPI expressions

  • ROA - shows the Return on asset value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Asset & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.

    The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Asset Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)/2].

    Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.

    The formula is:[Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Asset Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].

  • Working Capital Ration - shows the Working Capital Ratio value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    Summary Current Assets Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_ASSETS variable and Summary Current Liabilitys Account must be defined in the FSM_ALL_KPI_SUMMARY_ACCT_CURRENT_LIABILITIES variable.

    Both of these summary accounts must be from the Chart Structure defined in the FSM_ALL_KPI_SUMMARY_ACCT_CHART variable.

    The formula is [YTD Actual Functional amount of Summary Current Assets Account ] / [ (Actual Functional amount of Summary Current Liabilities].

  • Return on Equity - shows the Return on Equity value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Equity & Income Statement Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART.

    The formula for Calculating Return on Asset is [YTD Actual Functional Amount for Income Statement Accounts for Year and Fiscal Month(value selected in dashboard filters) + YTD Actual Functional Amount for Previous Year where Fiscal Month is Greater than Equals to the value selected in Fiscal Month Dashboard Filter] / [(YTD Actual Functional Amount for Equity Type of Accounts for Year & Fiscal Month selected in dashboard + Actual Functional Amount for Previous Year, Fiscal Month(from the dashboard)].

    Example:Year = 2021 Fiscal Month = 06 is selected in dashboard.

    The formula is [Actual Functional Amount for Income Statement Accounts for Year = 2021 and Fiscal Month <= 06 + Actual Functional Amount for Previous Year 2020, Fiscal Month > 06 i.e 07,08,09,10,11,12] / [YTD Actual Functional Amount for Equity Type of Accounts for 2021, Fiscal Month <=06 + Actual Functional Amount for Year = 2020, Fiscal Month <= 06)/2].

  • Debt to Equity Ratio - shows the Debit to Equity value based on FEG, Calendar, fiscal year, fiscal month and other filters selected on the dashboard.

    The Equity & Liabilities Accounts taken for calculating this value is taken from chart structure defined in FSM_ALL_KPI_SUMMARY_ACCT_CHART. The formula is [YTD Actual Functional amount of Summary Liabilities Type of Accounts ] / [ (Actual Functional amount of Equity Type of Accounts].