.Long-term (Investment) Activity Analysis
Difficulty: Beginner
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Ratios (Summary)
Alphabet Inc., long-term (investment) activity ratios
| Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | ||
|---|---|---|---|---|---|---|
| | Net fixed asset turnover | |||||
| | Total asset turnover | |||||
| | Equity turnover |
Source: Based on data from Alphabet Inc. Annual Reports
| 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 improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017. |
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Alphabet Inc.'s total asset turnover improved from 2015 to 2016 and from 2016 to 2017. |
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders' equity. | Alphabet Inc.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017. |
Net Fixed Asset Turnover
Alphabet Inc., net fixed asset turnover calculation, comparison to benchmarks
| Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (USD $ in millions) | ||||||
| | Revenues | |||||
| | Property and equipment, net | |||||
| Ratio | ||||||
| | Net fixed asset turnover1 | |||||
| Benchmarks | ||||||
| Net Fixed Asset Turnover, Competitors | ||||||
| Adobe Systems Inc. | ||||||
| Facebook Inc. | ||||||
| International Business Machines Corp. | ||||||
| Microsoft Corp. | ||||||
| Oracle Corp. | ||||||
| salesforce.com inc. | ||||||
| Net Fixed Asset Turnover, Sector | ||||||
| Software & Computer Services | ||||||
| Net Fixed Asset Turnover, Industry | ||||||
| Technology | ||||||
Source: Based on data from Alphabet Inc. Annual Reports
2017 Calculations
1 Net fixed asset turnover = Revenues ÷ Property and equipment, net
= ÷ =
| 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 improved from 2015 to 2016 but then slightly deteriorated from 2016 to 2017. |
Total Asset Turnover
Alphabet Inc., total asset turnover calculation, comparison to benchmarks
| Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (USD $ in millions) | ||||||
| | Revenues | |||||
| | Total assets | |||||
| Ratio | ||||||
| | Total asset turnover1 | |||||
| Benchmarks | ||||||
| Total Asset Turnover, Competitors | ||||||
| Adobe Systems Inc. | ||||||
| Facebook Inc. | ||||||
| International Business Machines Corp. | ||||||
| Microsoft Corp. | ||||||
| Oracle Corp. | ||||||
| salesforce.com inc. | ||||||
| Total Asset Turnover, Sector | ||||||
| Software & Computer Services | ||||||
| Total Asset Turnover, Industry | ||||||
| Technology | ||||||
Source: Based on data from Alphabet Inc. Annual Reports
2017 Calculations
1 Total asset turnover = Revenues ÷ Total assets
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Total asset turnover | An activity ratio calculated as total revenue divided by total assets. | Alphabet Inc.'s total asset turnover improved from 2015 to 2016 and from 2016 to 2017. |
Equity Turnover
Alphabet Inc., equity turnover calculation, comparison to benchmarks
| Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | ||
|---|---|---|---|---|---|---|
| Selected Financial Data (USD $ in millions) | ||||||
| | Revenues | |||||
| | Stockholders' equity | |||||
| Ratio | ||||||
| | Equity turnover1 | |||||
| Benchmarks | ||||||
| Equity Turnover, Competitors | ||||||
| Adobe Systems Inc. | ||||||
| Facebook Inc. | ||||||
| International Business Machines Corp. | ||||||
| Microsoft Corp. | ||||||
| Oracle Corp. | ||||||
| salesforce.com inc. | ||||||
| Equity Turnover, Sector | ||||||
| Software & Computer Services | ||||||
| Equity Turnover, Industry | ||||||
| Technology | ||||||
Source: Based on data from Alphabet Inc. Annual Reports
2017 Calculations
1 Equity turnover = Revenues ÷ Stockholders' equity
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Equity turnover | An activity ratio calculated as total revenue divided by shareholders' equity. | Alphabet Inc.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017. |
