Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Geographic Areas 

Microsoft Excel

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


Area Asset Turnover

Ford Motor Co., asset turnover by geographic area

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
United States 2.52 1.97 1.82 2.13 2.17
Canada 2.19 1.93 1.70 2.24 2.29
United Kingdom 6.50 5.50 4.36 5.77 5.88
Germany 2.61 2.30 2.04 2.46 2.20
Mexico 0.43 0.37 0.28 0.50 0.81
All Other 5.37 4.19 3.53 4.15 3.99

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).

Area activity ratio Geographic area The company
Area asset turnover United States United States area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Canada Canada area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
United Kingdom United Kingdom area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Germany Germany area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
Mexico Mexico area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.
All Other All Other area asset turnover ratio improved from 2020 to 2021 and from 2021 to 2022.

Area Asset Turnover: United States

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

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

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
Area asset turnover = Revenues ÷ Long-lived assets
= 105,481 ÷ 41,925 = 2.52

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

Area Asset Turnover: Canada

Ford Motor Co.; Canada; area asset turnover calculation

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

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
Area asset turnover = Revenues ÷ Long-lived assets
= 12,590 ÷ 5,739 = 2.19

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

Area Asset Turnover: United Kingdom

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

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

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
Area asset turnover = Revenues ÷ Long-lived assets
= 8,220 ÷ 1,264 = 6.50

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

Area Asset Turnover: Germany

Ford Motor Co.; Germany; area asset turnover calculation

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Revenues 6,471 6,237 6,526 7,930 7,894
Long-lived assets 2,483 2,708 3,197 3,225 3,593
Area Activity Ratio
Area asset turnover1 2.61 2.30 2.04 2.46 2.20

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
Area asset turnover = Revenues ÷ Long-lived assets
= 6,471 ÷ 2,483 = 2.61

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

Area Asset Turnover: Mexico

Ford Motor Co.; Mexico; area asset turnover calculation

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

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
Area asset turnover = Revenues ÷ Long-lived assets
= 1,813 ÷ 4,255 = 0.43

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

Area Asset Turnover: All Other

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

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Selected Financial Data (US$ in millions)
Revenues 23,482 22,892 22,232 28,036 32,801
Long-lived assets 4,371 5,462 6,296 6,748 8,225
Area Activity Ratio
Area asset turnover1 5.37 4.19 3.53 4.15 3.99

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
Area asset turnover = Revenues ÷ Long-lived assets
= 23,482 ÷ 4,371 = 5.37

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

Revenues

Ford Motor Co., revenues by geographic area

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
United States 105,481 87,012 82,535 98,729 97,546
Canada 12,590 11,153 8,711 10,855 10,541
United Kingdom 8,220 7,607 6,110 8,899 9,703
Germany 6,471 6,237 6,526 7,930 7,894
Mexico 1,813 1,440 1,030 1,451 1,853
All Other 23,482 22,892 22,232 28,036 32,801
Total Company 158,057 136,341 127,144 155,900 160,338

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-lived assets

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

US$ in millions

Microsoft Excel
Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
United States 41,925 44,271 45,360 46,434 44,940
Canada 5,739 5,773 5,111 4,842 4,604
United Kingdom 1,264 1,383 1,401 1,541 1,650
Germany 2,483 2,708 3,197 3,225 3,593
Mexico 4,255 3,903 3,669 2,909 2,285
All Other 4,371 5,462 6,296 6,748 8,225
Total Company 60,037 63,500 65,034 65,699 65,297

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).