Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Ford Motor Co., profit margin by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 5.31% 5.24% 2.98%
Ford Model e -72.03% -39.69% -28.00%
Ford Pro 12.44% 6.58% 6.25%
Ford Next -4,600.00% -935.35% -872.88% -2,275.00% -2,892.68%
Ford Credit 12.93% 29.59% 46.83% 23.28% 24.45%

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

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Blue Ford Blue segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.
Ford Model e Ford Model e segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Pro Ford Pro segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.
Ford Next Ford Next segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Credit Ford Credit segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Ford Blue

Ford Motor Co.; Ford Blue; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 7,462 6,847 3,293
Revenues 140,627 130,782 110,466
Segment Profitability Ratio
Segment profit margin1 5.31% 5.24% 2.98%

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
Segment profit margin = 100 × Income (loss) before income taxes ÷ Revenues
= 100 × 7,462 ÷ 140,627 = 5.31%

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Blue Ford Blue segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Ford Model e

Ford Motor Co.; Ford Model e; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes (4,701) (2,133) (892)
Revenues 6,526 5,374 3,186
Segment Profitability Ratio
Segment profit margin1 -72.03% -39.69% -28.00%

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
Segment profit margin = 100 × Income (loss) before income taxes ÷ Revenues
= 100 × -4,701 ÷ 6,526 = -72.03%

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Model e Ford Model e segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Ford Pro

Ford Motor Co.; Ford Pro; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 7,222 3,222 2,665
Revenues 58,058 48,939 42,649
Segment Profitability Ratio
Segment profit margin1 12.44% 6.58% 6.25%

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
Segment profit margin = 100 × Income (loss) before income taxes ÷ Revenues
= 100 × 7,222 ÷ 58,058 = 12.44%

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Pro Ford Pro segment profit margin ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Ford Next

Ford Motor Co.; Ford Next; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes (138) (926) (1,030) (1,274) (1,186)
Revenues 3 99 118 56 41
Segment Profitability Ratio
Segment profit margin1 -4,600.00% -935.35% -872.88% -2,275.00% -2,892.68%

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
Segment profit margin = 100 × Income (loss) before income taxes ÷ Revenues
= 100 × -138 ÷ 3 = -4,600.00%

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Next Ford Next segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Profit Margin: Ford Credit

Ford Motor Co.; Ford Credit; segment profit margin calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 1,331 2,657 4,717 2,608 2,998
Revenues 10,290 8,978 10,073 11,203 12,260
Segment Profitability Ratio
Segment profit margin1 12.93% 29.59% 46.83% 23.28% 24.45%

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
Segment profit margin = 100 × Income (loss) before income taxes ÷ Revenues
= 100 × 1,331 ÷ 10,290 = 12.93%

Segment profitability ratio Reportable segment The company
Segment profit margin Ford Credit Ford Credit segment profit margin ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Return on Assets (Segment ROA)

Ford Motor Co., ROA by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 12.65% 12.22% 5.94%
Ford Model e -34.44% -40.36% -34.80%
Ford Pro 245.48% 148.00% 147.32%
Ford Next -66.67% -236.22% -30.98% -31.67% -114.70%
Ford Credit 0.90% 1.93% 3.51% 1.65% 1.87%

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

Segment profitability ratio Reportable segment The company
Segment ROA Ford Blue Ford Blue segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Ford Model e Ford Model e segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.
Ford Pro Ford Pro segment ROA improved from 2021 to 2022 and from 2022 to 2023.
Ford Next Ford Next segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Ford Credit Ford Credit segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Ford Blue

Ford Motor Co.; Ford Blue; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 7,462 6,847 3,293
Total assets 58,990 56,023 55,456
Segment Profitability Ratio
Segment ROA1 12.65% 12.22% 5.94%

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
Segment ROA = 100 × Income (loss) before income taxes ÷ Total assets
= 100 × 7,462 ÷ 58,990 = 12.65%

Segment profitability ratio Reportable segment The company
Segment ROA Ford Blue Ford Blue segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Ford Model e

Ford Motor Co.; Ford Model e; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes (4,701) (2,133) (892)
Total assets 13,648 5,285 2,563
Segment Profitability Ratio
Segment ROA1 -34.44% -40.36% -34.80%

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
Segment ROA = 100 × Income (loss) before income taxes ÷ Total assets
= 100 × -4,701 ÷ 13,648 = -34.44%

Segment profitability ratio Reportable segment The company
Segment ROA Ford Model e Ford Model e segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment ROA: Ford Pro

Ford Motor Co.; Ford Pro; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 7,222 3,222 2,665
Total assets 2,942 2,177 1,809
Segment Profitability Ratio
Segment ROA1 245.48% 148.00% 147.32%

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
Segment ROA = 100 × Income (loss) before income taxes ÷ Total assets
= 100 × 7,222 ÷ 2,942 = 245.48%

Segment profitability ratio Reportable segment The company
Segment ROA Ford Pro Ford Pro segment ROA improved from 2021 to 2022 and from 2022 to 2023.

Segment ROA: Ford Next

Ford Motor Co.; Ford Next; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes (138) (926) (1,030) (1,274) (1,186)
Total assets 207 392 3,325 4,023 1,034
Segment Profitability Ratio
Segment ROA1 -66.67% -236.22% -30.98% -31.67% -114.70%

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
Segment ROA = 100 × Income (loss) before income taxes ÷ Total assets
= 100 × -138 ÷ 207 = -66.67%

Segment profitability ratio Reportable segment The company
Segment ROA Ford Next Ford Next segment ROA deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment ROA: Ford Credit

Ford Motor Co.; Ford Credit; segment ROA calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Income (loss) before income taxes 1,331 2,657 4,717 2,608 2,998
Total assets 148,521 137,954 134,428 158,524 160,697
Segment Profitability Ratio
Segment ROA1 0.90% 1.93% 3.51% 1.65% 1.87%

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
Segment ROA = 100 × Income (loss) before income taxes ÷ Total assets
= 100 × 1,331 ÷ 148,521 = 0.90%

Segment profitability ratio Reportable segment The company
Segment ROA Ford Credit Ford Credit segment ROA deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover

Ford Motor Co., asset turnover by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 2.38 2.33 1.99
Ford Model e 0.48 1.02 1.24
Ford Pro 19.73 22.48 23.58
Ford Next 0.01 0.25 0.04 0.01 0.04
Ford Credit 0.07 0.07 0.07 0.07 0.08

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

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Blue Ford Blue segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Ford Model e Ford Model e segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Pro Ford Pro segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Next Ford Next segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.
Ford Credit Ford Credit segment asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Asset Turnover: Ford Blue

Ford Motor Co.; Ford Blue; segment 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 140,627 130,782 110,466
Total assets 58,990 56,023 55,456
Segment Activity Ratio
Segment asset turnover1 2.38 2.33 1.99

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
Segment asset turnover = Revenues ÷ Total assets
= 140,627 ÷ 58,990 = 2.38

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Blue Ford Blue segment asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Ford Model e

Ford Motor Co.; Ford Model e; segment 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 6,526 5,374 3,186
Total assets 13,648 5,285 2,563
Segment Activity Ratio
Segment asset turnover1 0.48 1.02 1.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
Segment asset turnover = Revenues ÷ Total assets
= 6,526 ÷ 13,648 = 0.48

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Model e Ford Model e segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Ford Pro

Ford Motor Co.; Ford Pro; segment 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 58,058 48,939 42,649
Total assets 2,942 2,177 1,809
Segment Activity Ratio
Segment asset turnover1 19.73 22.48 23.58

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
Segment asset turnover = Revenues ÷ Total assets
= 58,058 ÷ 2,942 = 19.73

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Pro Ford Pro segment asset turnover ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Asset Turnover: Ford Next

Ford Motor Co.; Ford Next; segment 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 3 99 118 56 41
Total assets 207 392 3,325 4,023 1,034
Segment Activity Ratio
Segment asset turnover1 0.01 0.25 0.04 0.01 0.04

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
Segment asset turnover = Revenues ÷ Total assets
= 3 ÷ 207 = 0.01

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Next Ford Next segment asset turnover ratio improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Segment Asset Turnover: Ford Credit

Ford Motor Co.; Ford Credit; segment 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 10,290 8,978 10,073 11,203 12,260
Total assets 148,521 137,954 134,428 158,524 160,697
Segment Activity Ratio
Segment asset turnover1 0.07 0.07 0.07 0.07 0.08

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
Segment asset turnover = Revenues ÷ Total assets
= 10,290 ÷ 148,521 = 0.07

Segment activity ratio Reportable segment The company
Segment asset turnover Ford Credit Ford Credit segment asset turnover ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Segment Capital Expenditures to Depreciation

Ford Motor Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 1.47 1.40 1.51
Ford Model e 5.67 5.37 3.63
Ford Pro 0.01 0.02 0.04
Ford Next 0.50 4.60 5.75 3.84 3.41
Ford Credit 0.03 0.03 0.03 0.01 0.01

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

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Blue Ford Blue segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.
Ford Model e Ford Model e segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.
Ford Pro Ford Pro segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Next Ford Next segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.
Ford Credit Ford Credit segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Segment Capital Expenditures to Depreciation: Ford Blue

Ford Motor Co.; Ford Blue; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash outflow for capital spending 4,963 4,702 5,214
Depreciation and tooling amortization 3,378 3,365 3,445
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.47 1.40 1.51

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
Segment capital expenditures to depreciation = Cash outflow for capital spending ÷ Depreciation and tooling amortization
= 4,963 ÷ 3,378 = 1.47

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Blue Ford Blue segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 not reaching 2021 level.

Segment Capital Expenditures to Depreciation: Ford Model e

Ford Motor Co.; Ford Model e; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash outflow for capital spending 2,861 1,336 516
Depreciation and tooling amortization 505 249 142
Segment Financial Ratio
Segment capital expenditures to depreciation1 5.67 5.37 3.63

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
Segment capital expenditures to depreciation = Cash outflow for capital spending ÷ Depreciation and tooling amortization
= 2,861 ÷ 505 = 5.67

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Model e Ford Model e segment capital expenditures to depreciation ratio improved from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Ford Pro

Ford Motor Co.; Ford Pro; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash outflow for capital spending 7 26 59
Depreciation and tooling amortization 1,291 1,522 1,423
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.01 0.02 0.04

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
Segment capital expenditures to depreciation = Cash outflow for capital spending ÷ Depreciation and tooling amortization
= 7 ÷ 1,291 = 0.01

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Pro Ford Pro segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Ford Next

Ford Motor Co.; Ford Next; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash outflow for capital spending 6 23 46 142 99
Depreciation and tooling amortization 12 5 8 37 29
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.50 4.60 5.75 3.84 3.41

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
Segment capital expenditures to depreciation = Cash outflow for capital spending ÷ Depreciation and tooling amortization
= 6 ÷ 12 = 0.50

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Next Ford Next segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 and from 2022 to 2023.

Segment Capital Expenditures to Depreciation: Ford Credit

Ford Motor Co.; Ford Credit; segment capital expenditures to depreciation calculation

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cash outflow for capital spending 80 58 44 40 52
Depreciation and tooling amortization 2,354 2,281 1,666 3,269 3,666
Segment Financial Ratio
Segment capital expenditures to depreciation1 0.03 0.03 0.03 0.01 0.01

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
Segment capital expenditures to depreciation = Cash outflow for capital spending ÷ Depreciation and tooling amortization
= 80 ÷ 2,354 = 0.03

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Ford Credit Ford Credit segment capital expenditures to depreciation ratio deteriorated from 2021 to 2022 but then improved from 2022 to 2023 exceeding 2021 level.

Revenues

Ford Motor Co., revenues by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 140,627 130,782 110,466
Ford Model e 6,526 5,374 3,186
Ford Pro 58,058 48,939 42,649
Automotive 115,885 143,599
Ford Next 3 99 118 56 41
Ford Credit 10,290 8,978 10,073 11,203 12,260
Corporate Other 9 26 26
Eliminations/Adjustments (39,322) (36,141) (30,177)
Total 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).


Income (loss) before income taxes

Ford Motor Co., income (loss) before income taxes by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 7,462 6,847 3,293
Ford Model e (4,701) (2,133) (892)
Ford Pro 7,222 3,222 2,665
Automotive 1,633 4,926
Ford Next (138) (926) (1,030) (1,274) (1,186)
Ford Credit 1,331 2,657 4,717 2,608 2,998
Corporate Other (760) 748 1,247 (188) (359)
Interest on Debt (1,302) (1,259) (1,803) (1,649) (1,020)
Special Items (5,147) (12,172) 9,583 (2,246) (5,999)
Total 3,967 (3,016) 17,780 (1,116) (640)

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


Depreciation and tooling amortization

Ford Motor Co., depreciation and tooling amortization by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 3,378 3,365 3,445
Ford Model e 505 249 142
Ford Pro 1,291 1,522 1,423
Automotive 5,232 6,798
Ford Next 12 5 8 37 29
Ford Credit 2,354 2,281 1,666 3,269 3,666
Corporate Other 103 95 67
Special Items 47 157 567 236
Total 7,690 7,674 7,318 8,774 10,493

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


Cash outflow for capital spending

Ford Motor Co., cash outflow for capital spending by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 4,963 4,702 5,214
Ford Model e 2,861 1,336 516
Ford Pro 7 26 59
Automotive 5,560 7,481
Ford Next 6 23 46 142 99
Ford Credit 80 58 44 40 52
Corporate Other 315 424 348
Special Items 4 297
Total 8,236 6,866 6,227 5,742 7,632

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


Total assets

Ford Motor Co., total assets by reportable segment

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Ford Blue 58,990 56,023 55,456
Ford Model e 13,648 5,285 2,563
Ford Pro 2,942 2,177 1,809
Automotive 109,963 101,348
Ford Next 207 392 3,325 4,023 1,034
Ford Credit 148,521 137,954 134,428 158,524 160,697
Corporate Other 52,521 55,580 60,871
Eliminations/Adjustments (3,519) (1,527) (1,417) (5,249) (4,542)
Total 273,310 255,884 257,035 267,261 258,537

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