Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Long-term (Investment) Activity Ratios 

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Net fixed asset turnover 4.00 3.40 3.13 3.94 4.10
Net fixed asset turnover (including operating lease, right-of-use asset) 3.85 3.28 3.02 3.79 4.10
Total asset turnover 0.58 0.49 0.43 0.56 0.58
Equity turnover 3.45 2.60 3.78 4.33 4.13

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Ford Motor Co. net fixed asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
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). Ford Motor Co. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2020 to 2021 and from 2021 to 2022.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ford Motor Co. total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ford Motor Co. equity turnover ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 not reaching 2020 level.

Net Fixed Asset Turnover

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

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Automotive revenues 148,980 126,150 115,885 143,599 148,294
Net property 37,265 37,139 37,083 36,469 36,178
Long-term Activity Ratio
Net fixed asset turnover1 4.00 3.40 3.13 3.94 4.10
Benchmarks
Net Fixed Asset Turnover, Competitors2
General Motors Co. 3.18 2.76 2.89 3.17 3.43
Tesla Inc. 3.46 2.85 2.47 2.36 1.89
Net Fixed Asset Turnover, Sector
Automobiles & Components 3.53 3.02 2.93 3.40 3.51
Net Fixed Asset Turnover, Industry
Consumer Discretionary 3.17 3.00 2.95 3.23 3.19

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Net fixed asset turnover = Automotive revenues ÷ Net property
= 148,980 ÷ 37,265 = 4.00

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. Ford Motor Co. net fixed asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

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

Ford Motor Co., net fixed asset turnover (including operating lease, right-of-use asset) calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Automotive revenues 148,980 126,150 115,885 143,599 148,294
 
Net property 37,265 37,139 37,083 36,469 36,178
Operating lease right-of-use assets (included in Other assets) 1,447 1,337 1,287 1,415
Net property (including operating lease, right-of-use asset) 38,712 38,476 38,370 37,884 36,178
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 3.85 3.28 3.02 3.79 4.10
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
General Motors Co. 3.11 2.69 2.81 3.08 3.43
Tesla Inc. 3.12 2.58 2.20 2.12 1.89
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Sector
Automobiles & Components 3.37 2.89 2.80 3.26 3.51
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Industry
Consumer Discretionary 2.50 2.37 2.35 2.81 3.19

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Net fixed asset turnover (including operating lease, right-of-use asset) = Automotive revenues ÷ Net property (including operating lease, right-of-use asset)
= 148,980 ÷ 38,712 = 3.85

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). Ford Motor Co. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from 2020 to 2021 and from 2021 to 2022.

Total Asset Turnover

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

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Automotive revenues 148,980 126,150 115,885 143,599 148,294
Total assets 255,884 257,035 267,261 258,537 256,540
Long-term Activity Ratio
Total asset turnover1 0.58 0.49 0.43 0.56 0.58
Benchmarks
Total Asset Turnover, Competitors2
General Motors Co. 0.55 0.46 0.46 0.54 0.59
Tesla Inc. 0.99 0.87 0.60 0.72 0.72
Total Asset Turnover, Sector
Automobiles & Components 0.62 0.52 0.46 0.56 0.59
Total Asset Turnover, Industry
Consumer Discretionary 0.96 0.89 0.84 0.94 0.96

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Total asset turnover = Automotive revenues ÷ Total assets
= 148,980 ÷ 255,884 = 0.58

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. Ford Motor Co. total asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Equity Turnover

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

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Automotive revenues 148,980 126,150 115,885 143,599 148,294
Equity attributable to Ford Motor Company 43,242 48,519 30,690 33,185 35,932
Long-term Activity Ratio
Equity turnover1 3.45 2.60 3.78 4.33 4.13
Benchmarks
Equity Turnover, Competitors2
General Motors Co. 2.12 1.90 2.41 2.94 3.42
Tesla Inc. 1.82 1.78 1.42 3.71 4.36
Equity Turnover, Sector
Automobiles & Components 2.40 2.12 2.61 3.56 3.80
Equity Turnover, Industry
Consumer Discretionary 4.33 3.77 4.51 5.15 4.92

Based on: 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

1 2022 Calculation
Equity turnover = Automotive revenues ÷ Equity attributable to Ford Motor Company
= 148,980 ÷ 43,242 = 3.45

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. Ford Motor Co. equity turnover ratio deteriorated from 2020 to 2021 but then improved from 2021 to 2022 not reaching 2020 level.