Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Price to Book Value (P/BV) 
since 2005

Microsoft Excel

Calculation

Microsoft Corp., P/BV, long-term trends, calculation

Microsoft Excel

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30), 10-K (reporting date: 2012-06-30), 10-K (reporting date: 2011-06-30), 10-K (reporting date: 2010-06-30), 10-K (reporting date: 2009-06-30), 10-K (reporting date: 2008-06-30), 10-K (reporting date: 2007-06-30), 10-K (reporting date: 2006-06-30), 10-K (reporting date: 2005-06-30).

1 US$

2 Data adjusted for splits and stock dividends.

3 Closing price as at the filing date of Microsoft Corp. Annual Report.

The analysis of the financial data over the given periods reveals several key trends and notable changes in the company's valuation metrics, specifically focusing on the share price, book value per share (BVPS), and price-to-book value (P/BV) ratio.

Share Price
The share price exhibited significant volatility over the years. Starting at $80.38 in August 2005, it remained relatively stable around the $79 to $80 range until 2007, where it peaked at $111.89. Subsequently, there was a sharp decline in 2008 to $25.72, and it further dropped slightly in 2009 to $23.81. From 2010 onwards, the share price demonstrated a strong upward trajectory, increasing steadily each year. Notably, between 2018 and 2024, the price surged from $108.04 to $422.92, reflecting substantial market confidence and growth in valuation in recent years.
Book Value per Share (BVPS)
The book value per share showed a generally consistent upward trend with some fluctuations. From $4.49 in 2005, it initially declined to a low of $3.32 in 2007 but began increasing thereafter. Between 2008 and 2014, BVPS grew from $3.97 to $10.90, with a minor decrease to $9.24 by 2016. After 2017, the BVPS resumed growth, rising steadily to reach $36.12 by 2024. This indicates an expansion of the company's net asset value on a per-share basis over the medium to long term.
Price-to-Book Value (P/BV) Ratio
The P/BV ratio experienced significant fluctuations, reflecting the changes in market valuation relative to book value. It started at a high level of 17.9 in 2005 and escalated sharply to 33.73 in 2007. This was followed by a pronounced decline to a low of 3.36 in 2013, coinciding with the period of lower share prices relative to book value. Thereafter, the P/BV ratio increased steadily, peaking at 15.16 in 2021 before declining to approximately 11.71 by 2024. This pattern suggests varying investor sentiment and market valuation multiples over time, with the ratio's decrease in recent years potentially indicating a closer alignment of share price with underlying book value.

Overall, the data portrays a company that experienced considerable share price volatility in the early years, strong recovery and growth in both share price and book value per share in the more recent periods, accompanied by fluctuations in its market valuation relative to book value. The sustained rise in book value per share alongside increasing share prices suggests fundamental growth, while movements in the P/BV ratio reflect changing market expectations and valuation norms.


Comparison to Competitors

Microsoft Corp., P/BV, long-term trends, comparison to competitors

Microsoft Excel

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30), 10-K (reporting date: 2012-06-30), 10-K (reporting date: 2011-06-30), 10-K (reporting date: 2010-06-30), 10-K (reporting date: 2009-06-30), 10-K (reporting date: 2008-06-30), 10-K (reporting date: 2007-06-30), 10-K (reporting date: 2006-06-30), 10-K (reporting date: 2005-06-30).


Comparison to Sector (Software & Services)

Microsoft Corp., P/BV, long-term trends, comparison to sector (software & services)

Microsoft Excel

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30), 10-K (reporting date: 2012-06-30), 10-K (reporting date: 2011-06-30), 10-K (reporting date: 2010-06-30), 10-K (reporting date: 2009-06-30), 10-K (reporting date: 2008-06-30), 10-K (reporting date: 2007-06-30), 10-K (reporting date: 2006-06-30), 10-K (reporting date: 2005-06-30).


Comparison to Industry (Information Technology)

Microsoft Corp., P/BV, long-term trends, comparison to industry (information technology)

Microsoft Excel

Based on: 10-K (reporting date: 2024-06-30), 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30), 10-K (reporting date: 2017-06-30), 10-K (reporting date: 2016-06-30), 10-K (reporting date: 2015-06-30), 10-K (reporting date: 2014-06-30), 10-K (reporting date: 2013-06-30), 10-K (reporting date: 2012-06-30), 10-K (reporting date: 2011-06-30), 10-K (reporting date: 2010-06-30), 10-K (reporting date: 2009-06-30), 10-K (reporting date: 2008-06-30), 10-K (reporting date: 2007-06-30), 10-K (reporting date: 2006-06-30), 10-K (reporting date: 2005-06-30).