Liquidity, leverage and return ratios

Judge whether a business can pay its bills, carries too much debt and earns enough on what it owns.

Syntax

Write the function's name and its figures in major units. Ratios come back as plain numbers: a current ratio of 1.6 means 1.6 of assets for each 1 owed.

CURRENT_RATIO(current_assets, current_liabilities)
QUICK_RATIO(cash, receivables, current_liabilities)
WORKING_CAPITAL(current_assets, current_liabilities)
DEBT_TO_EQUITY(total_debt, equity)
NET_DEBT_TO_EBITDA(total_debt, cash, ebitda)
INTEREST_COVERAGE(ebit, interest_expense)
DEBT_SERVICE_COVERAGE(net_operating_income, total_debt_service)
RETURN_ON_ASSETS(net_income, total_assets)
RETURN_ON_EQUITY(net_income, equity)
ASSET_TURNOVER(revenue, total_assets)

Parameters and arguments

Arguments are written in brackets, separated by commas. An argument in square brackets is optional.

  • CURRENT_RATIO

    current_assets

    Required: Yes
  • current_liabilities

    Required: Yes
  • QUICK_RATIO

    cash

    Required: Yes
  • receivables

    Required: Yes
  • current_liabilities

    Required: Yes
  • WORKING_CAPITAL

    current_assets

    Required: Yes
  • current_liabilities

    Required: Yes
  • DEBT_TO_EQUITY

    total_debt

    Required: Yes
  • equity

    Required: Yes
  • NET_DEBT_TO_EBITDA

    total_debt

    Required: Yes
  • cash

    Required: Yes
  • ebitda

    Required: Yes
  • INTEREST_COVERAGE

    ebit

    Required: Yes
  • interest_expense

    Required: Yes
  • DEBT_SERVICE_COVERAGE

    net_operating_income

    Required: Yes
  • total_debt_service

    Required: Yes
  • RETURN_ON_ASSETS

    net_income

    Required: Yes
  • total_assets

    Required: Yes
  • RETURN_ON_EQUITY

    net_income

    Required: Yes
  • equity

    Required: Yes
  • ASSET_TURNOVER

    revenue

    Required: Yes
  • total_assets

    Required: Yes

Examples

Current assets of 480,000 against 300,000 due within a year, of which 90,000 is cash and 120,000 is owed by customers.

Return type and behaviour

Each function returns one value. The table shows its type, what it does and one way to write it; the examples use the functions in realistic statements.

FunctionReturnsBehaviourForm
CURRENT_RATIOdecimalCurrent assets divided by current liabilitiesCURRENT_RATIO(480000, 300000)
QUICK_RATIOdecimalCash plus receivables divided by current liabilities: liquidity without selling stockQUICK_RATIO(90000, 120000, 300000)
WORKING_CAPITALdecimalCurrent assets less current liabilitiesWORKING_CAPITAL(480000, 300000)
DEBT_TO_EQUITYdecimalDebt divided by equityDEBT_TO_EQUITY(400000, 250000)
NET_DEBT_TO_EBITDAdecimalDebt less cash, divided by EBITDA: the years of operating profit needed to clear the debtNET_DEBT_TO_EBITDA(400000, 60000, 150000)
INTEREST_COVERAGEdecimalHow many times operating profit covers the interestINTEREST_COVERAGE(110000, 20000)
DEBT_SERVICE_COVERAGEdecimalHow many times income covers the repaymentsDEBT_SERVICE_COVERAGE(130000, 65000)
RETURN_ON_ASSETSdecimalNet income divided by total assetsRETURN_ON_ASSETS(54000, 600000)
RETURN_ON_EQUITYdecimalNet income divided by equityRETURN_ON_EQUITY(54000, 250000)
ASSET_TURNOVERdecimalRevenue divided by total assets: sales earned for each 1 of assetsASSET_TURNOVER(900000, 600000)
Errors and exceptions
ErrorWhat happenedHow to recover
HTQL-5001The function was given the wrong number of arguments. The message names the function and the countsGive it the arguments listed under Parameters
HTQL-1004 Unsupported functionThe name is not a function this engine runsCheck the name and its spelling against this entry
HTQL-5005A figure is out of range, such as a zero or negative denominator. The message names the function and the rulePass values inside the range listed under Parameters and Limitations
HTQL-5004 Not enough paramsAn argument is missing. The message lists the names the function expectsGive every argument it lists
Limitations
  • Each ratio refuses a zero or negative denominator: current liabilities, equity, total assets, interest, debt service and EBITDA must be above 0. WORKING_CAPITAL has no restriction.
  • A finance function's result cannot be an argument of another finance function, so type the figure in or name it with LET. The result can be compared in IF and used in ADD, SUBTRACT, MULTIPLY and DIVIDE.
  • The functions take figures you supply. They do not read your records.
Permissions and security

These functions read nothing from your tables and write nothing.

When a function is applied to a column or a variable, the statement that reads the data needs read access, as its own entry says.

Best practices
  • Use figures from the same date and the same currency throughout one statement.
  • Compare a ratio with the same business last year, not only with a rule of thumb.