c_book_value_per_share#

c_book_value_per_share(fbs_assets, fbs_liabilities, fbs_preferred_stock_value, fis_weighted_average_basic_shares_outstanding)[source]

Calculate the book value per share.

Parameters:

  • fbs_assets (DataColumn) – The total assets.

  • fbs_liabilities (DataColumn) – The total liabilities.

  • fbs_preferred_stock_value (DataColumn) – The preferred stock value.

  • fis_weighted_average_basic_shares_outstanding (DataColumn) – The weighted average basic shares outstanding.

Returns:

The book value per share.

Return type:

DataColumn

Notes

Book value per share is calculated as:

\[\mathrm{Book\ Value\ Per\ Share} = \frac{ \mathrm{Total\ Assets} - ( \mathrm{Total\ Liabilities} + \mathrm{Preferred\ Stock} ) }{ \mathrm{Weighted\ Average\ Basic\ Shares\ Outstanding} }\]

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

  1. In cell E2, enter:

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

  2. Drag the formula down through column E.