Microsoft Excel LibreOffice Calc

Ford Motor Co. (F)


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)

Ford Motor Co., long-term (investment) activity ratios

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Net fixed asset turnover 4.10 4.12 4.41 4.66 4.51
Total asset turnover 0.58 0.56 0.59 0.62 0.65
Equity turnover 4.13 4.17 4.85 4.91 5.47

Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13).

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Ford Motor Co.’s net fixed asset turnover deteriorated from 2016 to 2017 and from 2017 to 2018.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ford Motor Co.’s total asset turnover deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ford Motor Co.’s equity turnover deteriorated from 2016 to 2017 and from 2017 to 2018.

Net Fixed Asset Turnover

Ford Motor Co., net fixed asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Automotive revenues 148,294  145,653  141,546  140,566  135,782 
Net property 36,178  35,327  32,072  30,163  30,126 
Ratio
Net fixed asset turnover1 4.10 4.12 4.41 4.66 4.51
Benchmarks
Net Fixed Asset Turnover, Competitors
General Motors Co. 3.43 3.68 4.38 4.67 5.45
Net Fixed Asset Turnover, Sector
Automobiles & Parts 3.75 3.90 4.40 4.67 4.96
Net Fixed Asset Turnover, Industry
Consumer Goods 4.16 4.24 4.52 4.64 4.75

Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13).

2018 Calculations

1 Net fixed asset turnover = Automotive revenues ÷ Net property
= 148,294 ÷ 36,178 = 4.10

Ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Ford Motor Co.’s net fixed asset turnover deteriorated from 2016 to 2017 and from 2017 to 2018.

Total Asset Turnover

Ford Motor Co., total asset turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Automotive revenues 148,294  145,653  141,546  140,566  135,782 
Total assets 256,540  257,808  237,951  224,925  208,527 
Ratio
Total asset turnover1 0.58 0.56 0.59 0.62 0.65
Benchmarks
Total Asset Turnover, Competitors
General Motors Co. 0.59 0.63 0.71 0.75 0.85
Total Asset Turnover, Sector
Automobiles & Parts 0.58 0.59 0.65 0.68 0.74
Total Asset Turnover, Industry
Consumer Goods 0.62 0.62 0.65 0.68 0.78

Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13).

2018 Calculations

1 Total asset turnover = Automotive revenues ÷ Total assets
= 148,294 ÷ 256,540 = 0.58

Ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ford Motor Co.’s total asset turnover deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Equity Turnover

Ford Motor Co., equity turnover calculation, comparison to benchmarks

Microsoft Excel LibreOffice Calc
Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014
Selected Financial Data (USD $ in millions)
Automotive revenues 148,294  145,653  141,546  140,566  135,782 
Equity attributable to Ford Motor Company 35,932  34,890  29,170  28,642  24,805 
Ratio
Equity turnover1 4.13 4.17 4.85 4.91 5.47
Benchmarks
Equity Turnover, Competitors
General Motors Co. 3.42 3.81 3.58 3.66 4.26
Equity Turnover, Sector
Automobiles & Parts 3.76 3.99 4.09 4.18 4.76
Equity Turnover, Industry
Consumer Goods 2.71 2.57 2.67 2.68 3.28

Based on: 10-K (filing date: 2019-02-21), 10-K (filing date: 2018-02-08), 10-K (filing date: 2017-02-09), 10-K (filing date: 2016-02-11), 10-K (filing date: 2015-02-13).

2018 Calculations

1 Equity turnover = Automotive revenues ÷ Equity attributable to Ford Motor Company
= 148,294 ÷ 35,932 = 4.13

Ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ford Motor Co.’s equity turnover deteriorated from 2016 to 2017 and from 2017 to 2018.