Paying users zone. Data is covered by hidden.

  • Get to Microsoft Corp. for $19.99, or

  • get to entire website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc


Enterprise Value to FCFF (EV/FCFF)

Difficulty: Intermediate


Free Cash Flow to The Firm (FCFF)

Microsoft Corp., FCFF calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Net income hidden hidden hidden hidden hidden hidden
Net noncash charges hidden hidden hidden hidden hidden hidden
Changes in operating assets and liabilities hidden hidden hidden hidden hidden hidden
Net cash from operations hidden hidden hidden hidden hidden hidden
Cash paid for interest on debt, net of tax1 hidden hidden hidden hidden hidden hidden
Additions to property and equipment hidden hidden hidden hidden hidden hidden
Free cash flow to the firm (FCFF) hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

Item Description The company
FCFF Free cash flow to the firm is the cash flow available to the Microsoft Corp.’s suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made. Microsoft Corp.’s FCFF increased from 2016 to 2017 and from 2017 to 2018.

Interest Paid, Net of Tax

Microsoft Corp., interest paid, net of tax calculation

USD $ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Effective Income Tax Rate (EITR)
EITR1 hidden hidden hidden hidden hidden hidden
Interest Paid, Net of Tax
Cash paid for interest on debt, before tax hidden hidden hidden hidden hidden hidden
Less: Cash paid for interest on debt, tax2 hidden hidden hidden hidden hidden hidden
Cash paid for interest on debt, net of tax hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

2018 Calculations

2 Cash paid for interest on debt, tax = Cash paid for interest on debt × EITR
= hidden × hidden = hidden


Enterprise Value to FCFF Ratio, Current

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

Microsoft Excel LibreOffice Calc
Selected Financial Data (USD $ in millions)
Enterprise value (EV) hidden
Free cash flow to the firm (FCFF) hidden
Ratio
EV/FCFF hidden
Benchmarks
EV/FCFF, Competitors
Adobe Systems Inc. hidden
Alphabet Inc. hidden
Facebook Inc. hidden
International Business Machines Corp. hidden
Oracle Corp. hidden
salesforce.com inc. hidden
EV/FCFF, Sector
Software & Computer Services hidden
EV/FCFF, Industry
Technology hidden

Based on: 10-K (filing date: 2018-08-03).

If company EV/FCFF is lower then the EV/FCFF of benchmark then company is relatively undervalued.

Otherwise, if 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 LibreOffice Calc
Jun 30, 2018 Jun 30, 2017 Jun 30, 2016 Jun 30, 2015 Jun 30, 2014 Jun 30, 2013
Selected Financial Data (USD $ in millions)
Enterprise value (EV)1 hidden hidden hidden hidden hidden hidden
Free cash flow to the firm (FCFF)2 hidden hidden hidden hidden hidden hidden
Ratio
EV/FCFF3 hidden hidden hidden hidden hidden hidden
Benchmarks
EV/FCFF, Competitors
Adobe Systems Inc. hidden hidden hidden hidden hidden hidden
Alphabet Inc. hidden hidden hidden hidden hidden hidden
Facebook Inc. hidden hidden hidden hidden hidden hidden
International Business Machines Corp. hidden hidden hidden hidden hidden hidden
Oracle Corp. hidden hidden hidden hidden hidden hidden
salesforce.com inc. hidden hidden hidden hidden hidden hidden
EV/FCFF, Sector
Software & Computer Services hidden hidden hidden hidden hidden hidden
EV/FCFF, Industry
Technology hidden hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-08-03), 10-K (filing date: 2017-08-02), 10-K (filing date: 2016-07-28), 10-K (filing date: 2015-07-31), 10-K (filing date: 2014-07-31), 10-K (filing date: 2013-07-30).

2018 Calculations

3 EV/FCFF = EV ÷ FCFF
= hidden ÷ hidden = hidden

Ratio Description The company
EV/FCFF Enterprise value to free cash flow to the firm is whole company valuation indicator. Microsoft Corp.’s EV/FCFF ratio increased from 2016 to 2017 and from 2017 to 2018.