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
Required: Yescurrent_assets
Required: Yescurrent_liabilitiesQUICK_RATIO
Required: Yescash
Required: Yesreceivables
Required: Yescurrent_liabilitiesWORKING_CAPITAL
Required: Yescurrent_assets
Required: Yescurrent_liabilitiesDEBT_TO_EQUITY
Required: Yestotal_debt
Required: YesequityNET_DEBT_TO_EBITDA
Required: Yestotal_debt
Required: Yescash
Required: YesebitdaINTEREST_COVERAGE
Required: Yesebit
Required: Yesinterest_expenseDEBT_SERVICE_COVERAGE
Required: Yesnet_operating_income
Required: Yestotal_debt_serviceRETURN_ON_ASSETS
Required: Yesnet_income
Required: Yestotal_assetsRETURN_ON_EQUITY
Required: Yesnet_income
Required: YesequityASSET_TURNOVER
Required: Yesrevenue
Required: Yestotal_assets
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.
| Function | Returns | Behaviour | Form |
|---|---|---|---|
CURRENT_RATIO | decimal | Current assets divided by current liabilities | CURRENT_RATIO(480000, 300000) |
QUICK_RATIO | decimal | Cash plus receivables divided by current liabilities: liquidity without selling stock | QUICK_RATIO(90000, 120000, 300000) |
WORKING_CAPITAL | decimal | Current assets less current liabilities | WORKING_CAPITAL(480000, 300000) |
DEBT_TO_EQUITY | decimal | Debt divided by equity | DEBT_TO_EQUITY(400000, 250000) |
NET_DEBT_TO_EBITDA | decimal | Debt less cash, divided by EBITDA: the years of operating profit needed to clear the debt | NET_DEBT_TO_EBITDA(400000, 60000, 150000) |
INTEREST_COVERAGE | decimal | How many times operating profit covers the interest | INTEREST_COVERAGE(110000, 20000) |
DEBT_SERVICE_COVERAGE | decimal | How many times income covers the repayments | DEBT_SERVICE_COVERAGE(130000, 65000) |
RETURN_ON_ASSETS | decimal | Net income divided by total assets | RETURN_ON_ASSETS(54000, 600000) |
RETURN_ON_EQUITY | decimal | Net income divided by equity | RETURN_ON_EQUITY(54000, 250000) |
ASSET_TURNOVER | decimal | Revenue divided by total assets: sales earned for each 1 of assets | ASSET_TURNOVER(900000, 600000) |
Errors and exceptions
| Error | What happened | How to recover |
|---|---|---|
HTQL-5001 | The function was given the wrong number of arguments. The message names the function and the counts | Give it the arguments listed under Parameters |
HTQL-1004 Unsupported function | The name is not a function this engine runs | Check the name and its spelling against this entry |
HTQL-5005 | A figure is out of range, such as a zero or negative denominator. The message names the function and the rule | Pass values inside the range listed under Parameters and Limitations |
HTQL-5004 Not enough params | An argument is missing. The message lists the names the function expects | Give 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_CAPITALhas 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 inIFand used inADD,SUBTRACT,MULTIPLYandDIVIDE. - 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.