Stock Analysis on Net

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

Microsoft Excel

Long-term Activity Ratios (Summary)

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

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Net fixed asset turnover 4.06 4.18 4.17 4.11 4.00 4.01 3.84 3.41 3.40 3.39 3.42 3.25 3.13 3.31 3.36 3.90 3.94
Total asset turnover 0.61 0.61 0.60 0.61 0.58 0.58 0.56 0.49 0.49 0.49 0.51 0.45 0.43 0.46 0.44 0.52 0.56
Equity turnover 3.88 3.71 3.67 3.68 3.45 3.39 3.14 2.78 2.60 3.39 3.63 3.49 3.78 3.60 3.85 4.65 4.33

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-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 Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ford Motor Co. total asset turnover ratio improved from Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023 not reaching Q2 2023 level.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ford Motor Co. equity turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.

Net Fixed Asset Turnover

Ford Motor Co., net fixed asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Company revenues excluding Ford Credit 43,213 41,176 42,427 39,085 41,745 37,205 37,934 32,195 35,305 33,249 24,149 33,565 33,229 34,727 16,632 31,353 36,686 33,945 35,764 37,245
Net property 40,821 39,370 38,503 37,970 37,265 35,529 36,162 36,625 37,139 36,597 36,723 36,361 37,083 36,118 35,276 35,294 36,469 35,404 36,581 36,145
Long-term Activity Ratio
Net fixed asset turnover1 4.06 4.18 4.17 4.11 4.00 4.01 3.84 3.41 3.40 3.39 3.42 3.25 3.13 3.31 3.36 3.90 3.94
Benchmarks
Net Fixed Asset Turnover, Competitors2
General Motors Co. 3.13 3.20 3.26 3.15 3.18 3.14 2.84 2.81 2.76 2.96 3.24 2.87 2.89 2.75 2.74 3.18 3.17
Tesla Inc. 3.26 3.46 3.56 3.45 3.46 3.41 3.18 3.11 2.85 2.71 2.67 2.59 2.47 2.38 2.34 2.45 2.36

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Net fixed asset turnover = (Company revenues excluding Ford CreditQ4 2023 + Company revenues excluding Ford CreditQ3 2023 + Company revenues excluding Ford CreditQ2 2023 + Company revenues excluding Ford CreditQ1 2023) ÷ Net property
= (43,213 + 41,176 + 42,427 + 39,085) ÷ 40,821 = 4.06

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 Q2 2023 to Q3 2023 but then deteriorated significantly from Q3 2023 to Q4 2023.

Total Asset Turnover

Ford Motor Co., total asset turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Company revenues excluding Ford Credit 43,213 41,176 42,427 39,085 41,745 37,205 37,934 32,195 35,305 33,249 24,149 33,565 33,229 34,727 16,632 31,353 36,686 33,945 35,764 37,245
Total assets 273,310 268,073 265,991 256,800 255,884 246,919 245,755 252,986 257,035 252,677 248,532 260,819 267,261 259,943 269,366 264,150 258,537 258,157 262,184 263,281
Long-term Activity Ratio
Total asset turnover1 0.61 0.61 0.60 0.61 0.58 0.58 0.56 0.49 0.49 0.49 0.51 0.45 0.43 0.46 0.44 0.52 0.56
Benchmarks
Total Asset Turnover, Competitors2
General Motors Co. 0.58 0.56 0.57 0.55 0.55 0.52 0.47 0.47 0.46 0.49 0.52 0.46 0.46 0.42 0.43 0.49 0.54
Tesla Inc. 0.91 1.02 1.04 0.99 0.99 1.01 0.98 0.94 0.87 0.81 0.76 0.68 0.60 0.62 0.67 0.70 0.72

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Total asset turnover = (Company revenues excluding Ford CreditQ4 2023 + Company revenues excluding Ford CreditQ3 2023 + Company revenues excluding Ford CreditQ2 2023 + Company revenues excluding Ford CreditQ1 2023) ÷ Total assets
= (43,213 + 41,176 + 42,427 + 39,085) ÷ 273,310 = 0.61

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 Q2 2023 to Q3 2023 but then slightly deteriorated from Q3 2023 to Q4 2023 not reaching Q2 2023 level.

Equity Turnover

Ford Motor Co., equity turnover calculation (quarterly data)

Microsoft Excel
Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019
Selected Financial Data (US$ in millions)
Company revenues excluding Ford Credit 43,213 41,176 42,427 39,085 41,745 37,205 37,934 32,195 35,305 33,249 24,149 33,565 33,229 34,727 16,632 31,353 36,686 33,945 35,764 37,245
Equity attributable to Ford Motor Company 42,773 44,263 43,677 42,366 43,242 42,125 44,169 44,985 48,519 36,593 34,664 33,828 30,690 33,125 30,824 29,650 33,185 35,349 36,097 36,398
Long-term Activity Ratio
Equity turnover1 3.88 3.71 3.67 3.68 3.45 3.39 3.14 2.78 2.60 3.39 3.63 3.49 3.78 3.60 3.85 4.65 4.33
Benchmarks
Equity Turnover, Competitors2
General Motors Co. 2.45 2.12 2.18 2.12 2.12 2.06 1.86 1.89 1.90 2.17 2.44 2.25 2.41 2.35 2.58 3.01 2.94
Tesla Inc. 1.55 1.79 1.84 1.79 1.82 1.88 1.85 1.82 1.78 1.73 1.69 1.56 1.42 1.76 2.61 2.84 3.71

Based on: 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31).

1 Q4 2023 Calculation
Equity turnover = (Company revenues excluding Ford CreditQ4 2023 + Company revenues excluding Ford CreditQ3 2023 + Company revenues excluding Ford CreditQ2 2023 + Company revenues excluding Ford CreditQ1 2023) ÷ Equity attributable to Ford Motor Company
= (43,213 + 41,176 + 42,427 + 39,085) ÷ 42,773 = 3.88

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 improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023.