Financial KPIs
This table shows the financial KPI reports that are available in the Infor d/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.