Stock Analysis on Net
Stock Analysis on Net

Ford Motor Co. (NYSE:F)

Analysis of Goodwill and Intangible Assets

Microsoft Excel

Goodwill and Intangible Asset Disclosure

Ford Motor Co., balance sheet: goodwill and intangible assets

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Intangible assets, net 80 86 111 144 188
Goodwill 683 603 619 258 278
Net intangible assets and goodwill 763 689 730 402 466

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

Item Description The company
Intangible assets, net Sum of the carrying amounts of all intangible assets, excluding goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Ford Motor Co. intangible assets, net decreased from 2021 to 2022 and from 2022 to 2023.
Goodwill Amount after accumulated impairment loss of an asset representing future economic benefits arising from other assets acquired in a business combination that are not individually identified and separately recognized. Ford Motor Co. goodwill decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.
Net intangible assets and goodwill Sum of the carrying amounts of all intangible assets, including goodwill, as of the balance sheet date, net of accumulated amortization and impairment charges. Ford Motor Co. net intangible assets and goodwill decreased from 2021 to 2022 but then increased from 2022 to 2023 exceeding 2021 level.

Adjustments to Financial Statements: Removal of Goodwill

Ford Motor Co., adjustments to financial statements

US$ in millions

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Adjustment to Total Assets
Total assets (as reported) 273,310 255,884 257,035 267,261 258,537
Less: Goodwill 683 603 619 258 278
Total assets (adjusted) 272,627 255,281 256,416 267,003 258,259
Adjustment to Equity Attributable To Ford Motor Company
Equity attributable to Ford Motor Company (as reported) 42,773 43,242 48,519 30,690 33,185
Less: Goodwill 683 603 619 258 278
Equity attributable to Ford Motor Company (adjusted) 42,090 42,639 47,900 30,432 32,907

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

Ford Motor Co., Financial Data: Reported vs. Adjusted

Adjusted Financial Ratios: Removal of Goodwill (Summary)

Ford Motor Co., adjusted financial ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Total Asset Turnover
Reported total asset turnover 0.61 0.58 0.49 0.43 0.56
Adjusted total asset turnover 0.61 0.58 0.49 0.43 0.56
Financial Leverage
Reported financial leverage 6.39 5.92 5.30 8.71 7.79
Adjusted financial leverage 6.48 5.99 5.35 8.77 7.85
Return on Equity (ROE)
Reported ROE 10.16% -4.58% 36.97% -4.17% 0.14%
Adjusted ROE 10.33% -4.65% 37.45% -4.20% 0.14%
Return on Assets (ROA)
Reported ROA 1.59% -0.77% 6.98% -0.48% 0.02%
Adjusted ROA 1.59% -0.78% 7.00% -0.48% 0.02%

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

Financial ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Ford Motor Co. adjusted total asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.		 Ford Motor Co. adjusted financial leverage ratio increased from 2021 to 2022 and from 2022 to 2023.
Adjusted ROE A profitability ratio calculated as net income divided by adjusted 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 net income divided by adjusted total assets. Ford Motor Co. adjusted ROA deteriorated from 2021 to 2022 but then slightly improved from 2022 to 2023.

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

Adjusted Total Asset Turnover

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)
Company revenues excluding Ford Credit 165,901 149,079 126,268 115,941 143,640
Total assets 273,310 255,884 257,035 267,261 258,537
Activity Ratio
Total asset turnover1 0.61 0.58 0.49 0.43 0.56
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Company revenues excluding Ford Credit 165,901 149,079 126,268 115,941 143,640
Adjusted total assets 272,627 255,281 256,416 267,003 258,259
Activity Ratio
Adjusted total asset turnover2 0.61 0.58 0.49 0.43 0.56

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 Total asset turnover = Company revenues excluding Ford Credit ÷ Total assets
= 165,901 ÷ 273,310 = 0.61

2 Adjusted total asset turnover = Company revenues excluding Ford Credit ÷ Adjusted total assets
= 165,901 ÷ 272,627 = 0.61

Activity ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Ford Motor Co. adjusted total asset turnover ratio improved from 2021 to 2022 and from 2022 to 2023.

Adjusted Financial Leverage

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)
Total assets 273,310 255,884 257,035 267,261 258,537
Equity attributable to Ford Motor Company 42,773 43,242 48,519 30,690 33,185
Solvency Ratio
Financial leverage1 6.39 5.92 5.30 8.71 7.79
Adjusted for Goodwill
Selected Financial Data (US$ in millions)
Adjusted total assets 272,627 255,281 256,416 267,003 258,259
Adjusted equity attributable to Ford Motor Company 42,090 42,639 47,900 30,432 32,907
Solvency Ratio
Adjusted financial leverage2 6.48 5.99 5.35 8.77 7.85

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 Financial leverage = Total assets ÷ Equity attributable to Ford Motor Company
= 273,310 ÷ 42,773 = 6.39

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted equity attributable to Ford Motor Company
= 272,627 ÷ 42,090 = 6.48

Solvency ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.		 Ford Motor Co. adjusted financial leverage ratio increased from 2021 to 2022 and 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 for Goodwill
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Ford Motor Company 4,347 (1,981) 17,937 (1,279) 47
Adjusted equity attributable to Ford Motor Company 42,090 42,639 47,900 30,432 32,907
Profitability Ratio
Adjusted ROE2 10.33% -4.65% 37.45% -4.20% 0.14%

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 × Net income (loss) attributable to Ford Motor Company ÷ Adjusted equity attributable to Ford Motor Company
= 100 × 4,347 ÷ 42,090 = 10.33%

Profitability ratio Description The company
Adjusted ROE A profitability ratio calculated as net income divided by adjusted 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 for Goodwill
Selected Financial Data (US$ in millions)
Net income (loss) attributable to Ford Motor Company 4,347 (1,981) 17,937 (1,279) 47
Adjusted total assets 272,627 255,281 256,416 267,003 258,259
Profitability Ratio
Adjusted ROA2 1.59% -0.78% 7.00% -0.48% 0.02%

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 × Net income (loss) attributable to Ford Motor Company ÷ Adjusted total assets
= 100 × 4,347 ÷ 272,627 = 1.59%

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