Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Search for stocks (e.g., AAPL, GOOGL, AMZN)
KDP logo

KDP

NGS
Keurig Dr Pepper Inc.
Consumer DefensiveBeverages - Soft Drinks
Watchlists:
Last updated: Thursday 17th July 2025
33.21
+0.47 (1.44%)
Prev Close:32.74
Open:32.76
Bid:32.6
Ask:33.21
52 Week Range
30.12
38.28
Volume:11,565,422
Mkt Cap:44,467 M
Price Target
$38.19
+15.0%

Price Per Book (TTM)

Live
Returns the ratio of the stock's current price to its book value over the past 12 months.

How calculated

It is calculated by dividing share price by book value of the company per share

Example usage

=PricePerBook("MSFT")

Notes

Valuation of the company goes high with higher price to book number and vice versa

Assets

Stocks