Stock Analysis on Net
Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Investments

Microsoft Excel

Adjustment to Net Income (Loss): Mark to Market Available-for-sale Securities

Ford Motor Co., adjustment to net income (loss) attributable to Ford Motor Company

US$ in millions

Microsoft Excel
12 months ended: Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Net income (loss) attributable to Ford Motor Company (as reported) 4,347 (1,981) 17,937 (1,279) 47
Add: Marketable securities 272 (423) (175) 85 130
Net income (loss) attributable to Ford Motor Company (adjusted) 4,619 (2,404) 17,762 (1,194) 177

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

Adjusted Profitability Ratios: Mark to Market Available-for-sale Securities (Summary)

Ford Motor Co., adjusted profitability ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Net Profit Margin
Reported net profit margin 2.62% -1.33% 14.21% -1.10% 0.03%
Adjusted net profit margin 2.78% -1.61% 14.07% -1.03% 0.12%
Return on Equity (ROE)
Reported ROE 10.16% -4.58% 36.97% -4.17% 0.14%
Adjusted ROE 10.80% -5.56% 36.61% -3.89% 0.53%
Return on Assets (ROA)
Reported ROA 1.59% -0.77% 6.98% -0.48% 0.02%
Adjusted ROA 1.69% -0.94% 6.91% -0.45% 0.07%

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

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Ford Motor Co. adjusted net profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Ford Motor Co. adjusted ROE deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Ford Motor Co. adjusted ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Ford Motor Co., Profitability Ratios: Reported vs. Adjusted

Adjusted Net Profit Margin

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Ford Motor Company 4,347 (1,981) 17,937 (1,279) 47
Company revenues excluding Ford Credit 165,901 149,079 126,268 115,941 143,640
Profitability Ratio
Net profit margin1 2.62% -1.33% 14.21% -1.10% 0.03%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Ford Motor Company 4,619 (2,404) 17,762 (1,194) 177
Company revenues excluding Ford Credit 165,901 149,079 126,268 115,941 143,640
Profitability Ratio
Adjusted net profit margin2 2.78% -1.61% 14.07% -1.03% 0.12%

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

2023 Calculations

1 Net profit margin = 100 × Net income (loss) attributable to Ford Motor Company ÷ Company revenues excluding Ford Credit
= 100 × 4,347 ÷ 165,901 = 2.62%

2 Adjusted net profit margin = 100 × Adjusted net income (loss) attributable to Ford Motor Company ÷ Company revenues excluding Ford Credit
= 100 × 4,619 ÷ 165,901 = 2.78%

Profitability ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Ford Motor Co. adjusted net profit margin ratio deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Adjusted Return on Equity (ROE)

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Ford Motor Company 4,347 (1,981) 17,937 (1,279) 47
Equity attributable to Ford Motor Company 42,773 43,242 48,519 30,690 33,185
Profitability Ratio
ROE1 10.16% -4.58% 36.97% -4.17% 0.14%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Ford Motor Company 4,619 (2,404) 17,762 (1,194) 177
Equity attributable to Ford Motor Company 42,773 43,242 48,519 30,690 33,185
Profitability Ratio
Adjusted ROE2 10.80% -5.56% 36.61% -3.89% 0.53%

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

2023 Calculations

1 ROE = 100 × Net income (loss) attributable to Ford Motor Company ÷ Equity attributable to Ford Motor Company
= 100 × 4,347 ÷ 42,773 = 10.16%

2 Adjusted ROE = 100 × Adjusted net income (loss) attributable to Ford Motor Company ÷ Equity attributable to Ford Motor Company
= 100 × 4,619 ÷ 42,773 = 10.80%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by shareholders’ equity. Ford Motor Co. adjusted ROE deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

Adjusted Return on Assets (ROA)

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
As Reported
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Ford Motor Company 4,347 (1,981) 17,937 (1,279) 47
Total assets 273,310 255,884 257,035 267,261 258,537
Profitability Ratio
ROA1 1.59% -0.77% 6.98% -0.48% 0.02%
Adjusted: Mark to Market Available-for-sale Securities
Selected Financial Data (US$ in millions)
Adjusted net income (loss) attributable to Ford Motor Company 4,619 (2,404) 17,762 (1,194) 177
Total assets 273,310 255,884 257,035 267,261 258,537
Profitability Ratio
Adjusted ROA2 1.69% -0.94% 6.91% -0.45% 0.07%

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

2023 Calculations

1 ROA = 100 × Net income (loss) attributable to Ford Motor Company ÷ Total assets
= 100 × 4,347 ÷ 273,310 = 1.59%

2 Adjusted ROA = 100 × Adjusted net income (loss) attributable to Ford Motor Company ÷ Total assets
= 100 × 4,619 ÷ 273,310 = 1.69%

Profitability ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by total assets. Ford Motor Co. adjusted ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.