Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

$24.99

Common Stock Valuation Ratios (Price Multiples)

Microsoft Excel

Current Valuation Ratios

Microsoft Corp., current price multiples

Microsoft Excel
Microsoft Corp. Accenture PLC Adobe Inc. Cadence Design Systems Inc. CrowdStrike Holdings Inc. International Business Machines Corp. Intuit Inc. Oracle Corp. Palantir Technologies Inc. Palo Alto Networks Inc. Salesforce Inc. ServiceNow Inc. Synopsys Inc. Workday Inc. Software & Services Information Technology
Selected Financial Data
Current share price (P)
No. shares of common stock outstanding
Growth rate (g)
 
Earnings per share (EPS)
Next year expected EPS
Operating profit per share
Sales per share
Book value per share (BVPS)
Valuation Ratios (Price Multiples)
Price to earnings (P/E)
Price to next year expected earnings
Price-earnings-growth (PEG)
Price to operating profit (P/OP)
Price to sales (P/S)
Price to book value (P/BV)

Based on: 10-K (reporting date: 2024-06-30).

If the company price multiple is lower then the price multiple of benchmark then company stock is relatively undervalued.
Otherwise, if the company price multiple is higher then the price multiple of benchmark then company stock is relatively overvalued.


Historical Valuation Ratios (Summary)

Microsoft Corp., historical price multiples

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Price to earnings (P/E)
Price to operating profit (P/OP)
Price to sales (P/S)
Price to book value (P/BV)

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).

Price to Earnings (P/E) Ratio
The price to earnings ratio showed an overall increasing trend from 26.86 in mid-2019 to 35.67 by mid-2024, indicating rising investor expectations for earnings growth. The ratio peaked in mid-2021 at 35.14 and experienced a dip in mid-2022 to 28.34, before recovering and surpassing previous highs in subsequent years. This fluctuation suggests periods of varying market sentiment or earnings performance, with a strong recovery in valuation multiples in the latest periods.
Price to Operating Profit (P/OP) Ratio
This ratio followed a somewhat similar pattern to the P/E ratio, increasing from 24.54 in mid-2019 to a peak of 30.79 in mid-2021, then decreasing sharply to 24.72 in mid-2022. From mid-2022 through mid-2024, the ratio gradually increased again to 28.73. The movements imply a strong valuation during 2020-2021, a correction in mid-2022, and renewed confidence in operating profit prospects thereafter.
Price to Sales (P/S) Ratio
The price to sales ratio showed a consistent upward trajectory over the five-year period, rising significantly from 8.38 in 2019 to 12.82 in 2024. Though there was a slight reduction in mid-2022 to 10.4, this ratio soon rebounded and continued to grow, reflecting increasing market valuation relative to revenue. The steady growth denotes strong sales performance or improved revenue quality driving investor valuation.
Price to Book Value (P/BV) Ratio
The price to book ratio demonstrated a rising trend up to mid-2021, moving from 10.3 in 2019 to a high of 15.16. However, from mid-2021 onwards, the ratio declined steadily to 11.71 by 2024. This downward shift suggests a relative decrease in market valuation against the book value of assets, possibly indicating changing investor perceptions about asset quality or growth prospects despite other valuation multiples rising.

Price to Earnings (P/E)

Microsoft Corp., historical P/E calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
No. shares of common stock outstanding1
Selected Financial Data (US$)
Net income (in millions)
Earnings per share (EPS)2
Share price1, 3
Valuation Ratio
P/E ratio4
Benchmarks
P/E Ratio, Competitors5
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.
P/E Ratio, Sector
Software & Services
P/E Ratio, Industry
Information Technology

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).

1 Data adjusted for splits and stock dividends.

2 2024 Calculation
EPS = Net income ÷ No. shares of common stock outstanding
= ÷ =

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

4 2024 Calculation
P/E ratio = Share price ÷ EPS
= ÷ =

5 Click competitor name to see calculations.

The financial data displays noteworthy trends over the five-year period ending June 30, 2024. There has been a consistent and substantial increase in the share price, which rose from $138.06 in 2019 to $422.92 in 2024. This represents an approximate threefold increase, signaling significant market confidence and valuation growth.

Earnings per share (EPS) have also shown a positive trajectory, advancing from $5.14 in 2019 to $11.86 in 2024. Notably, EPS growth was steady each year, with the most substantial increases occurring between 2020 and 2022, where it moved from $5.85 to $9.75, indicating improving profitability and operational performance over time.

The price-to-earnings (P/E) ratio exhibits greater variability but generally fluctuates within a range of roughly 26.86 to 35.67. The P/E ratio increased from 26.86 in 2019 to above 35 in 2020 and 2021, possibly reflecting heightened investor expectations for future earnings growth during that period. A dip to 28.34 occurred in 2022, which could suggest a market adjustment or recalibration in valuation relative to earnings. However, the ratio rose again to above 33 by 2023 and further to 35.67 in 2024, indicating renewed investor optimism or perhaps slower EPS growth relative to the share price increase in those years.

Overall, the combined rise in share price and EPS reflects robust financial health and strong earnings growth. The P/E fluctuations imply that while investor sentiment has remained generally positive, valuations have been periodically reassessed in response to changing market conditions or future earnings expectations.


Price to Operating Profit (P/OP)

Microsoft Corp., historical P/OP calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
No. shares of common stock outstanding1
Selected Financial Data (US$)
Operating income (in millions)
Operating profit per share2
Share price1, 3
Valuation Ratio
P/OP ratio4
Benchmarks
P/OP Ratio, Competitors5
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.
P/OP Ratio, Sector
Software & Services
P/OP Ratio, Industry
Information Technology

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).

1 Data adjusted for splits and stock dividends.

2 2024 Calculation
Operating profit per share = Operating income ÷ No. shares of common stock outstanding
= ÷ =

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

4 2024 Calculation
P/OP ratio = Share price ÷ Operating profit per share
= ÷ =

5 Click competitor name to see calculations.

The data reveals a consistent upward trajectory in share price over the five-year period ending June 30, 2024. The share price increased from $138.06 in 2019 to $422.92 in 2024, indicating substantial growth in market valuation.

Operating profit per share also showed a steady increase, rising from $5.63 in 2019 to $14.72 in 2024. This growth reflects improving profitability on a per-share basis and suggests effective operational performance over time.

The price-to-operating profit (P/OP) ratio exhibited some variability but remained generally stable with moderate fluctuations. Starting at 24.54 in 2019, it peaked at 30.79 in 2021 before declining to around 28.73 by 2024. This indicates that while the market price increased significantly, the valuation in relation to operating profit did not escalate disproportionately, suggesting a balanced market assessment of the company's profitability improvements.

Share Price Trend
Substantial increase, more than tripling over five years.
Operating Profit Per Share
Consistent growth, nearly tripling from 2019 to 2024.
P/OP Ratio
Moderate fluctuation with an initial increase followed by stabilization in the high 20s.

Overall, the financial data reflects robust growth in both market valuation and operating profitability, with relative valuation ratios maintaining a stable range, underscoring investor confidence in the company's sustained performance improvements.


Price to Sales (P/S)

Microsoft Corp., historical P/S calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
No. shares of common stock outstanding1
Selected Financial Data (US$)
Revenue (in millions)
Sales per share2
Share price1, 3
Valuation Ratio
P/S ratio4
Benchmarks
P/S Ratio, Competitors5
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.
P/S Ratio, Sector
Software & Services
P/S Ratio, Industry
Information Technology

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).

1 Data adjusted for splits and stock dividends.

2 2024 Calculation
Sales per share = Revenue ÷ No. shares of common stock outstanding
= ÷ =

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

4 2024 Calculation
P/S ratio = Share price ÷ Sales per share
= ÷ =

5 Click competitor name to see calculations.

The analysis of the financial data over the period from June 30, 2019 to June 30, 2024 reveals several notable trends regarding the share price, sales per share, and price-to-sales (P/S) ratio.

Share Price
The share price exhibits a consistent upward trajectory throughout the five-year period, rising from $138.06 in mid-2019 to $422.92 by mid-2024. Despite a slight decrease between June 2021 and June 2022, where the share price dropped from $286.50 to $276.41, the overall trend is strongly positive, with the most significant year-over-year increases occurring between 2022 and 2024. This suggests growing investor confidence and potentially robust market performance or positive expectations.
Sales per Share
Sales per share also demonstrate a steady increase annually, rising from $16.48 in 2019 to $32.98 in 2024. This consistent growth indicates improving revenue generation on a per-share basis, pointing toward expanded business activity or enhanced operational efficiency. The growth rate appears to accelerate notably after 2021, corresponding with the trends observed in the share price.
Price-to-Sales (P/S) Ratio
The P/S ratio fluctuates somewhat but generally trends upward from 8.38 in 2019 to 12.82 in 2024, with a dip in 2022 to 10.4. The increase in the P/S ratio over time implies that the market is willing to pay a higher price relative to sales, reflecting positive investor sentiment and perceived growth potential. The drop in 2022 correlates with the decrease in share price during that year, suggesting temporary market reevaluation despite continuing sales growth.

Overall, the data indicate strong and consistent growth in key financial metrics over the period in review, with a short-term anomaly in 2022 that did not hinder the longer-term upward trend. The steady increase in sales per share combined with rising share prices and P/S ratios signals robust financial health and favorable market positioning.


Price to Book Value (P/BV)

Microsoft Corp., historical P/BV calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
No. shares of common stock outstanding1
Selected Financial Data (US$)
Stockholders’ equity (in millions)
Book value per share (BVPS)2
Share price1, 3
Valuation Ratio
P/BV ratio4
Benchmarks
P/BV Ratio, Competitors5
Accenture PLC
Adobe Inc.
Cadence Design Systems Inc.
CrowdStrike Holdings Inc.
International Business Machines Corp.
Intuit Inc.
Oracle Corp.
Palantir Technologies Inc.
Palo Alto Networks Inc.
Salesforce Inc.
ServiceNow Inc.
Synopsys Inc.
Workday Inc.
P/BV Ratio, Sector
Software & Services
P/BV Ratio, Industry
Information Technology

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).

1 Data adjusted for splits and stock dividends.

2 2024 Calculation
BVPS = Stockholders’ equity ÷ No. shares of common stock outstanding
= ÷ =

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

4 2024 Calculation
P/BV ratio = Share price ÷ BVPS
= ÷ =

5 Click competitor name to see calculations.

The financial data over the examined period reveals several notable trends regarding the company's market valuation and underlying book value.

Share Price
The share price demonstrated a consistent upward trajectory from June 30, 2019 to June 30, 2024. It increased from $138.06 to $422.92, signifying strong market confidence and growth in perceived company value. The most substantial absolute increases occurred between 2019 to 2021 and again from 2023 to 2024, although a slight dip was noted between 2021 and 2022.
Book Value Per Share (BVPS)
The book value per share showed steady growth throughout the entire time frame, rising from $13.40 in 2019 to $36.12 in 2024. This indicates that the company's net asset value per share is improving, reflecting positive developments in equity and possibly retained earnings.
Price-to-Book Value Ratio (P/BV)
The P/BV ratio fluctuated over the years, peaking at 15.16 in June 2021 and subsequently declining to 11.71 by June 2024. This suggests that although the market price increased substantially, it grew at a somewhat slower rate relative to the book value after 2021. The decrease in the P/BV ratio after 2021 indicates a relative valuation moderation or improved book value growth outpacing share price appreciation.

In summary, the data reflects a strong growth in both market price and book value per share, with the price-to-book ratio signaling a market valuation that became somewhat more aligned with the company's fundamental net asset value over time. The trends suggest sustained investor confidence and ongoing enhancement of the company’s intrinsic equity value.