Microsoft Excel LibreOffice Calc

Long-term (Investment) Activity Analysis

Difficulty: Beginner


Ratios (Summary)

Facebook Inc., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net fixed asset turnover 2.96 3.22 3.15 3.14 2.73
Total asset turnover 0.48 0.43 0.36 0.31 0.44
Equity turnover 0.55 0.47 0.41 0.35 0.51

Source: Based on data from Facebook Inc. Annual Reports

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Facebook Inc.'s net fixed asset turnover improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Facebook 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. Facebook Inc.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017.

Net Fixed Asset Turnover

Facebook Inc., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Revenue 40,653  27,638  17,928  12,466  7,872 
Property and equipment, net 13,721  8,591  5,687  3,967  2,882 
Ratio
Net fixed asset turnover1 2.96 3.22 3.15 3.14 2.73
Benchmarks
Net Fixed Asset Turnover, Competitors
Adobe Systems Inc. 7.79 7.17 6.09 5.28 6.15
Alphabet Inc. 2.62 2.64 2.58 2.76 3.62
International Business Machines Corp. 7.12 7.38 7.62 8.62 7.22
Microsoft Corp. 3.79 4.65 6.35 6.67 7.79
Oracle Corp. 7.10 9.26 10.37 12.50 12.18
salesforce.com inc. 4.69 3.89 4.77 3.28 5.04
Net Fixed Asset Turnover, Sector
Software & Computer Services 3.78 4.24 4.81 5.37 6.09
Net Fixed Asset Turnover, Industry
Technology 4.45 4.95 5.74 5.70 6.11

Source: Based on data from Facebook Inc. Annual Reports

2017 Calculations

1 Net fixed asset turnover = Revenue ÷ Property and equipment, net
= 40,653 ÷ 13,721 = 2.96

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Facebook Inc.'s net fixed asset turnover improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

Total Asset Turnover

Facebook Inc., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Revenue 40,653  27,638  17,928  12,466  7,872 
Total assets 84,524  64,961  49,407  40,184  17,895 
Ratio
Total asset turnover1 0.48 0.43 0.36 0.31 0.44
Benchmarks
Total Asset Turnover, Competitors
Adobe Systems Inc. 0.50 0.46 0.41 0.38 0.39
Alphabet Inc. 0.56 0.54 0.51 0.50 0.54
International Business Machines Corp. 0.63 0.68 0.74 0.79 0.79
Microsoft Corp. 0.37 0.44 0.53 0.50 0.55
Oracle Corp. 0.28 0.33 0.34 0.42 0.45
salesforce.com inc. 0.48 0.52 0.50 0.44 0.55
Total Asset Turnover, Sector
Software & Computer Services 0.46 0.49 0.51 0.53 0.58
Total Asset Turnover, Industry
Technology 0.51 0.55 0.61 0.63 0.67

Source: Based on data from Facebook Inc. Annual Reports

2017 Calculations

1 Total asset turnover = Revenue ÷ Total assets
= 40,653 ÷ 84,524 = 0.48

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Facebook Inc.'s total asset turnover improved from 2015 to 2016 and from 2016 to 2017.

Equity Turnover

Facebook Inc., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Selected Financial Data (USD $ in millions)
Revenue 40,653  27,638  17,928  12,466  7,872 
Stockholders' equity 74,347  59,194  44,218  36,096  15,470 
Ratio
Equity turnover1 0.55 0.47 0.41 0.35 0.51
Benchmarks
Equity Turnover, Competitors
Adobe Systems Inc. 0.86 0.79 0.68 0.61 0.60
Alphabet Inc. 0.73 0.65 0.62 0.63 0.69
International Business Machines Corp. 4.50 4.38 5.73 7.82 4.38
Microsoft Corp. 1.24 1.19 1.17 0.97 0.99
Oracle Corp. 0.70 0.78 0.79 0.82 0.83
salesforce.com inc. 1.12 1.33 1.35 1.34 1.32
Equity Turnover, Sector
Software & Computer Services 0.97 0.96 0.99 1.02 1.12
Equity Turnover, Industry
Technology 1.16 1.14 1.27 1.23 1.23

Source: Based on data from Facebook Inc. Annual Reports

2017 Calculations

1 Equity turnover = Revenue ÷ Stockholders' equity
= 40,653 ÷ 74,347 = 0.55

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders' equity. Facebook Inc.'s equity turnover improved from 2015 to 2016 and from 2016 to 2017.