Book Value Formula In Excel

So let me share with you 6 quick methods for this.

Book value formula in excel. Therefore the calculation of book value per share will be as follows bvps total common shareholders equity preferred stock number of outstanding common shares 2 93 491 00 cr 592 18 cr. Price to book value is calculated as. Click here to download the sample excel file.

Price to book value market price per share book value per share. Thanks for reading. By using the book value per share formula.

Taking assumed values for the following. Things to remember about the value function. From the starting days of my job i have learned one thing hard.

The value function uses the arguments there is only one argument in the value function which is mentioned below. Price to book value 3 33. Price to book value rs 100 rs 30.

Book value per share shareholders equity preferred equity total outstanding common shares. To arrive at the book value simply subtract the depreciation to date from the cost. Book value per share 25 000 000 5 000 000 10 000 000.

Book value per share will be bvps 495 61 book value calculator. Book value per share 30 1. Just think this way when you send a report to someone they are not concerned with formulas but with the values that a formula returns.