c_book_to_price#

c_book_to_price(fbs_assets, fbs_liabilities, fbs_preferred_stock_value, c_market_cap)[source]

Calculate the book-to-price ratio.

Parameters:

  • fbs_assets (DataColumn) – The total assets.

  • fbs_liabilities (DataColumn) – The total liabilities.

  • fbs_preferred_stock_value (DataColumn) – The preferred stock.

  • c_market_cap (DataColumn) – The market capitalization.

Returns:

The book-to-price ratio.

Return type:

DataColumn

Notes

Book-to-price is calculated as:

\[\text{Book-to-Price} = \frac{ \mathrm{Total\ Assets} - ( \mathrm{Total\ Liabilities} + \mathrm{Preferred\ Stock} ) }{ \mathrm{Market\ Cap} }\]

In Excel, assuming total assets in column A, total liabilities in column B, preferred stock in column C, and market cap in column D (starting at row 2):

  1. In cell E2, enter:

    =(A2 - (B2 + C2)) / D2

  2. Drag the formula down through column E.