c_sales_to_price#

c_sales_to_price(c_last_twelve_months_revenue, c_market_cap)[source]

Calculate the sales-to-price (S/P) ratio.

Parameters:

  • c_last_twelve_months_revenue (DataColumn) – The last twelve months revenue.

  • c_market_cap (DataColumn) – The market capitalization.

Returns:

The sales-to-price ratio.

Return type:

DataColumn

Notes

The sales-to-price ratio is computed as:

\[\mathrm{Sales\ to\ Price} = \frac{\mathrm{Revenue}}{\mathrm{Market\ Cap}}\]

In Excel, assuming LTM revenue in column A and market cap in column B (starting at row 2):

  1. In cell C2, enter:

    =A2 / B2

  2. Drag the formula down to apply it to subsequent rows.