Book Value Per Share Excel
The term book value is a company s assets minus its liabilities and is sometimes referred to as stockholder s equity owner s equity shareholder s equity or simply equity.
Book value per share excel. Book value per share shareholders equity preferred equity total outstanding common shares. One of the limitations of book value per share as a valuation method is that it is based on the book value and it excludes other material factors that can affect the price of a company s share. Book value per share 2.
Book value per share total common stockholders equity preferred stock number of common shares. Mero lagani 4th floor orchid hotel building tripureshwor kathmandu nepal tel. Drawbacks of book value per share.
Book value per share is determined by dividing common shareholders equity by total number of outstanding shares. The book value of a share of stock is represented as book value per share. For example intangible factors affect the value of a company s shares and are left out when calculating the bvps.
Price to book value market price per share book value per share. Book value per share. Shareholders equity preferred shares.
Total number of outstanding shares. Book value per share 30 1. Book value per share rs 30 per share.
Book value per share book value of equity total shares outstanding. This number is determined by dividing the company s total amount of stockholders equity by the number of outstanding shares of common stock. Book value per share 25 000 000 5 000 000 10 000 000.