Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Market Value Added (MVA)

Microsoft Excel

MVA

Microsoft Corp., MVA calculation

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Fair value of debt and finance lease liabilities1 76,138 63,267 65,802 82,541 86,596 85,474
Operating lease liability 19,077 15,137 13,717 11,591 9,287 7,703
Market value of common equity 3,143,581 2,457,171 2,061,436 2,153,016 1,551,445 1,054,145
Less: Investments 61,714 79,250 91,282 116,716 123,365 123,027
Market (fair) value of Microsoft 3,177,082 2,456,325 2,049,673 2,130,432 1,523,963 1,024,295
Less: Invested capital2 351,567 247,490 194,094 143,637 107,630 96,412
MVA 2,825,515 2,208,835 1,855,579 1,986,795 1,416,333 927,883

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 Fair value of debt. See details »

2 Invested capital. See details »

Item Description The company
MVA Microsoft Corp. market (fair) value less invested capital. Microsoft Corp. MVA increased from 2022 to 2023 and from 2023 to 2024.

MVA Spread Ratio

Microsoft Corp., MVA spread ratio calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Market value added (MVA)1 2,825,515 2,208,835 1,855,579 1,986,795 1,416,333 927,883
Invested capital2 351,567 247,490 194,094 143,637 107,630 96,412
Performance Ratio
MVA spread ratio3 803.69% 892.49% 956.02% 1,383.21% 1,315.93% 962.41%
Benchmarks
MVA Spread Ratio, Competitors4
Accenture PLC 524.20% 487.90% 442.58% 739.74% 550.21% 505.40%
Adobe Inc. 642.58% 991.60% 658.07% 1,033.13% 1,082.99% 884.94%
Cadence Design Systems Inc. 1,934.83% 1,302.22% 1,110.87% 1,232.57% 792.57%
CrowdStrike Holdings Inc. 1,264.87% 608.44% 1,273.85% 1,618.34% 1,449.48%
International Business Machines Corp. 100.64% 60.20% 54.96% 39.12% 47.78%
Intuit Inc. 624.57% 573.60% 406.80% 1,175.12% 976.09% 1,553.30%
Oracle Corp. 370.24% 324.04% 224.95% 260.27% 180.84% 220.64%
Palantir Technologies Inc. 3,878.69% 488.89% 829.78% 1,919.83%
Palo Alto Networks Inc. 894.07% 731.80% 559.30% 573.51% 267.94% 424.83%
Salesforce Inc. 256.35% 126.24% 150.31% 270.75% 226.93% 326.41%
ServiceNow Inc. 1,781.94% 1,276.80% 1,798.18% 2,575.52% 2,192.76%
Synopsys Inc. 645.36% 973.25% 565.55% 707.79% 468.10% 272.11%

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 MVA. See details »

2 Invested capital. See details »

3 2024 Calculation
MVA spread ratio = 100 × MVA ÷ Invested capital
= 100 × 2,825,515 ÷ 351,567 = 803.69%

4 Click competitor name to see calculations.

Performance ratio Description The company
MVA spread ratio The ratio of MVA to invested capital. It measures the efficiency with which investors’ capital investment has translated into a franchise value and into an aggregate net present value premium. Microsoft Corp. MVA spread ratio deteriorated from 2022 to 2023 and from 2023 to 2024.

MVA Margin

Microsoft Corp., MVA margin calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
Selected Financial Data (US$ in millions)
Market value added (MVA)1 2,825,515 2,208,835 1,855,579 1,986,795 1,416,333 927,883
 
Revenue 245,122 211,915 198,270 168,088 143,015 125,843
Add: Increase (decrease) in unearned revenue 6,371 5,405 4,267 4,961 1,974 4,486
Adjusted revenue 251,493 217,320 202,537 173,049 144,989 130,329
Performance Ratio
MVA margin2 1,123.50% 1,016.40% 916.17% 1,148.11% 976.86% 711.95%
Benchmarks
MVA Margin, Competitors3
Accenture PLC 297.40% 251.01% 213.17% 379.26% 279.96% 233.58%
Adobe Inc. 727.86% 1,241.42% 766.46% 1,287.44% 1,554.19% 1,330.31%
Cadence Design Systems Inc. 1,927.61% 1,299.21% 1,128.47% 1,241.37% 769.46%
CrowdStrike Holdings Inc. 1,984.37% 816.60% 1,995.27% 3,362.60% 1,272.66%
International Business Machines Corp. 179.50% 104.54% 104.85% 68.01% 81.54%
Intuit Inc. 959.77% 939.31% 782.89% 1,489.94% 1,098.60% 1,034.92%
Oracle Corp. 704.48% 626.94% 412.88% 514.72% 411.93% 401.82%
Palantir Technologies Inc. 2,081.46% 820.15% 1,366.76% 3,910.89%
Palo Alto Networks Inc. 949.23% 726.58% 651.61% 771.73% 434.98% 469.70%
Salesforce Inc. 593.25% 321.51% 417.33% 620.94% 558.53% 642.57%
ServiceNow Inc. 1,433.56% 1,026.06% 1,555.49% 2,101.04% 1,606.91%
Synopsys Inc. 1,081.63% 1,373.41% 796.87% 1,126.17% 803.94% 470.26%

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 MVA. See details »

2 2024 Calculation
MVA margin = 100 × MVA ÷ Adjusted revenue
= 100 × 2,825,515 ÷ 251,493 = 1,123.50%

3 Click competitor name to see calculations.

Performance ratio Description The company
MVA margin The ratio of MVA to sales. It measures how efficiently and prodigiously sales translate into franchise value. Microsoft Corp. MVA margin ratio improved from 2022 to 2023 and from 2023 to 2024.