Paying users zone. Data is hidden behind hidden.

  • Get 1-month access to Alphabet Inc. for $19.99, or

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

We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Apple Pay Google Pay
Verified by Visa MasterCard SecureCode American Express SafeKey
Unlock

This is a one-time payment. There is no automatic renewal.

Microsoft Excel LibreOffice Calc

Alphabet Inc. (NASDAQ:GOOG)

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Beginner level

Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.

Long-term Activity Ratios (Summary)

Alphabet Inc., long-term (investment) activity ratios (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Net fixed asset turnover
Net fixed asset turnover (including operating lease, right-of-use asset)
Total asset turnover
Equity turnover

Based on: 10-K (filing date: 2020-02-04), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Alphabet Inc.’s net fixed asset turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Alphabet Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Alphabet Inc.’s total asset turnover ratio improved from Q2 2019 to Q3 2019 but then slightly deteriorated from Q3 2019 to Q4 2019.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Alphabet Inc.’s equity turnover ratio improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Net Fixed Asset Turnover

Alphabet Inc., net fixed asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Revenues
Property and equipment, net
Long-term Activity Ratio
Net fixed asset turnover1
Benchmarks
Net Fixed Asset Turnover, Competitors2
Adobe Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.

Based on: 10-K (filing date: 2020-02-04), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29).

1 Q4 2019 Calculation
Net fixed asset turnover = (RevenuesQ4 2019 + RevenuesQ3 2019 + RevenuesQ2 2019 + RevenuesQ1 2019) ÷ Property and equipment, net
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Alphabet Inc.’s net fixed asset turnover ratio deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Alphabet Inc., net fixed asset turnover (including operating lease, right-of-use asset) calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Revenues
 
Property and equipment, net
Operating lease assets
Property and equipment, net (including operating lease, right-of-use asset)
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Adobe Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
salesforce.com inc.
ServiceNow Inc.

Based on: 10-K (filing date: 2020-02-04), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29).

1 Q4 2019 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = (RevenuesQ4 2019 + RevenuesQ3 2019 + RevenuesQ2 2019 + RevenuesQ1 2019) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Alphabet Inc.’s net fixed asset turnover ratio (with operating lease, right-of-use asset) deteriorated from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.

Total Asset Turnover

Alphabet Inc., total asset turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Revenues
Total assets
Long-term Activity Ratio
Total asset turnover1
Benchmarks
Total Asset Turnover, Competitors2
Adobe Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.

Based on: 10-K (filing date: 2020-02-04), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29).

1 Q4 2019 Calculation
Total asset turnover = (RevenuesQ4 2019 + RevenuesQ3 2019 + RevenuesQ2 2019 + RevenuesQ1 2019) ÷ Total assets
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Alphabet Inc.’s total asset turnover ratio improved from Q2 2019 to Q3 2019 but then slightly deteriorated from Q3 2019 to Q4 2019.

Equity Turnover

Alphabet Inc., equity turnover calculation (quarterly data)

Microsoft Excel LibreOffice Calc
Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017 Dec 31, 2016 Sep 30, 2016 Jun 30, 2016 Mar 31, 2016 Dec 31, 2015 Sep 30, 2015 Jun 30, 2015 Mar 31, 2015
Selected Financial Data (US$ in millions)
Revenues
Stockholders’ equity
Long-term Activity Ratio
Equity turnover1
Benchmarks
Equity Turnover, Competitors2
Adobe Inc.
Facebook Inc.
International Business Machines Corp.
Intuit Inc.
Microsoft Corp.
Oracle Corp.
salesforce.com inc.
ServiceNow Inc.

Based on: 10-K (filing date: 2020-02-04), 10-Q (filing date: 2019-10-29), 10-Q (filing date: 2019-07-26), 10-Q (filing date: 2019-04-30), 10-K (filing date: 2019-02-05), 10-Q (filing date: 2018-10-26), 10-Q (filing date: 2018-07-24), 10-Q (filing date: 2018-04-24), 10-K (filing date: 2018-02-06), 10-Q (filing date: 2017-10-27), 10-Q (filing date: 2017-07-25), 10-Q (filing date: 2017-05-02), 10-K (filing date: 2017-02-03), 10-Q (filing date: 2016-11-03), 10-Q (filing date: 2016-08-04), 10-Q (filing date: 2016-05-03), 10-K (filing date: 2016-02-11), 10-Q (filing date: 2015-10-29), 10-Q (filing date: 2015-07-23), 10-Q (filing date: 2015-04-29).

1 Q4 2019 Calculation
Equity turnover = (RevenuesQ4 2019 + RevenuesQ3 2019 + RevenuesQ2 2019 + RevenuesQ1 2019) ÷ Stockholders’ equity
= ( + + + ) ÷ =

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Alphabet Inc.’s equity turnover ratio improved from Q2 2019 to Q3 2019 and from Q3 2019 to Q4 2019.