Financial KPIs
This table shows the financial KPI reports that are available in the Infor EPM Platform KPI Dashboard. Select 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.