Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Geographic Areas

Microsoft Excel

Ford Motor Co. operates in 5 regions: United States; Canada; United Kingdom; Mexico; and All Other.


Area Asset Turnover

Ford Motor Co., asset turnover by geographic area

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 2.77 2.52 1.97 1.82 2.13
Canada 2.18 2.19 1.93 1.70 2.24
United Kingdom 4.80 6.50 5.50 4.36 5.77
Mexico 0.53 0.43 0.37 0.28 0.50
All Other 5.06 4.37 3.57 3.03 3.61

Based on: 10-K (reporting date: 2023-12-31), 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).

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Canada Canada area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.
United Kingdom United Kingdom area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Mexico Mexico area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
All Other All Other area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: United States

Ford Motor Co.; United States; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Revenues 116,995 105,481 87,012 82,535 98,729
Long-lived assets 42,235 41,925 44,271 45,360 46,434
Area Activity Ratio
Area asset turnover1 2.77 2.52 1.97 1.82 2.13

Based on: 10-K (reporting date: 2023-12-31), 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).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 116,995 ÷ 42,235 = 2.77

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: Canada

Ford Motor Co.; Canada; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Revenues 13,391 12,590 11,153 8,711 10,855
Long-lived assets 6,147 5,739 5,773 5,111 4,842
Area Activity Ratio
Area asset turnover1 2.18 2.19 1.93 1.70 2.24

Based on: 10-K (reporting date: 2023-12-31), 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).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 13,391 ÷ 6,147 = 2.18

Area activity ratio Geographic area The company
Area asset turnover Canada Canada area asset turnover ratio improved from 2021 to 2022 but then slightly deteriorated from 2022 to 2023.

Area Asset Turnover: United Kingdom

Ford Motor Co.; United Kingdom; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Revenues 8,968 8,220 7,607 6,110 8,899
Long-lived assets 1,868 1,264 1,383 1,401 1,541
Area Activity Ratio
Area asset turnover1 4.80 6.50 5.50 4.36 5.77

Based on: 10-K (reporting date: 2023-12-31), 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).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 8,968 ÷ 1,868 = 4.80

Area activity ratio Geographic area The company
Area asset turnover United Kingdom United Kingdom area asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Area Asset Turnover: Mexico

Ford Motor Co.; Mexico; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Revenues 2,774 1,813 1,440 1,030 1,451
Long-lived assets 5,222 4,255 3,903 3,669 2,909
Area Activity Ratio
Area asset turnover1 0.53 0.43 0.37 0.28 0.50

Based on: 10-K (reporting date: 2023-12-31), 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).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 2,774 ÷ 5,222 = 0.53

Area activity ratio Geographic area The company
Area asset turnover Mexico Mexico area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Area Asset Turnover: All Other

Ford Motor Co.; All Other; area asset turnover calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Revenues 34,063 29,953 29,129 28,758 35,966
Long-lived assets 6,733 6,854 8,170 9,493 9,973
Area Activity Ratio
Area asset turnover1 5.06 4.37 3.57 3.03 3.61

Based on: 10-K (reporting date: 2023-12-31), 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).

1 2023 Calculation
Area asset turnover = Revenues ÷ Long-lived assets
= 34,063 ÷ 6,733 = 5.06

Area activity ratio Geographic area The company
Area asset turnover All Other All Other area asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Revenues

Ford Motor Co., revenues by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 116,995 105,481 87,012 82,535 98,729
Canada 13,391 12,590 11,153 8,711 10,855
United Kingdom 8,968 8,220 7,607 6,110 8,899
Mexico 2,774 1,813 1,440 1,030 1,451
All Other 34,063 29,953 29,129 28,758 35,966
Total Company 176,191 158,057 136,341 127,144 155,900

Based on: 10-K (reporting date: 2023-12-31), 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).


Long-lived assets

Ford Motor Co., long-lived assets by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
United States 42,235 41,925 44,271 45,360 46,434
Canada 6,147 5,739 5,773 5,111 4,842
United Kingdom 1,868 1,264 1,383 1,401 1,541
Mexico 5,222 4,255 3,903 3,669 2,909
All Other 6,733 6,854 8,170 9,493 9,973
Total Company 62,205 60,037 63,500 65,034 65,699

Based on: 10-K (reporting date: 2023-12-31), 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).