Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BALANCE SHEET: INCOME STATEMENT: CASH FLOW: SOLVE FOR ALL RATIOS (SHOW THE MATH) FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (in millions) December 31

BALANCE SHEET:

image text in transcribed

INCOME STATEMENT:

image text in transcribed

CASH FLOW:

image text in transcribed

SOLVE FOR ALL RATIOS (SHOW THE MATH)

image text in transcribed

FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (in millions) December 31 2020 December 31, 2021 25,243 $ 24,718 42,401 9,993 10,808 3,581 116,744 55,277 27,951 37,083 4,901 12,423 12.882 267,261 $ 20,540 29,053 32,543 11,370 12,065 3,425 108,996 51,256 26,361 37,139 4,545 13,796 14,942 257,035 22,204 $ 23,645 22,349 18,686 ASSETS Cash and cash equivalents (Note 9) Marketable securities (Note 9) Ford Credit finance receivables, net of allowance for credit losses of $394 and $282 (Note 10) Trade and other receivables, less allowances of $84 and $48 Inventories (Note 11) Other assets Total current assets Ford Credit finance receivables, net of allowance for credit losses of $911 and $643 (Note 10) Net investment in operating leases (Note 12) Net property (Note 13) Equity in net assets of affiliated companies (Note 14) Deferred income taxes (Note 7) Other assets Total assets LIABILITIES Payables Other liabilities and deferred revenue (Note 16 and Note 25) Debt payable within one year (Note 19) Company excluding Ford Credit Ford Credit Total current liabilities Other liabilities and deferred revenue (Note 16 and Note 25) Long-term debt (Note 19) Company excluding Ford Credit Ford Credit Deferred income taxes (Note 7) Total liabilities EQUITY Common Stock, par value $0.01 per share (4,050 million shares issued of 6 billion authorized) Class B Stock, par value $0.01 per share (71 million shares issued of 530 million authorized) Capital in excess of par value of stock Retained earnings Accumulated other comprehensive income/loss) (Note 23) Treasury stock Total equity attributable to Ford Motor Company Equity attributable to noncontrolling interests Total equity Total liabilities and equity 1,374 49.969 97,192 28,379 3,175 46,517 90,727 27,705 22,633 87,708 538 236,450 17,200 71,200 1,581 208,413 40 1 22,290 18,243 (8,294) (1,590) 30,690 121 30,811 267,261 $ 40 1 22,611 35,769 (8,339) (1,563) 48,519 103 48,622 257,035 $ The following table includes assets to be used to settle liabilities of the consolidated variable interest entities (VIES"). These assets and liabilities are included in the consolidated balance sheets above. See Nole 24 for additional information on our VIEs. December 31, December 31, 2020 2021 ASSETS Cash and cash equivalents 2,822 $ 3,407 Ford Credit finance receivables, net 51,472 43,001 Net investment in operating leases 7,540 Other assets 39 LIABILITIES Other liabilities and deferred revenue 56 $ Debt 46,770 38,274 The accompanying notes are part of the consolidated financial statements. 12,794 6 FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED INCOME STATEMENTS (in millions, except per share amounts) For the years ended December 31, 2019 2020 2021 Revenues Automotive Ford Credit Mobility Total revenues (Note 4) 143,604 $ 12,260 36 155,900 115,894 $ 11,203 47 127,144 126,150 10,073 118 136,341 Costs and expenses Cost of sales Selling, administrative, and other expenses Ford Credit interest, operating, and other expenses Total costs and expenses Operating income/(loss) Interest expense on Company debt excluding Ford Credit Other income (loss), net (Note 5 and Note 22) Equity in net incomel(loss) of affiliated companies Income/(Loss) before income taxes Provision for/(Benefit from) income taxes (Note 7) Net income (loss) Less: Income/(Loss) attributable to noncontrolling interests Net income/(loss) attributable to Ford Motor Company 134,693 11,161 9,472 155,326 574 1,020 (226) 32 (640) (724) 84 37 47 $ 112,752 10,193 8,607 131,552 (4,408) 1,649 4,899 42 (1.116) 160 (1.276) 3 (1,279) $ 114,651 11,915 5,252 131,818 4,523 1,803 14,733 327 17,780 (130) 17,910 (27) 17,937 $ EARNING S/(LOSS) PER SHARE ATTRIBUTABLE TO FORD MOTOR COMPANY COMMON AND CLASS B STOCK (Note 8) Basic income/(loss) 0.01$ Diluted income (loss) (0.32) $ 0.01 (0.32) 4.49 4.45 Weighted average shares used in computation of earnings/(loss) per share Basic shares Diluted shares 3,972 4,004 3,973 3,973 3,991 4,034 $ 174 43 CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (in millions) For the years ended December 31, 2019 2020 2021 Net Income/(loss) 84 $ (1.276) $ 17,910 Other comprehensive income/(loss), net of tax (Note 23) Foreign currency translation (901) Marketable securities 130 (175) Derivative instruments (689) 222 Pension and other postretirement benefits Total other comprehensive income/(loss), net of tax (362) Comprehensive income (loss) (278) (1,843) 17,869 Less: Comprehensive income/loss) attributable to noncontrolling interests 37 (23) Comprehensive income (loss) attributable to Ford Motor Company (315) $ (1,845) $ 17,892 85 73 18 23 27 (567) 2 S The accompanying notes are part of the consolidated financial statements, FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (in millions) For the years ended December 31, 2019 2020 2021 Cash flows from operating activities Net income/(loss) S 84 S (1.276) $ 17.910 Depreciation and tooling amortization (Note 12 and Note 13) 9,689 8,751 7,318 Other amortization (1.199) (1,294) (1,358) Held-for-sale impairment charges (Note 21) -- 804 23 Brazil manufacturing exit non-cash charges (excluding accelerated depreciation of $145 and $322) (Note 21) 1.159 48 (Gains/Losses on extinguishment of debt (Note 5 and Note 19) 55 1 1,702 Provision for/(Benefit from) credit and insurance losses 413 929 (298) Pension and other post-retirement employee benefits ("OPEB") expense/income) (Note 17) 2,625 1,027 (4,865) Equity investment dividends received in excess of earnings)/losses 203 130 116 Foreign currency adjustments (54) (420) 532 Net realized and unrealized (gains)/losses on cash equivalents, marketable securities, and other investments (139) (315) (9,159) Net (gainyloss on changes in investments in affiliates (Note 5) (29) () (3,446) (368) Stock compensation (Note 6) 228 199 305 Provision for deferred income taxes (1,370) (269) (563) Decrease/(Increase) in finance receivables (wholesale and other) 1,554 12,104 7,656 Decrease/Increase) in accounts receivable and other assets (816) (63) (1,141) Decrease/Increase) in inventory 206 148 (1,778) Increase/(Decrease) in accounts payable and accrued and other liabilities ( 5,260 6,809 (36) Other 125 72 (234) Net cash provided by/(used in) operating activities 17,639 24,269 15,787 (7,632) (55,576) 50,182 Cash flows from investing activities Capital spending Acquisitions of finance receivables and operating leases Collections of finance receivables and operating leases Proceeds from sale of business (Note 22) Purchases of marketable securities and other investments Sales and maturities of marketable securities and other investments Settlements of derivatives Other Net cash provided by/(used in) investing activities (17,472) 16,929 (114) (38) (13,721) (5,742) (55,901) 48,746 1,340 (39,624) 32,395 (323) 494 (18,615) (6,227) (48,379) 52,094 145 (27,491) 33,229 (272) (354) 2,745 (596) (403) Cash flows from financing activities Cash payments for dividends and dividend equivalents Purchases of common stock Net changes in short-term debt Proceeds from issuance of long-term debt Payments of long-term debt Other Net cash provided by/(used in) financing activities Effect of exchange rate changes on cash, cash equivalents, and restricted cash Net increase/(decrease) in cash, cash equivalents, and restricted cash ) (2,389) (237) ) (1,384) 47,604 (46,497) (226) ( (3,129) 45 (2,291) 65,900 (60,514) (184) 2,315 225 8,194 $ 3,273 27,901 (54,164) (105) (23,498) (232) (5,198) S 834 $ $ Cash, cash equivalents, and restricted cash at beginning of period (Note 9) Net increase/(decrease) in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at end of period (Note 9) 16,907 $ 834 17,741 S 17,741 $ 8,194 25,935 $ 25,935 (5,198) 20,737 $ The accompanying notes are part of the consolidated financial statements, Current Year Prior Year Liquidity Ratios: Current ratio Current cash debt coverage ratio Receivables turnover ratio Average collection period Inventory turnover ratio Days in inventory What conclusions concerning the company's liquidity can be drawn from these ratios? Current Year Prior Year Solvency Ratios: Debt to total assets Cash debt coverage ratio Free cash flow What conclusions concerning the company's solvency can be drawn from these ratios Current Year Prior Year Profitability Ratios: Return on assets ratio Profit margin ratio Asset turnover ratio Gross profit rate Earnings per share. (you can use the "basic earnings per share" from the annual report income statement) What conclusions concerning the company's profitability can be drawn from these ratios FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED BALANCE SHEETS (in millions) December 31 2020 December 31, 2021 25,243 $ 24,718 42,401 9,993 10,808 3,581 116,744 55,277 27,951 37,083 4,901 12,423 12.882 267,261 $ 20,540 29,053 32,543 11,370 12,065 3,425 108,996 51,256 26,361 37,139 4,545 13,796 14,942 257,035 22,204 $ 23,645 22,349 18,686 ASSETS Cash and cash equivalents (Note 9) Marketable securities (Note 9) Ford Credit finance receivables, net of allowance for credit losses of $394 and $282 (Note 10) Trade and other receivables, less allowances of $84 and $48 Inventories (Note 11) Other assets Total current assets Ford Credit finance receivables, net of allowance for credit losses of $911 and $643 (Note 10) Net investment in operating leases (Note 12) Net property (Note 13) Equity in net assets of affiliated companies (Note 14) Deferred income taxes (Note 7) Other assets Total assets LIABILITIES Payables Other liabilities and deferred revenue (Note 16 and Note 25) Debt payable within one year (Note 19) Company excluding Ford Credit Ford Credit Total current liabilities Other liabilities and deferred revenue (Note 16 and Note 25) Long-term debt (Note 19) Company excluding Ford Credit Ford Credit Deferred income taxes (Note 7) Total liabilities EQUITY Common Stock, par value $0.01 per share (4,050 million shares issued of 6 billion authorized) Class B Stock, par value $0.01 per share (71 million shares issued of 530 million authorized) Capital in excess of par value of stock Retained earnings Accumulated other comprehensive income/loss) (Note 23) Treasury stock Total equity attributable to Ford Motor Company Equity attributable to noncontrolling interests Total equity Total liabilities and equity 1,374 49.969 97,192 28,379 3,175 46,517 90,727 27,705 22,633 87,708 538 236,450 17,200 71,200 1,581 208,413 40 1 22,290 18,243 (8,294) (1,590) 30,690 121 30,811 267,261 $ 40 1 22,611 35,769 (8,339) (1,563) 48,519 103 48,622 257,035 $ The following table includes assets to be used to settle liabilities of the consolidated variable interest entities (VIES"). These assets and liabilities are included in the consolidated balance sheets above. See Nole 24 for additional information on our VIEs. December 31, December 31, 2020 2021 ASSETS Cash and cash equivalents 2,822 $ 3,407 Ford Credit finance receivables, net 51,472 43,001 Net investment in operating leases 7,540 Other assets 39 LIABILITIES Other liabilities and deferred revenue 56 $ Debt 46,770 38,274 The accompanying notes are part of the consolidated financial statements. 12,794 6 FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED INCOME STATEMENTS (in millions, except per share amounts) For the years ended December 31, 2019 2020 2021 Revenues Automotive Ford Credit Mobility Total revenues (Note 4) 143,604 $ 12,260 36 155,900 115,894 $ 11,203 47 127,144 126,150 10,073 118 136,341 Costs and expenses Cost of sales Selling, administrative, and other expenses Ford Credit interest, operating, and other expenses Total costs and expenses Operating income/(loss) Interest expense on Company debt excluding Ford Credit Other income (loss), net (Note 5 and Note 22) Equity in net incomel(loss) of affiliated companies Income/(Loss) before income taxes Provision for/(Benefit from) income taxes (Note 7) Net income (loss) Less: Income/(Loss) attributable to noncontrolling interests Net income/(loss) attributable to Ford Motor Company 134,693 11,161 9,472 155,326 574 1,020 (226) 32 (640) (724) 84 37 47 $ 112,752 10,193 8,607 131,552 (4,408) 1,649 4,899 42 (1.116) 160 (1.276) 3 (1,279) $ 114,651 11,915 5,252 131,818 4,523 1,803 14,733 327 17,780 (130) 17,910 (27) 17,937 $ EARNING S/(LOSS) PER SHARE ATTRIBUTABLE TO FORD MOTOR COMPANY COMMON AND CLASS B STOCK (Note 8) Basic income/(loss) 0.01$ Diluted income (loss) (0.32) $ 0.01 (0.32) 4.49 4.45 Weighted average shares used in computation of earnings/(loss) per share Basic shares Diluted shares 3,972 4,004 3,973 3,973 3,991 4,034 $ 174 43 CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME (in millions) For the years ended December 31, 2019 2020 2021 Net Income/(loss) 84 $ (1.276) $ 17,910 Other comprehensive income/(loss), net of tax (Note 23) Foreign currency translation (901) Marketable securities 130 (175) Derivative instruments (689) 222 Pension and other postretirement benefits Total other comprehensive income/(loss), net of tax (362) Comprehensive income (loss) (278) (1,843) 17,869 Less: Comprehensive income/loss) attributable to noncontrolling interests 37 (23) Comprehensive income (loss) attributable to Ford Motor Company (315) $ (1,845) $ 17,892 85 73 18 23 27 (567) 2 S The accompanying notes are part of the consolidated financial statements, FORD MOTOR COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF CASH FLOWS (in millions) For the years ended December 31, 2019 2020 2021 Cash flows from operating activities Net income/(loss) S 84 S (1.276) $ 17.910 Depreciation and tooling amortization (Note 12 and Note 13) 9,689 8,751 7,318 Other amortization (1.199) (1,294) (1,358) Held-for-sale impairment charges (Note 21) -- 804 23 Brazil manufacturing exit non-cash charges (excluding accelerated depreciation of $145 and $322) (Note 21) 1.159 48 (Gains/Losses on extinguishment of debt (Note 5 and Note 19) 55 1 1,702 Provision for/(Benefit from) credit and insurance losses 413 929 (298) Pension and other post-retirement employee benefits ("OPEB") expense/income) (Note 17) 2,625 1,027 (4,865) Equity investment dividends received in excess of earnings)/losses 203 130 116 Foreign currency adjustments (54) (420) 532 Net realized and unrealized (gains)/losses on cash equivalents, marketable securities, and other investments (139) (315) (9,159) Net (gainyloss on changes in investments in affiliates (Note 5) (29) () (3,446) (368) Stock compensation (Note 6) 228 199 305 Provision for deferred income taxes (1,370) (269) (563) Decrease/(Increase) in finance receivables (wholesale and other) 1,554 12,104 7,656 Decrease/Increase) in accounts receivable and other assets (816) (63) (1,141) Decrease/Increase) in inventory 206 148 (1,778) Increase/(Decrease) in accounts payable and accrued and other liabilities ( 5,260 6,809 (36) Other 125 72 (234) Net cash provided by/(used in) operating activities 17,639 24,269 15,787 (7,632) (55,576) 50,182 Cash flows from investing activities Capital spending Acquisitions of finance receivables and operating leases Collections of finance receivables and operating leases Proceeds from sale of business (Note 22) Purchases of marketable securities and other investments Sales and maturities of marketable securities and other investments Settlements of derivatives Other Net cash provided by/(used in) investing activities (17,472) 16,929 (114) (38) (13,721) (5,742) (55,901) 48,746 1,340 (39,624) 32,395 (323) 494 (18,615) (6,227) (48,379) 52,094 145 (27,491) 33,229 (272) (354) 2,745 (596) (403) Cash flows from financing activities Cash payments for dividends and dividend equivalents Purchases of common stock Net changes in short-term debt Proceeds from issuance of long-term debt Payments of long-term debt Other Net cash provided by/(used in) financing activities Effect of exchange rate changes on cash, cash equivalents, and restricted cash Net increase/(decrease) in cash, cash equivalents, and restricted cash ) (2,389) (237) ) (1,384) 47,604 (46,497) (226) ( (3,129) 45 (2,291) 65,900 (60,514) (184) 2,315 225 8,194 $ 3,273 27,901 (54,164) (105) (23,498) (232) (5,198) S 834 $ $ Cash, cash equivalents, and restricted cash at beginning of period (Note 9) Net increase/(decrease) in cash, cash equivalents, and restricted cash Cash, cash equivalents, and restricted cash at end of period (Note 9) 16,907 $ 834 17,741 S 17,741 $ 8,194 25,935 $ 25,935 (5,198) 20,737 $ The accompanying notes are part of the consolidated financial statements, Current Year Prior Year Liquidity Ratios: Current ratio Current cash debt coverage ratio Receivables turnover ratio Average collection period Inventory turnover ratio Days in inventory What conclusions concerning the company's liquidity can be drawn from these ratios? Current Year Prior Year Solvency Ratios: Debt to total assets Cash debt coverage ratio Free cash flow What conclusions concerning the company's solvency can be drawn from these ratios Current Year Prior Year Profitability Ratios: Return on assets ratio Profit margin ratio Asset turnover ratio Gross profit rate Earnings per share. (you can use the "basic earnings per share" from the annual report income statement) What conclusions concerning the company's profitability can be drawn from these ratios

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_2

Step: 3

blur-text-image_3

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

Cornerstones of Managerial Accounting

Authors: Mowen, Hansen, Heitger

3rd Edition

324660138, 978-0324660135

More Books

Students also viewed these Accounting questions