General Ledger Balance Sheet

This section lists the Key Performance Indicators (KPI) for the General Ledger Balance Sheet domain and the calculation used to determine their results.
KPI name KPI calculation
Assets
(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets'))  
Liabilities
(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty'))*-1
Equity
(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_StckHldr_Eqty') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_StckHldr_Eqty'))
Return on Equity
Net Profit/loss divided by Equity
([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 0 Report Code] = 'Inc_Net_Prof_Los')/(SavedExpression('Equity'))
Inventory
([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Bal_Inventory') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code]='Bal_Inventory')
Accounts Receivable
([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code]='Bal_AR') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code]='Bal_AR')
Accounts Payable
(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 4 Report Code]='Bal_Acct_Payable') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 4 Report Code]='Bal_Acct_Payable'))*-1
Debt Ratio
Liabilities divided by Assets
((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty')+ ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code]='Bal_Liablty'))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets')))*-1
Quick Ratio
Current Assets, minus Inventories, divided by Current Liabilities
(((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')) - (([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 3 Report Code] = 'Bal_Inventory') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 3 Report Code] = 'Bal_Inventory')))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')))*-1
Current Ratio
Current Assets, divided by Current Liabilities
(((([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code] = 'Bal_Assets')))/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')+([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 2 Report Code] = 'Bal_Liablty')))*-1 
Return on Assets
Net Profit/loss divided by Total Assets
(([fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 0 Report Code]='Inc_Net_Prof_Los')/(([YTD fiscalDate: Sum: glaccounts_peramt] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets') + ([YTD fiscalDate: Sum: glaccounts_fwdBal] WHERE [GLAccounts.Level 1 Report Code]='Bal_Assets')))*-1