Financial Ratios Scorecard Formulas

The following table lists the formulas used to calculate data for the prebuilt Financial Ratios scorecard. This scorecard is available if you have permission to see the Trial Balance report. Formula components are standard NetSuite KPI IDs.

Scorecard Ratio	Formula
Current Ratio	({BANKBAL}+{RECEIVABLES}+{OTHERCURRENTASSET})/({PAYABLES}+{CREDITCARDBAL}+{OTHERCURRENTLIAB})
Receivables	{SALES}/{RECEIVABLES}
Days Sales Outstanding	{DAYS}/({SALES}/{RECEIVABLES})
Inventory Turnover	{COGS}/{INVENTORY}
Days Inventory On Hand	{DAYS}/({COGS}/{INVENTORY})
Asset Turnover	{SALES}/({BANKBAL}+{RECEIVABLES}+{OTHERCURRENTASSET}+ {FIXEDASSET}+{OTHERASSET})
Profit Margin on Sales	{PROFIT}/{INCOME}
Return on Assets	{PROFIT}/({BANKBAL}+{RECEIVABLES}+ {OTHERCURRENTASSET}+{FIXEDASSET}+{OTHERASSET})
Return on Equity	{PROFIT}/{EQUITY}
Debt to Total Assets	({PAYABLES}+{CREDITCARDBAL}+{OTHERCURRENTLIAB}+ {LONGTERMLIAB})/({BANKBAL}+{RECEIVABLES}+ {OTHERCURRENTASSET}+{FIXEDASSET}+{OTHERASSET})
Debt to Equity	({PAYABLES}+{CREDITCARDBAL}+{OTHERCURRENTLIAB}+ {LONGTERMLIAB})/{EQUITY}

For more information about this scorecard, see Financial Ratios Scorecard.
For information about the underlying report, see Trial Balance Report.
For a list of standard KPI IDs, see KPI IDs Available for Scorecard Formulas.
For a list of standard KPIs and descriptions, see Standard Key Performance Indicators Table.
For information about adding formulas to KPI scorecards, see Defining KPI Scorecard Formulas.

Related Topics