Price to Book Value Formula | P/B Calculator (Excel Template)

Price to Book Value Formula (Table of Contents)

Price to Book Value Ratio Formula
P/B Ratio Calculator
P/B Ratio Template

Price to Book Value (P/B Ratio) Formula

Price to book value is an important measure to see how much equity shareholders are paying for the net assets value of the company. Price to book value ratio is also referred as market to book ratio. This ratio measures the proportion between the market price for a share and the book value per share.

Here’s the formula of price to book value ratio –

Example of Price to Book Value Ratio Formula

Let’s take a practical example to see how the price to book value ratio formula works.

Binge Watching TV wants to see how their investors perceive them in terms of book value. They took out the market price of their equity shares and also zoomed in on their balance sheet for the shareholders’ equity. Here’re the details they found out –

Market Price of each share – $105 per share
Book Value of each share – $84 per share

As an internal accountant, you need to find out the price to book value ratio.

To find out the P/B ratio, we need market price per share and book value per share. In the above example, we know both.

Using the P/B ratio formula, we get –

P/B Ratio formula = Market Price per Share / Book Value per Share
Or, P/B Ratio = $105 / $84 = 5/4 = 1.25.

Price to Book Value Ratio of Citigroup

Let us now apply Price to Book Value formula to calculate Citigroup P/B Ratio. First, we require Citigroup’s Balance sheet details. You may download Citigroups 10K report from here.

Below table show, the Consolidated Shareholder’s equity section found on Page 133

From the table above, Citigroup’s Shareholder’s equity is $221,857 million in 2015 and $210,185 million in 2014.

Corresponding common stock outstanding numbers are 3,099.48 million shares in 2015 and 3,083.037 million in 2014.

Citigroup’s Book value in 2015 = $221,857 / 3099.48 = 71.57
Citigroup’s Book value in 2014 = $210,185 / 3,083.037 = 68.174

Price of Citigroup as of 6th Feb, 2018 was $73.27

Citigroup P/B Ratio (2014) = $73.27/71.57 = 1.023x
Citigroup P/B Ratio (2015) = $73.27/68.174 = 1.074x

Explanation of Price to Book Value Ratio Formula

There are two components of the above formula.

The first component is the market price per share. Market price per share is volatile and it continually changes. The investor can decide to take the market price for a definite period and use an averaging method to find out a median.
The second component of this ratio is the book value per share. There are many ways we can calculate the book value of the company. The best and most common way to find out the book value of the company is to deduct the total liabilities from the total assets. Doing this allows the investors to find out the actual value at a certain point of time. Alternatively, the investors can also look at shareholders’ equity to find out the book value directly.

As you can understand, this ratio tries to analyze the proportion of the market price of each equity share and the book value per share at a certain point in time.

Use of Price to Book Value Ratio Formula

First of all, when an investor decides to invest in the company, she needs to know how much she needs to pay for a share of the net asset value per share. Having this comparison helps the investor decide whether this is a prudent investment or not.
To take this further, many investors would like to do the valuation of the stocks of the company. If the investors are investing in banking companies, insurance firms, or investment firms, this ratio can be pretty useful for them for valuing the companies.
One thing the investors need to keep in mind. This ratio is not useful for companies that need to maintain large assets, especially companies that have huge R&D expenditures or long-term fixed assets.

Price to Book Value Ratio Calculator

You can use the following Price to Book Value Calculator

Market Price per Share
Book Value per Share
Price to Book Value Ratio Formula=

Price to Book Value Ratio Formula=

Market Price per Share
	=
Book Value per Share

0
	=	0
0

Price to Book Value Ratio in Excel (with Excel Template)

Let us now do the same example above in Excel. This is very simple. You need to provide the two inputs of Market Price per Share and Book Value per Share. You can easily calculate the ratio in the template provided.

You can download this price to book value ratio template here – Price to Book Value Ratio Template