Financial KPIs

This table shows the financial KPI reports that are available in the Infor EPM Platform KPI Dashboard. Select BI FSM > FSM Reports > CloudSuite Financials > Financial Reports > KPI Reports and select the report name.

Account types

  • 1-Assets
  • 2-Liabilities
  • 3-Equity
  • 4-Revenue
  • 5-Expense

Asset efficiency indicators

Report name Account type value Sub type Description and formula
Other Asset Turnover 4 ONCASST and OCASST Total Revenue/Other Assets

Formula: 4/ONCASST +OCASST

Total Asset Turnover 4 and 1 Total Revenue / Total Assets

Formula: 4/1

Fixed Asset Financing LTDBT, GRSFA, ACDEPR Long-Term Debt / Net Fixed Assets

Formula: LTDBT/(GRSFA-ACDEPR)

Fixed Asset Turnover 4 GRSFA, ACDEPR Total Revenue / Net Fixed Assets

Formula: 4/(GRSFA-ACDEPR)

Current Asset Turnover 4 CASH, STINVST, INVTY, STRECV, OCASST Total Revenue / Current Assets

Formula: 4 / (CASH+STINVST+INVTY+STRECV+OCASST)

Other financial ratios

Report name Account type value Sub type Description and formula
Return on Equity 1,2,4,5 Net Income /Total Assets-Total Liabilities

Formula: 4+5/1-2

Total Margin 4 and 5 Total Revenue – Total Expense / Total Revenue

Formula: 4-5/4

Depreciation Rate DEPREXP, GRSFA Depreciation Expense/ Gross Fixed Assets
Employee Benefits Percentage BENEXP, SALEXP Fringe Benefits Expense / Salary & WagesFormula: DEPREXP/ GRSFA

Expense

Formula: BENEXP/SALEXP

Capital Expend Growth Rate CAPEXP, GRSFA Capital Expenditures/ Gross Property Plant & Equipment

Formula: CAPEXP/GRSFA

Inventory Ratio 4 INVTY Total Revenue / Inventory

Formula: 4/ INVTY

Average Age of Fixed Assets ACDEPR, DEPREXP Accumulated Depreciation / Depreciation Expense

Formula: ACDRPR/DEPREXP

Capital structure ratios

Report name Account type value Sub type Description and formula
Capital Expense 5 INTEXP, DEPREXP, AMTEXP Formula: DEPREXP/(Interest Expense + Depreciation & Amortization Expense) / Total Expense

Formula: INTEXP+DEPREXP+AMTEXP/ 5

Cushion Ratio CASH, STINVST, LTINVST, DBTPMT, INTEXP (Cash + Short-Term Investments + Unrestricted

Long-Term Investments) / (Debt Principal Payments + Interest Expense)

Formula: CASH+STINVST+LTINVST)/(DBTPMT+INTEXP)

Equity Financing 1 and 2 Net Assets / Total Assets

Formula: 1-2/1

Long Term Debt to Capitalization 1 and 2 LTDBT Long-Term Debt / (Long-Term Debt + Net Assets)

Formula: LTDBT/LTDBT+(1-2)

Times Interest Earned 5 PDREV, SRVREV, OREV, INTINC, OINC, INTEXP Total Revenue – (Total Expense + Interest Expense) / Interest Expense

Formula:

(PDREV+SRVREV+OREV+INTINC+OINC)-5+INTEXP / INTEXP

Liquidity ratio

Report name Account type value Sub type Description and formula
Current Ratio CASH, STINVST, INVTY, STRECV, OCASST, STDBT, STPAY, OCLIAB Current Assets / Current Liabilities

Formula: CASH+STINVST+INVTY+STRECV+OCASST / STDBT+STPAY+OCLIAB

Average Payment Period STDB, STPAY, OCLIAB, BENEXP, PDCST, SALEXP, SRVCST, OOEXP, OCST Current Liabilities / (Benefit Expense +Product Cost +Salary Expense + Service Cost + Other Operating Expense + Other Revenue Cost)/30

Formula: STDBT + STPAY + OCLIAB/ (BENEXP +PDCST +SALEXP + SRVCST + OOEXP + OCST)/30

Days Cash on Hand, All Sources 5 CASH, STINVST, LTINVST, DEPREXP Cash + Short Term Investments + Unrestricted Long Term Investments / Total Expenses-Depreciation Expense/30

Formula: CASH + STINVST + LTINVST / 5 – DEPREXP

Days Cash on Hand, Short Term Sources 5 CASH, STINVST, DEPREXP Cash + Short Term Investments / Total Expenses-Depreciation Expense/30

Formula: CASH + STINVST / 5 – DEPREXP

Cash flow ratios

Report name Account type value Sub type Description and formula
Cash Flow to Total Revenue 5 PDREV, SRVREV, OREV, INTINC, OINC, DEPREXP ((Total Revenue – Total Expense) + Depreciation Expense) / Total Revenue

Formula:

((PDREV+OREV+INTINC+

SRVREV+OINC)- 5) +

DEPREXP/ (PDREV+OREV+INTINC+

SRVREV+OINC)

Cash Flow to Total Assets 1,5 PDREV, OREV, INTINC, SRVREV, ONINC, DEPREXP ((Total Revenue – Total Expense) + Depreciation) / Total Assets

Formula:

((PDREV+SRVREV+OREV+

INTINC+OINC) – 5) + DEPREXP/1

Cash Flow to Total Debt 5 PDREV, SRVREV, OREV, INTINC, OINC, DEPREXP, AMTEXP, STDBT, STPAY, OCLIAB, LTDBT ((Total Revenue – Total Expense) + (Depreciation + Amortization Expense)) / (Current Liabilities + Long-Term Debt)

Formula: (PDREV+SRVREV+OREV+

INTINC+OINC) – 5 + (DEPREXP+AMTEXP)/

(STDBT+STPAY+OCLIAB) + LTDBT

The type and subtype are assigned to the accounts in Infor CloudSuite Financials. See the Infor CloudSuite Financials Setup and Administration Guide for more information about setting up accounts. The KPI reports use the account types and sub types to filter the accounts to the accounts used in the KPI.

All of the KPI reports are displayed in the same format. Menu options are available on each KPI report to so that the user can change what data is displayed. There are menu options for the end-user to select the reporting basis, scenario values, calendar dates, and filter values.

Each KPI report has an option for specifying target values for each period that you can use to compare against a scenario’s value.

The full list of KPIs are available in a menu option to allow the user to display a different KPI report.