c_book_to_price

c_book_to_price(fbs_assets, fbs_liabilities, fbs_preferred_stock_value, c_market_cap)

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.