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.