Stock Analysis on Net

Analysis of Short-term (Operating) Activity Ratios 
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Ford Motor Co., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Turnover Ratios
Inventory turnover 8.77 9.04 8.18 9.62 8.05 8.15 8.64 9.55 8.48 8.92 7.81 9.50 8.54 8.57 8.75 10.43 10.82 11.31 11.60 12.49
Receivables turnover 10.38 10.06 8.92 10.63 10.87 11.08 10.45 9.48 9.66 9.22 9.58 11.11 11.45 14.36 11.31 11.60 11.81 13.02 20.79 15.55
Payables turnover 5.76 6.10 5.56 5.79 5.30 5.20 5.38 5.25 4.77 5.33 4.92 5.13 5.03 6.27 4.75 5.08 5.33 7.06 7.12 6.52
Working capital turnover 10.64 9.88 9.59 8.32 7.80 7.75 8.12 7.60 7.96 9.89 7.91 6.91 6.92 7.06 6.00 5.93 6.42 3.79 4.63 9.03
Average No. Days
Average inventory processing period 42 40 45 38 45 45 42 38 43 41 47 38 43 43 42 35 34 32 31 29
Add: Average receivable collection period 35 36 41 34 34 33 35 39 38 40 38 33 32 25 32 31 31 28 18 23
Operating cycle 77 76 86 72 79 78 77 77 81 81 85 71 75 68 74 66 65 60 49 52
Less: Average payables payment period 63 60 66 63 69 70 68 70 77 68 74 71 73 58 77 72 68 52 51 56
Cash conversion cycle 14 16 20 9 10 8 9 7 4 13 11 0 2 10 -3 -6 -3 8 -2 -4

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Ford Motor Co. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Ford Motor Co. receivables turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Ford Motor Co. payables turnover ratio increased from Q1 2024 to Q2 2024 but then slightly decreased from Q2 2024 to Q3 2024 not reaching Q1 2024 level.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Ford Motor Co. working capital turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Ford Motor Co. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Ford Motor Co. number of days of receivables outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Ford Motor Co. operating cycle improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Ford Motor Co. cash conversion cycle improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Inventory Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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)
Cost of sales 40,168 40,489 36,476 40,862 37,548 37,471 34,669 37,816 34,354 33,191 29,036 32,393 30,057 22,904 29,297 33,075 31,223 17,932 30,522 34,812 32,282 33,657 33,942
Inventories 18,025 17,183 18,632 15,651 18,326 17,703 16,212 14,080 15,213 13,976 14,647 12,065 13,508 13,593 12,742 10,808 10,583 10,220 11,312 10,786 12,451 12,437 12,333
Short-term Activity Ratio
Inventory turnover1 8.77 9.04 8.18 9.62 8.05 8.15 8.64 9.55 8.48 8.92 7.81 9.50 8.54 8.57 8.75 10.43 10.82 11.31 11.60 12.49
Benchmarks
Inventory Turnover, Competitors2
General Motors Co. 8.56 8.24 8.16 8.59 7.85 7.66 7.31 8.26 7.32 6.33 7.06 7.74 7.10 8.38 7.95 9.53 8.53 9.17 10.11 10.64
Tesla Inc. 5.47 5.53 4.86 5.81 5.61 5.14 4.60 4.72 5.32 6.04 6.78 6.99 6.93 6.89 6.86 6.07 5.27 5.13 4.74 5.77

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Inventory turnover = (Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024 + Cost of salesQ4 2023) ÷ Inventories
= (40,168 + 40,489 + 36,476 + 40,862) ÷ 18,025 = 8.77

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Ford Motor Co. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.

Receivables Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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,069 44,811 39,890 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
Trade and other receivables, less allowances 16,469 16,802 18,698 15,601 15,129 14,482 14,920 15,729 14,764 15,037 13,031 11,370 10,851 8,750 10,448 9,993 10,114 9,107 6,625 9,237 10,621 10,941 12,016
Short-term Activity Ratio
Receivables turnover1 10.38 10.06 8.92 10.63 10.87 11.08 10.45 9.48 9.66 9.22 9.58 11.11 11.45 14.36 11.31 11.60 11.81 13.02 20.79 15.55
Benchmarks
Receivables Turnover, Competitors2
General Motors Co. 12.14 12.16 11.63 12.74 11.36 11.12 10.79 10.80 9.59 9.60 9.82 15.36 14.50 15.42 11.90 13.52 10.24 12.78 16.00 18.05
Tesla Inc. 29.32 25.51 24.37 27.59 38.07 27.28 28.75 27.60 34.15 32.28 26.91 28.14 23.88 19.66 19.02 16.72 16.04 17.31 20.43 18.56

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Receivables turnover = (Company revenues excluding Ford CreditQ3 2024 + Company revenues excluding Ford CreditQ2 2024 + Company revenues excluding Ford CreditQ1 2024 + Company revenues excluding Ford CreditQ4 2023) ÷ Trade and other receivables, less allowances
= (43,069 + 44,811 + 39,890 + 43,213) ÷ 16,469 = 10.38

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Ford Motor Co. receivables turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Payables Turnover

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

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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)
Cost of sales 40,168 40,489 36,476 40,862 37,548 37,471 34,669 37,816 34,354 33,191 29,036 32,393 30,057 22,904 29,297 33,075 31,223 17,932 30,522 34,812 32,282 33,657 33,942
Payables 27,424 25,458 27,384 25,992 27,813 27,749 26,028 25,605 27,051 23,378 23,256 22,349 22,923 18,593 23,492 22,204 21,466 16,360 18,439 20,673 22,228 22,980 23,325
Short-term Activity Ratio
Payables turnover1 5.76 6.10 5.56 5.79 5.30 5.20 5.38 5.25 4.77 5.33 4.92 5.13 5.03 6.27 4.75 5.08 5.33 7.06 7.12 6.52
Benchmarks
Payables Turnover, Competitors2
General Motors Co. 5.00 5.04 4.87 5.03 4.58 4.60 4.49 4.62 4.46 4.12 4.15 4.93 5.54 5.12 4.69 4.89 4.46 6.22 5.45 5.26
Tesla Inc. 5.42 6.01 5.29 5.48 5.52 4.83 4.16 3.97 3.95 4.37 4.06 4.01 4.36 4.32 4.26 4.12 4.48 5.67 5.36 5.44

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Payables turnover = (Cost of salesQ3 2024 + Cost of salesQ2 2024 + Cost of salesQ1 2024 + Cost of salesQ4 2023) ÷ Payables
= (40,168 + 40,489 + 36,476 + 40,862) ÷ 27,424 = 5.76

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Ford Motor Co. payables turnover ratio increased from Q1 2024 to Q2 2024 but then slightly decreased from Q2 2024 to Q3 2024 not reaching Q1 2024 level.

Working Capital Turnover

Ford Motor Co., working capital turnover calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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)
Current assets 125,099 120,518 120,595 121,481 121,361 121,712 115,123 116,476 108,088 100,469 106,142 108,996 106,968 101,275 113,932 116,744 111,765 124,111 124,276 114,047 115,754 118,351 121,195
Less: Current liabilities 109,036 103,403 103,206 101,531 100,268 101,015 95,905 96,866 90,167 86,452 90,352 90,727 89,033 83,474 94,249 97,192 93,159 92,780 94,494 98,132 99,087 98,334 99,237
Working capital 16,063 17,115 17,389 19,950 21,093 20,697 19,218 19,610 17,921 14,017 15,790 18,269 17,935 17,801 19,683 19,552 18,606 31,331 29,782 15,915 16,667 20,017 21,958
 
Company revenues excluding Ford Credit 43,069 44,811 39,890 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
Short-term Activity Ratio
Working capital turnover1 10.64 9.88 9.59 8.32 7.80 7.75 8.12 7.60 7.96 9.89 7.91 6.91 6.92 7.06 6.00 5.93 6.42 3.79 4.63 9.03
Benchmarks
Working Capital Turnover, Competitors2
General Motors Co. 8.38 9.76 10.90 21.98 11.38 11.11 17.09 15.52 10.96 10.19 12.98 14.76 20.09 16.15 18.83 107.17 11.87 10.58 18.82
Tesla Inc. 3.77 3.78 4.49 4.64 5.22 5.77 5.53 5.73 6.58 7.14 8.19 7.28 6.74 5.03 3.66 2.53 3.34 8.38 8.95 17.12

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Working capital turnover = (Company revenues excluding Ford CreditQ3 2024 + Company revenues excluding Ford CreditQ2 2024 + Company revenues excluding Ford CreditQ1 2024 + Company revenues excluding Ford CreditQ4 2023) ÷ Working capital
= (43,069 + 44,811 + 39,890 + 43,213) ÷ 16,063 = 10.64

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Ford Motor Co. working capital turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Inventory Processing Period

Ford Motor Co., average inventory processing period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Inventory turnover 8.77 9.04 8.18 9.62 8.05 8.15 8.64 9.55 8.48 8.92 7.81 9.50 8.54 8.57 8.75 10.43 10.82 11.31 11.60 12.49
Short-term Activity Ratio (no. days)
Average inventory processing period1 42 40 45 38 45 45 42 38 43 41 47 38 43 43 42 35 34 32 31 29
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
General Motors Co. 43 44 45 43 46 48 50 44 50 58 52 47 51 44 46 38 43 40 36 34
Tesla Inc. 67 66 75 63 65 71 79 77 69 60 54 52 53 53 53 60 69 71 77 63

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 8.77 = 42

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Ford Motor Co. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.

Average Receivable Collection Period

Ford Motor Co., average receivable collection period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Receivables turnover 10.38 10.06 8.92 10.63 10.87 11.08 10.45 9.48 9.66 9.22 9.58 11.11 11.45 14.36 11.31 11.60 11.81 13.02 20.79 15.55
Short-term Activity Ratio (no. days)
Average receivable collection period1 35 36 41 34 34 33 35 39 38 40 38 33 32 25 32 31 31 28 18 23
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
General Motors Co. 30 30 31 29 32 33 34 34 38 38 37 24 25 24 31 27 36 29 23 20
Tesla Inc. 12 14 15 13 10 13 13 13 11 11 14 13 15 19 19 22 23 21 18 20

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 10.38 = 35

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Ford Motor Co. number of days of receivables outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Operating Cycle

Ford Motor Co., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Average inventory processing period 42 40 45 38 45 45 42 38 43 41 47 38 43 43 42 35 34 32 31 29
Average receivable collection period 35 36 41 34 34 33 35 39 38 40 38 33 32 25 32 31 31 28 18 23
Short-term Activity Ratio
Operating cycle1 77 76 86 72 79 78 77 77 81 81 85 71 75 68 74 66 65 60 49 52
Benchmarks
Operating Cycle, Competitors2
General Motors Co. 73 74 76 72 78 81 84 78 88 96 89 71 76 68 77 65 79 69 59 54
Tesla Inc. 79 80 90 76 75 84 92 90 80 71 68 65 68 72 72 82 92 92 95 83

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 42 + 35 = 77

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Ford Motor Co. operating cycle improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.

Average Payables Payment Period

Ford Motor Co., average payables payment period calculation (quarterly data)

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Payables turnover 5.76 6.10 5.56 5.79 5.30 5.20 5.38 5.25 4.77 5.33 4.92 5.13 5.03 6.27 4.75 5.08 5.33 7.06 7.12 6.52
Short-term Activity Ratio (no. days)
Average payables payment period1 63 60 66 63 69 70 68 70 77 68 74 71 73 58 77 72 68 52 51 56
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
General Motors Co. 73 72 75 73 80 79 81 79 82 89 88 74 66 71 78 75 82 59 67 69
Tesla Inc. 67 61 69 67 66 76 88 92 92 84 90 91 84 85 86 89 81 64 68 67

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.76 = 63

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period.

Cash Conversion Cycle

Ford Motor Co., cash conversion cycle calculation (quarterly data)

No. days

Microsoft Excel
Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 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
Average inventory processing period 42 40 45 38 45 45 42 38 43 41 47 38 43 43 42 35 34 32 31 29
Average receivable collection period 35 36 41 34 34 33 35 39 38 40 38 33 32 25 32 31 31 28 18 23
Average payables payment period 63 60 66 63 69 70 68 70 77 68 74 71 73 58 77 72 68 52 51 56
Short-term Activity Ratio
Cash conversion cycle1 14 16 20 9 10 8 9 7 4 13 11 0 2 10 -3 -6 -3 8 -2 -4
Benchmarks
Cash Conversion Cycle, Competitors2
General Motors Co. 0 2 1 -1 -2 2 3 -1 6 7 1 -3 10 -3 -1 -10 -3 10 -8 -15
Tesla Inc. 12 19 21 9 9 8 4 -2 -12 -13 -22 -26 -16 -13 -14 -7 11 28 27 16

Based on: 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 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 Q3 2024 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 42 + 3563 = 14

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Ford Motor Co. cash conversion cycle improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.