Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started