Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS
Data

Price Per Book (TTM)

Live
1.47
It is the multiple at which share price is trading to the book value of the share

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
Price Per Book (TTM)
StockPrice Per Book (TTM)

SWK

1.47

SNA

2.94

KMT

1.85

LECO

9.87

ITW

23.35

MMM

4.81

TTC

8.36

GE

2.77

PFIN

0.41
Stanley Black & Decker Inc. logo

Stanley Black & Decker Inc.

Sector: 
Industrials
   

Industry: 
Tools & Accessories

86.16
 
USD
  
1.74
  
(2.06%)
Optionable: Yes  Market Cap: 12,964 M  90-day average vol: 1,777,142

Previous close: 84.42  Open: 84.42  Bid: 86.5  Ask: 86.5
52 week range    
70.24   
   177.77
Peers   
SNA / 
KMT / 
MKTAY / 
LECO / 
ITW / 
MMM / 
TTC / 
GE / 
Last updated: Monday 30th January 2023
53
MarketXLS Rank marketxls
70
Value marketxls
46
Technical marketxls
44
Quality marketxls

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
Search for a stock
Are you?
twitterstocktwits
Call: 1-877-778-8358
Ankur Mohan MarketXLS
I am so happy you are here. My name is Ankur and I am the founder/CEO of MarketXLS. Over the past four years, I have helped more than 2500 customers to implement their own investment research strategies and monitoring systems in Excel.
Implement “your own” investment strategies in Excel with thousands of MarketXLS functions and starter sheets.
Get started today