Price to Book Ratio (TTM)
Returns the Price to Book ratio, which compares a company's market value to its book value (shareholders' equity).
P/B Formula
P/B Ratio = Market Cap / Book Value Or: P/B Ratio = Stock Price / Book Value Per Share
Understanding P/B
| P/B Range | General Interpretation |
|---|---|
| < 1 | Trading below book value (potentially undervalued or distressed) |
| 1-3 | Common for established companies |
| 3-10 | Growth premium, intangible assets |
| > 10 | High growth, asset-light business |
Industry Differences
| Industry | Typical P/B |
|---|---|
| Banks | 0.8 - 1.5 |
| Insurance | 1.0 - 2.0 |
| Tech | 5 - 20+ |
| Manufacturing | 2 - 5 |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
Syntax
=PricePerBook(Symbol)Returns
Price to Book ratio
Examples
=PricePerBook("AAPL")=PricePerBook("JPM")=PricePerBook("BAC")=PricePerBook("BRK.B")=PricePerBook(A1)When to Use
- Value asset-heavy companies (banks, insurance)
- Identify potentially undervalued stocks (P/B < 1)
- Compare similar companies
- Warren Buffett-style value investing
- Banking sector analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need earnings-based valuation | PERatio() |
| Need revenue-based valuation | PricePerSales() |
| Need cash flow valuation | CashFlowPerShare() |
| Tech/service companies | P/E or P/S often more relevant |
Common Issues & FAQ
Why is P/B returning "NA"?
Check that:
- The symbol is valid
- The company has positive book value
- Financial statements are available
Why are tech stocks' P/B so high?
Tech companies often have few tangible assets but significant intangible value (IP, brand, talent) not reflected in book value.
When is P/B most useful?
P/B is most useful for asset-heavy industries like banks, insurance, and real estate where book value is meaningful.
Excel Templates Using Price to Book Ratio (TTM)
These ready-made MarketXLS templates call PricePerBook() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Key Ratios formulas you can use in the same worksheet:
- Price To Cashflow
- Price To Free Cashflow
- Price To Tangible Book Ratio
- Profit Margin
- Quick Ratio
- Receivables Turnover
- Return on Assets (Last 12 Months)
- Return On Assets (ROA - Last 12 Months)
See PricePerBook used in a complete workbook: Bank Earnings Tracker Excel: Q1 2026 Dashboard for Fed-Sensitive Financial Stocks
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today