Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Enterprise Value to FCFF (EV/FCFF)

Microsoft Excel

Free Cash Flow to The Firm (FCFF)

Microsoft Corp., FCFF calculation

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Net income 72,361 72,738 61,271 44,281 39,240 16,571
Net noncash charges 17,609 15,851 16,405 17,877 9,079 6,846
Changes in operating assets and liabilities (2,388) 446 (936) (1,483) 3,866 20,467
Net cash from operations 87,582 89,035 76,740 60,675 52,185 43,884
Cash paid for interest on debt, net of tax1 1,377 1,651 1,724 2,004 2,165 1,994
Additions to property and equipment (28,107) (23,886) (20,622) (15,441) (13,925) (11,632)
Right-of-use assets obtained in exchange for finance lease obligations (3,128) (4,234) (3,290) (3,467) (2,532) (1,933)
Free cash flow to the firm (FCFF) 57,724 62,566 54,552 43,771 37,893 32,313

Based on: 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).

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Microsoft Corp. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Microsoft Corp. FCFF increased from 2021 to 2022 but then slightly decreased from 2022 to 2023 not reaching 2021 level.

Interest Paid, Net of Tax

Microsoft Corp., interest paid, net of tax calculation

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Effective Income Tax Rate (EITR)
EITR1 19.00% 13.10% 13.80% 16.50% 9.80% 16.90%
Interest Paid, Net of Tax
Cash paid for interest on debt, before tax 1,700 1,900 2,000 2,400 2,400 2,400
Less: Cash paid for interest on debt, tax2 323 249 276 396 235 406
Cash paid for interest on debt, net of tax 1,377 1,651 1,724 2,004 2,165 1,994

Based on: 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).

1 See details »

2 2023 Calculation
Cash paid for interest on debt, tax = Cash paid for interest on debt × EITR
= 1,700 × 19.00% = 323


Enterprise Value to FCFF Ratio, Current

Microsoft Corp., current EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Selected Financial Data (US$ in millions)
Enterprise value (EV) 3,084,451
Free cash flow to the firm (FCFF) 57,724
Valuation Ratio
EV/FCFF 53.43
Benchmarks
EV/FCFF, Competitors1
Accenture PLC 22.85
Adobe Inc. 31.56
International Business Machines Corp. 15.71
Intuit Inc. 36.80
Oracle Corp. 36.97
Palo Alto Networks Inc. 34.30
Salesforce Inc. 29.72
ServiceNow Inc. 55.91
Synopsys Inc. 56.71
EV/FCFF, Sector
Software & Services 42.31
EV/FCFF, Industry
Information Technology 44.28

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

1 Click competitor name to see calculations.

If the company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.
Otherwise, if the company EV/FCFF is higher then the EV/FCFF of benchmark then company is relatively overvalued.


Enterprise Value to FCFF Ratio, Historical

Microsoft Corp., historical EV/FCFF calculation, comparison to benchmarks

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Selected Financial Data (US$ in millions)
Enterprise value (EV)1 2,410,213 2,021,362 2,093,369 1,487,741 999,078 775,247
Free cash flow to the firm (FCFF)2 57,724 62,566 54,552 43,771 37,893 32,313
Valuation Ratio
EV/FCFF3 41.75 32.31 38.37 33.99 26.37 23.99
Benchmarks
EV/FCFF, Competitors4
Accenture PLC 20.26 16.99 24.76 17.90 18.49 17.18
Adobe Inc. 37.75 20.82 33.61 40.43 40.48 31.36
International Business Machines Corp. 15.27 16.47 13.10 9.35 12.86
Intuit Inc. 31.28 32.85 48.64 37.90 33.30 27.69
Oracle Corp. 35.83 31.60 16.36 14.99 14.03 11.11
Palo Alto Networks Inc. 28.15 29.29 32.74 26.50 20.44 22.33
Salesforce Inc. 28.41 35.97 44.91 39.63 41.21
ServiceNow Inc. 56.49 40.86 60.13 83.74 67.96
Synopsys Inc. 55.87 30.82 38.59 42.88 33.32 37.07
EV/FCFF, Sector
Software & Services 35.26 29.16 31.90 27.10 23.26
EV/FCFF, Industry
Information Technology 34.25 27.01 27.93 24.12 19.69

Based on: 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).

1 See details »

2 See details »

3 2023 Calculation
EV/FCFF = EV ÷ FCFF
= 2,410,213 ÷ 57,724 = 41.75

4 Click competitor name to see calculations.

Valuation ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Microsoft Corp. EV/FCFF ratio decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.