GURUFOCUS.COM » STOCK LIST » Technology » Hardware » Dell Inc (DELISTED:DELL) » Definitions » Cyclically Adjusted PB Ratio

Dell (DELL) Cyclically Adjusted PB Ratio : (As of Jun. 04, 2024)


View and export this data going back to . Start your Free Trial

What is Dell Cyclically Adjusted PB Ratio?

Shiller PE for Stocks: The True Measure of Stock Valuation


Dell Cyclically Adjusted PB Ratio Historical Data

The historical data trend for Dell's Cyclically Adjusted PB Ratio can be seen below:

* For Operating Data section: All numbers are indicated by the unit behind each term and all currency related amount are in USD.
* For other sections: All numbers are in millions except for per share data, ratio, and percentage. All currency related amount are indicated in the company's associated stock exchange currency.

* Premium members only.

Dell Cyclically Adjusted PB Ratio Chart

Dell Annual Data
Trend Jan04 Jan05 Jan06 Jan07 Jan08 Jan09 Jan10 Jan11 Jan12 Jan13
Cyclically Adjusted PB Ratio
Get a 7-Day Free Trial Premium Member Only Premium Member Only - - - - -

Dell Quarterly Data
Oct08 Jan09 Apr09 Jul09 Oct09 Jan10 Apr10 Jul10 Oct10 Jan11 Apr11 Jul11 Oct11 Jan12 Apr12 Jul12 Oct12 Jan13 Apr13 Jul13
Cyclically Adjusted PB Ratio Get a 7-Day Free Trial Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only Premium Member Only - - - - -

Competitive Comparison of Dell's Cyclically Adjusted PB Ratio

For the Computer Hardware subindustry, Dell's Cyclically Adjusted PB Ratio, along with its competitors' market caps and Cyclically Adjusted PB Ratio data, can be viewed below:

* Competitive companies are chosen from companies within the same industry, with headquarter located in same country, with closest market capitalization; x-axis shows the market cap, and y-axis shows the term value; the bigger the dot, the larger the market cap. Note that "N/A" values will not show up in the chart.


Dell's Cyclically Adjusted PB Ratio Distribution in the Hardware Industry

For the Hardware industry and Technology sector, Dell's Cyclically Adjusted PB Ratio distribution charts can be found below:

* The bar in red indicates where Dell's Cyclically Adjusted PB Ratio falls into.



Dell Cyclically Adjusted PB Ratio Calculation

Like the Shiller PE Ratio, the Cyclically Adjusted PB Ratio takes the Book Value per Share from the past 10 years, adjusts it for inflation, and then calculates the average. This average is then used for the P/B calculation. Because it considers this 10-year average, it's often referred to as the CAPB Ratio.

The Shiller PE Ratio was first used by professor Robert Shiller to measure the valuation of the overall market. The similar calculation is applied by GuruFocus to calculate the Cyclically Adjusted PB Ratio.

Dell's Cyclically Adjusted Book per Share for the quarter that ended in Jul. 2013 is calculated as:

For example, Dell's adjusted Book Value per Share data for the three months ended in Jul. 2013 was:

Adj_Book=Book Value per Share/CPI of Jul. 2013 (Change)*Current CPI (Jul. 2013)
=6.139/98.5566*98.5566
=6.139

Current CPI (Jul. 2013) = 98.5566.

Dell Quarterly Data

Book Value per Share CPI Adj_Book
200310 2.296 78.054 2.899
200401 2.482 78.138 3.131
200404 2.412 79.319 2.997
200407 2.486 79.910 3.066
200410 2.367 80.543 2.896
200501 2.637 80.458 3.230
200504 2.323 82.104 2.789
200507 2.298 82.441 2.747
200510 2.048 84.045 2.402
200601 1.754 83.665 2.066
200604 1.463 85.015 1.696
200607 1.328 85.859 1.524
200610 1.517 85.142 1.756
200701 1.936 85.402 2.234
200704 2.268 87.203 2.563
200707 2.651 87.884 2.973
200710 3.054 88.152 3.414
200801 1.829 89.057 2.024
200804 1.691 90.636 1.839
200807 1.442 92.805 1.531
200810 2.139 91.375 2.307
200901 2.189 89.084 2.422
200904 2.168 89.968 2.375
200907 2.366 90.859 2.566
200910 2.569 91.207 2.776
201001 2.882 91.423 3.107
201004 3.007 91.980 3.222
201007 3.168 91.981 3.394
201010 3.530 92.277 3.770
201101 4.049 92.914 4.295
201104 4.408 94.890 4.578
201107 4.545 95.319 4.699
201110 4.826 95.529 4.979
201201 5.064 95.632 5.219
201204 5.310 97.075 5.391
201207 5.619 96.661 5.729
201210 5.862 97.595 5.920
201301 6.145 97.158 6.233
201304 6.029 98.107 6.057
201307 6.139 98.557 6.139

Add all the adjusted book value per share together and divide the count will get our Cyclically Adjusted Book per Share.

Please note that we use the CPI data of the country/region where the company is headquartered. If the CPI data for that country/region is not available, then we will use the CPI data of the United States as default.


Dell  (DELISTED:DELL) Cyclically Adjusted PB Ratio Explanation

Compared with the regular PB Ratio, which works poorly for cyclical businesses, the Cyclically Adjusted PB Ratio smoothed out the fluctuations of book value during business cycles. Therefore it is more accurate in reflecting the valuation of the company.

If a company has consistent business performance, the Cyclically Adjusted PB Ratio should give similar results to regular PB Ratio.


Dell Cyclically Adjusted PB Ratio Related Terms

Thank you for viewing the detailed overview of Dell's Cyclically Adjusted PB Ratio provided by GuruFocus.com. Please click on the following links to see related term pages.


Dell (DELL) Business Description

Industry
Traded in Other Exchanges
N/A
Address
Dell Inc is a Delaware Corporation, which was founded in 1984. The Company offers a range of technology solutions, including servers and networking products, storage products, services, software and peripherals, mobility products, and desktop PCs. The Company sells its products and services directly to customers through dedicated distribution channels, such as retailers, distributors, and resellers. Its business segments are Large Enterprise, Public, Small and Medium Business ('SMB'), and Consumer. Large Enterprise customers include large global and national corporate businesses. Public customers, which include educational institutions, government, health care, and law enforcement agencies, operate in their own communities. SMB segment is focused on helping small and medium-sized businesses get the most out of their technology by offering scalable products, services, and solutions. Consumer segment is focused on delivering what customers want from the total technology experience of entertainment, mobility, gaming, and design. The Company designs, develops, manufactures, markets, sells, and supports a range of products, solutions, and services. The Company also provides various customer financial services to its Commercial and Consumer customers. Its enterprise solutions include servers, networking, and storage products. The Company's services include a range of configurable IT and business services, including infrastructure technology, consulting and applications, and product-related support services. The Company offers Dell-branded printers and displays and a multitude of competitively priced third-party peripheral products such as printers, televisions, notebook accessories, mice, keyboards, networking and wireless products, digital cameras, and other products. The Company also sells a range of third-party software products, including operating systems, business and office applications, anti-virus and related security software, entertainment software, and products in various other categories. Client Products offers a variety of mobility and desktop products, including notebooks, workstations, tablets, smartphones, and desktop PCs, to its Commercial and Consumer customers. The Company offers or arranges various financing options and services for its Commercial and Consumer customers in the U.S. and Canada through Dell Financial Services ('DFS'). DFS offers a range of financial services, including originating, collecting, and servicing customer receivables related to the purchase of Dell products. DFS offers private label credit financing programs to qualified Consumer and Commercial customers and offers leases and fixed-term financing to Commercial customers. The Company sells its products and services directly to customers and through various other sales distribution channels, such as retailers, third-party solution providers, system integrators, and third-party resellers. Its customers include large global and national corpora