Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me identify the following ratios from each year from the table below in an excel sheet: ROA ROE ROFL Asset Turnover Return

Can you help me identify the following ratios from each year from the table below in an excel sheet:

ROA

ROE

ROFL

Asset Turnover

Return on Assets

As Reported Annual Balance Sheet
Report Date 12/31/2022 12/31/2021 12/31/2020 12/31/2019 12/31/2018
Currency USD USD USD USD USD
Audit Status Not Qualified Not Qualified Not Qualified Not Qualified Not Available
Consolidated Yes Yes Yes Yes Yes
Scale Millions Millions Millions Millions Millions
Cash & cash equivalents 25134 20540 25243 17504 16718
Marketable securities 18936 29053 24718 17147 17233
Ford Credit finance receivables, net 38720 32543 42401 53651 54353
Trade & other receivables, gross 15834 11418 10077 9300 11289
Allowances 105 48 84 63 94
Trade & other receivables 15729 11370 9993 9237 11195
Raw materials, work-in-process, & supplies 5997 5785 4676 4402 4536
Finished products 8083 6280 6132 6384 6684
Inventories 14080 12065 10808 10786 11220
Assets held for sale 97 - 47 2383 -
Other assets 3780 3425 3534 3339 3930
Total current assets 116476 108996 116744 114047 114649
Ford Credit finance receivables, net 49903 51256 55277 53703 55544
Net investment in operating leases 22772 26361 27951 29230 29119
Land 371 450 451 421 445
Buildings & land improvements 11946 12438 12557 11900 11477
Machinery, equipment, & other property 38964 39636 40463 38939 38720
Software 5042 4598 3900 3691 3349
Construction in progress 3203 2152 1718 1710 2066
Total land, plant & equipment, & other property 59526 59274 59089 56661 56057
Accumulated depreciation 31781 32342 32848 31020 30243
Net land, plant & equipment, & other property 27745 26932 26241 25641 25814
Tooling, net of amortization 9520 10207 10842 10828 10364
Net property 37265 37139 37083 36469 36178
Equity in net assets of affiliated companies 2798 4545 4901 2519 2709
Deferred income taxes 15552 13796 12423 11863 10412
Other assets 11118 14942 12882 10706 7929
Total assets 255884 257035 267261 258537 256540
Payables 25605 22349 22204 20673 21520
Dealer & dealers' customer allowances & claims 9219 8300 12702 13113 11369
Deferred revenue 2404 2349 2161 2091 2095
Employee benefit plans 2020 1687 1752 1857 1755
Accrued interest 935 888 1215 1128 988
Other postretirement employee benefits ("OPEB") 329 332 339 332 339
Pension 196 202 193 185 204
Operating lease liabilities 404 345 323 367 -
Other current automotive other liabilities & deferred revenue - 4583 4960 3914 3806
Other current other liabilities & deferred revenue 5590 - - - -
Other liabilities & deferred revenue 21097 18686 23645 22987 20556
Short-term 359 286 613 315 614
Public unsecured debt securities - 86 - - -
U.S. Department of Energy Advanced Technology Vehicles Manufacturing ("DOE ATVM") Incentive Program - 953 148 591 591
Delayed draw term loan - 1500 - - -
Other debt 372 348 434 540 1125
Unamortized premium (discount) -1 2 -1 -1 -16
Automotive debt payable within one year - - 1194 1445 2314
Company excluding Ford Credit debt payable within one year 730 3175 - - -
Short-term 19624 14810 11429 13717 14705
Unsecured debt 7980 13660 17185 15062 22130
Asset-backed debt 21839 18049 21345 23609 14373
Unamortized premium (discount) - 1 2 1 2
Unamortized issuance costs -13 -13 -17 -17 -16
Fair value adjustments 4 10 25 -1 -15
Ford Credit debt payable within one year 49434 46517 49969 52371 51179
Other debt payable within one year - - 180 130 -
Liabilities held for sale - - - 526 -
Total current liabilities 96866 90727 97192 98132 95569
Pension 5673 8658 10738 9878 9423
OPEB 4130 5708 6236 5740 5220
Dealer & dealers' customer allowances & claims 6095 4909 3072 1921 2497
Deferred revenue 4883 4683 4559 4191 3985
Operating lease liabilities 1101 1048 991 1047 -
Employee benefit plans 834 1007 1074 1104 1080
Other non-current other liabilities & deferred revenue 2781 1692 1709 1443 1383
Other liabilities & deferred revenue 25497 27705 28379 25324 23588
Automotive - Public unsecured debt securities - - 18583 10583 9033
Automotive - Delayed draw term loan - - 1500 1500 -
Automotive - DOE ATVM Incentive Program - - 1064 880 1470
Automotive - Other debt - - 1622 547 1026
Automotive - Unamortized (discount)/premium - - -239 -161 -224
Automotive - Unamortized issuance costs - - -188 -116 -72
Automotive long-term debt - - 22342 13233 11233
Company excluding Ford Credit - public unsecured debt securities 14935 13643 - - -
Company excluding Ford Credit - convertible notes 2300 2300 - - -
Company excluding Ford Credit - UK Export finance program 1654 843 - - -
Company excluding Ford Credit - other debt 682 768 - - -
Company excluding Ford Credit - unamortized premium (discount) -180 -188 - - -
Company excluding Ford Credit - unamortized issuance costs -191 -166 - - -
Company excluding Ford Credit long-term debt 19200 17200 - - -
Financial Services - unsecured debt 39620 44337 54197 55148 52409
Financial Services - asset-backed debt 31840 26654 32276 32162 36844
Financial Services - unamortized premium (discount) 23 28 28 6 -
Financial Services - unamortized issuance costs -184 -199 -235 -197 -195
Financial Services - fair value adjustments -1694 380 1442 539 -171
Ford Credit long-term debt 69605 71200 87708 87658 88887
Unsecured debt - - 294 474 604
Unamortized (discount)/premium - - -3 -3 -3
Unamortized issuance costs - - - -1 -1
Other long-term debt - - 291 470 600
Deferred income taxes 1549 1581 538 490 597
Total liabilities 212717 208413 236450 225307 220474
Redeemable noncontrolling interest - - - - 100
Common stock 41 40 40 40 40
Class B stock 1 1 1 1 1
Capital in excess of par value of stock 22832 22611 22290 22165 22006
Retained earnings (accumulated deficit) 31754 35769 18243 20320 22668
Foreign currency translation -6416 -5487 -5526 -4626 -4800
Marketable securities -442 -19 156 71 -59
Derivative instruments 129 -193 -266 -488 201
Pension & other postretirement benefits -2610 -2640 -2658 -2685 -2708
Accumulated other comprehensive income (loss) -9339 -8339 -8294 -7728 -7366
Treasury stock 2047 1563 1590 1613 1417
Total equity (deficit) attributable to Ford Motor Company 43242 48519 30690 33185 35932
Equity (deficit) attributable to noncontrolling interests -75 103 121 45 34
Total equity (deficit) 43167 48622 30811 33230 35966

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Environmental Accounting Issues Concepts And Practice

Authors: Stefan Schaltegger, Roger Burritt

1st Edition

1874719349, 9781874719342

More Books

Students also viewed these Accounting questions

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago

Question

6. What information processes operate in communication situations?

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago