Book Value Per Share Excel
Price to book value is calculated as.
Book value per share excel. Total outstanding shares total number of shares issued shares as treasury stock. Drawbacks of book value per share. The book value per share formula is used to calculate the per share value of a company based on its equity available to common shareholders.
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. 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.
For example intangible factors affect the value of a company s shares and are left out when calculating the bvps. 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 book value of equity total shares outstanding.
The bvps is calculated by dividing a company s common equity value by its total number of shares outstanding. For example assume company abc s value of common equity is 100 million and it has. This shows anand group of a company have the book value per share of 2.
The book value of a share of stock is represented as book value per share. Book value per share shareholders equity preferred equity total outstanding common shares. Shareholders equity preferred shares.
By using the book value per share formula. Book value per share rs 30 per share. Hence book value per share is calculated as.