Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Ford Motor Co., short-term (operating) activity ratios (quarterly data)
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).
| 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 deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Ford Motor Co. receivables turnover ratio deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Ford Motor Co. payables turnover ratio increased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Ford Motor Co. working capital turnover ratio improved from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| 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. | |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Ford Motor Co. operating cycle deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
| 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. | Ford Motor Co. number of days of payables outstanding decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
| 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. |
Inventory Turnover
Ford Motor Co., inventory turnover calculation (quarterly data)
| 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,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 | 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 | 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.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.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-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
Inventory turnover
= (Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023)
÷ Inventories
= (40,862 + 37,548 + 37,471 + 34,669)
÷ 15,651 = 9.62
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 deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Receivables Turnover
Ford Motor Co., receivables turnover calculation (quarterly data)
| 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) | ||||||
| Trade and other receivables, less allowances | 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.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.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. | 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-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
Receivables 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)
÷ Trade and other receivables, less allowances
= (43,213 + 41,176 + 42,427 + 39,085)
÷ 15,601 = 10.63
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 deteriorated from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Payables Turnover
Ford Motor Co., payables turnover calculation (quarterly data)
| 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,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 | 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.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.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.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-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
Payables turnover
= (Cost of salesQ4 2023
+ Cost of salesQ3 2023
+ Cost of salesQ2 2023
+ Cost of salesQ1 2023)
÷ Payables
= (40,862 + 37,548 + 37,471 + 34,669)
÷ 25,992 = 5.79
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 Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Working Capital Turnover
Ford Motor Co., working capital turnover calculation (quarterly data)
| 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 | 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 | 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 | 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,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 | 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. | 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. | 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-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
Working capital 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)
÷ Working capital
= (43,213 + 41,176 + 42,427 + 39,085)
÷ 19,950 = 8.32
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 Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Average Inventory Processing Period
Ford Motor Co., average inventory processing period calculation (quarterly data)
| 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 | 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 | 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 | 46 | 48 | 50 | 44 | 50 | 58 | 52 | 47 | 51 | 44 | 46 | 38 | 43 | 40 | 36 | 34 | — | — | — | ||||||
| Tesla Inc. | 63 | 65 | 71 | 79 | 77 | 69 | 60 | 54 | 52 | 53 | 53 | 53 | 60 | 69 | 71 | 77 | 63 | — | — | — | ||||||
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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 9.62 = 38
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. |
Average Receivable Collection Period
Ford Motor Co., average receivable collection period calculation (quarterly data)
| 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.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 | 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. | 29 | 32 | 33 | 34 | 34 | 38 | 38 | 37 | 24 | 25 | 24 | 31 | 27 | 36 | 29 | 23 | 20 | — | — | — | ||||||
| Tesla Inc. | 13 | 10 | 13 | 13 | 13 | 11 | 11 | 14 | 13 | 15 | 19 | 19 | 22 | 23 | 21 | 18 | 20 | — | — | — | ||||||
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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 10.63 = 34
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. |
Operating Cycle
Ford Motor Co., operating cycle calculation (quarterly data)
No. days
| 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 | 38 | 45 | 45 | 42 | 38 | 43 | 41 | 47 | 38 | 43 | 43 | 42 | 35 | 34 | 32 | 31 | 29 | — | — | — | ||||||
| Average receivable collection period | 34 | 34 | 33 | 35 | 39 | 38 | 40 | 38 | 33 | 32 | 25 | 32 | 31 | 31 | 28 | 18 | 23 | — | — | — | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Operating cycle1 | 72 | 79 | 78 | 77 | 77 | 81 | 81 | 85 | 71 | 75 | 68 | 74 | 66 | 65 | 60 | 49 | 52 | — | — | — | ||||||
| Benchmarks | ||||||||||||||||||||||||||
| Operating Cycle, Competitors2 | ||||||||||||||||||||||||||
| General Motors Co. | 72 | 78 | 81 | 84 | 78 | 88 | 96 | 89 | 71 | 76 | 68 | 77 | 65 | 79 | 69 | 59 | 54 | — | — | — | ||||||
| Tesla Inc. | 76 | 75 | 84 | 92 | 90 | 80 | 71 | 68 | 65 | 68 | 72 | 72 | 82 | 92 | 92 | 95 | 83 | — | — | — | ||||||
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
Operating cycle = Average inventory processing period + Average receivable collection period
= 38 + 34 = 72
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 deteriorated from Q2 2023 to Q3 2023 but then improved from Q3 2023 to Q4 2023 exceeding Q2 2023 level. |
Average Payables Payment Period
Ford Motor Co., average payables payment period calculation (quarterly data)
| 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.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 | 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 | 80 | 79 | 81 | 79 | 82 | 89 | 88 | 74 | 66 | 71 | 78 | 75 | 82 | 59 | 67 | 69 | — | — | — | ||||||
| Tesla Inc. | 67 | 66 | 76 | 88 | 92 | 92 | 84 | 90 | 91 | 84 | 85 | 86 | 89 | 81 | 64 | 68 | 67 | — | — | — | ||||||
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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 5.79 = 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. | Ford Motor Co. number of days of payables outstanding decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Cash Conversion Cycle
Ford Motor Co., cash conversion cycle calculation (quarterly data)
No. days
| 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 | 38 | 45 | 45 | 42 | 38 | 43 | 41 | 47 | 38 | 43 | 43 | 42 | 35 | 34 | 32 | 31 | 29 | — | — | — | ||||||
| Average receivable collection period | 34 | 34 | 33 | 35 | 39 | 38 | 40 | 38 | 33 | 32 | 25 | 32 | 31 | 31 | 28 | 18 | 23 | — | — | — | ||||||
| Average payables payment period | 63 | 69 | 70 | 68 | 70 | 77 | 68 | 74 | 71 | 73 | 58 | 77 | 72 | 68 | 52 | 51 | 56 | — | — | — | ||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||
| Cash conversion cycle1 | 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. | -1 | -2 | 2 | 3 | -1 | 6 | 7 | 1 | -3 | 10 | -3 | -1 | -10 | -3 | 10 | -8 | -15 | — | — | — | ||||||
| Tesla Inc. | 9 | 9 | 8 | 4 | -2 | -12 | -13 | -22 | -26 | -16 | -13 | -14 | -7 | 11 | 28 | 27 | 16 | — | — | — | ||||||
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
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 38 + 34 – 63 = 9
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. |