Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please calculate the four ratios for 2018 and 2019 and show your work. if you can't do them all do as many as you can.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

please calculate the four ratios for 2018 and 2019 and show your work. if you can't do them all do as many as you can.

B 17,504 16,718 D 18,492 E 15,905 F 14,272 17,147 17,233 20,435 22,922 20,904 A Cash and cash equivalents Marketable securities Ford Credit finance receivables, net Trade and other receivables, less allowances Inventories 53,651 54,353 52,210 46,266 45,137 9,237 11,195 10,599 11,102 11,042 10,786 11,220 10,277 8,898 8,319 Assets held for sale 2,383 3,339 3,930 3,889 3,368 108,461 2,913 102,587 114,047 114,649 115,902 53,703 55,544 56,182 49,924 45,554 Other assets Current assets Ford Credit finance receivables, net Net investment in operating leases Net property Equity in net assets of affiliated companies Deferred income taxes 29,230 29,119 28,235 28,829 27,093 36,469 36,178 35,327 32,072 30,163 2,519 2,709 3,085 3,304 3,224 11,863 10,412 10,973 11,509 9,705 5,656 Other assets 10,706 8,104 4,795 Non-current assets 144,490 7,929 141,891 256,540 141,906 129,490 122,338 224,925 Total assets 258,537 257,808 237,951 E Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 20,673 21,520 23,282 21,296 20,272 Payables Dealer and dealers' customer allowances and claims 13,113 11,369 10,902 9,542 8,122 Deferred revenue 2,091 2,095 2,107 3,866 4,675 1,857 1,755 1,661 1,469 1,562 Employee benefit plans Accrued interest 1,128 988 1,057 974 840 OPEB 332 339 348 349 354 Pension 185 204 229 247 249 Current operating lease liabilities 367 Other 3,914 3,806 3,393 2,869 3,287 Current other liabilities and deferred revenue 22,987 20,556 19,316 19,089 19,697 3,356 1,445 2,314 2,685 1,779 Automotive debt payable within one year Ford Credit debt payable within one year Other debt payable within one year 52,371 51,179 48,265 46,984 41,196 130 526 Liabilities held for sale 4 AA Anna nnnn Balance Sheet Liabilities Equity Income Statement Complncome Cash FlowStatement Balance Sheet Assets B C D E F Current liabilities 98,132 90,281 82,336 1 Pension 9,878 10,150 9,543 2 OPEB 95,569 9,423 5,220 2,497 94,600 9,932 5,821 2,471 5,740 5,516 5,347 3 Dealer and dealers' customer allowances and claims 2,564 2,731 4 Deferred revenue 1,921 4,191 1,047 3,985 3,829 3,687 3,285 5 Non-current operating lease liabilities Employee benefit plans _6 1,080 1,139 1,041 1,104 1,443 1,063 1,415 7 Other 1,383 1,510 1,519 24,711 -8 23,588 24,395 23,457 25,324 13,233 9 11,233 12,575 13,222 11,060 SO Non-current other liabilities and deferred revenue Automotive long-term debt payable after one year Ford Credit long-term debt payable after one year Other long-term debt payable after one year Deferred income taxes 87,658 88,887 89,492 80,079 78,819 31 470 600 599 52 490 597 815 691 502 33 124,905 113,838 127,175 225,307 128,192 222,792 118,387 208,668 34 220,474 196,174 Non-current liabilities Total liabilities donmahla nananntrollin interact Balance Sheet Assets Balance Sheet Liabilities Equity 1on no nc Income Statement Compincome Cash FlowStatement Workbook Statistics B D E F 470 600 A Other long-term debt payable after one year Deferred income taxes 599 490 597 815 691 502 Non-current liabilities 127,175 225,307 124,905 220,474 128,192 222,792 118,387 208,668 113,838 196,174 Total liabilities 100 98 96 94 5 40 40 40 40 40 7 1 1 1 1 1 8 22,165 22,006 21,843 21,630 21,421 9 22,668 21,218 15,634 14,414 80 Redeemable noncontrolling interest Common Stock, par value $.01 per share Class B Stock, par value $.01 per share Capital in excess of par value of stock Retained earnings Accumulated other comprehensive loss Treasury stock Equity attributable to Ford Motor Company Equity attributable to noncontrolling interests Total equity Total liabilities and equity 20,320 (7,728) (1,613) (6,959) (6,257) (7,366) (1,417) 35,932 (7,013) (1,122) 41 (1,253) (977) 28,642 42 33,185 34,890 29,170 43 45 34 28 17 15 44 34,918 33,230 258,537 35,966 256,540 29,187 237,951 28,657 224,925 45 257,808 46 Based on:10-K (filling date: 2020-02-05), 10-K (filing date: 2019-02-21),10-K (Filing date: 2018-02-08),10-K (filing date: 2017-02-09), 10-K (Filing date: 2016-02-11). III Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement A B C D E F G 12 months ended: Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Automotive revenues 143,599 148,294 145,653 141,546 140,566 Cost of sales (134,693) (136,269) (131,332) (126,183) (124,446) Gross profit 8,906 12,025 14,321 15,363 16,120 Ford Credit revenues 12,260 12,018 11,113 10,253 8,992 10 41 (11,161) 26 (11,403) 10 (11,527) 1 (10,972) 11 (10,763) Mobility revenues Selling, administrative, and other expenses Ford Credit interest, operating, and other expenses 12 (9,472) (9,463) (9, 104) (8,904) (7,368) 13 Operating income 574 3,203 4,813 5,741 6,981 14 Interest expense on Automotive debt (963) (1,171) (1.133) (894) (773) 15 Interest expense on Other debt (57) (57) (1,020) 16 (1,228) (1,133) (894) (773) Interest expense Net periodic pension and OPEB income Icoct) vcluding cervice cost (1 an 78A 1 757 (16259 AAA 1 E Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement A B D E F (1,020) (1,228) (1,133) (894) (773) Interest expense Net periodic pension and OPEB income (cost), excluding service cost (1,602) 786 1,757 (1,625) 666 Investment-related interest income 809 667 459 291 309 (29) 33 2. 3 3 Interest income (expense) on income taxes Realized and unrealized gains (losses) on cash equivalents, marketable securities, and other investments Gains (losses) on changes in investments in affiliates 144 115 (23) 2. 46 20 42 14 139 42 22. Gains (losses) on extinguishment of debt (55) 1 23 Royalty income 381 491 678 714 666 24 Insurance premiums earned 156 133 25 Other 106 113 380 489 360 26 Other income (loss), net (226) 2,247 3,267 169 2,226 -------- 4 4 E Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement Workbook Statistics A B C D E F G affiliates 20 12 14 139 42 Gains (losses) on extinguishment of debt (55) 1 Royalty income 381 491 678 714 666 Insurance premiums earned 156 133 Other 106 113 380 489 360 Other income (loss), net (226) 2,247 3,267 169 2,226 Equity in net income of affiliated companies 32 123 1,201 1,780 1,818 3 Income (loss) before income taxes (640) 4,345 8,148 6,796 10,252 9 (Provision for) benefit from income taxes 724 (650) (520) (2,189) (2,881) 30 84 3,695 7,628 4,607 7,371 31 Net income (Income) loss attributable to noncontrolling interests Net income attributable to Ford Motor Company (37) (18) (26) (11) 2 32 47 3,677 7,602 4,596 7,373 BalanceSheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement 12 months ended: Dec 31, 2019 Dec 31, 2018 Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Net income 84 3,695 7,628 4,607 7,371 Foreign currency translation 174 (523) 314 (1,024) (1,132) Marketable securities 130 (11) (34) (8) (6) Derivative instruments (689) 183 (265) 219 227 Pension and other postretirement benefits 23 (56) 37 56 (81) Other comprehensive income (loss), net of tax (362) (407) 52 (757) (992) (278) 3,288 7,680 3,850 6,379 Comprehensive income (loss) Comprehensive (income) loss attributable to noncontrolling interests Comprehensive income (loss) attributable to Ford Motor Company (37) (18) (24) (10) 2 (315) 3,270 7,656 3,840 6,381 E BalanceSheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement Dec 31, 2019 84 9,689 (1,199) 804 Dec 31, 2018 3,695 9,280 (972) Dec 31, 2017 7,628 9,122 (669) Dec 31, 2016 4,607 9,023 (306) Dec 31, 2015 7,371 7,993 (27) 413 609 717 672 418 2,625 400 12 months ended: Net income Depreciation and tooling amortization Other amortization Held-for-sale impairment charges Provision for credit and insurance losses Pension and other postretirement employee benefits (OPEB) expense (income) Equity investment (earnings) losses in excess of dividends received Foreign currency adjustments Net (gain) loss on changes in investments in affiliates Stock compensation Provision for deferred income taxes (Increase) decrease in finance receivables (wholesale and other) (608) 2,667 511 206 203 (54) (29) 228 (1,370) 529 (42) 191 240 (403) (7) 246 (232) (178) 283 (139) 210 1,478 (333) 710 (42) 199 2,120 (197) 1,554 (2,408) (836) (1,449) (5,090) (Increase) decrease in accounts receivable and other assets (Increase) decrease in inventory (816) 206 (2,239) (828) (2,297) (959) (2,855) (815) (3,563) (1,155) E Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement Workbook Statistics A B D E F 206 (828) (959) (815) (1,155) 3 4 (Increase) decrease in inventory Increase (decrease) in accounts payable and accrued and other liabilities Cash changes in operating assets and liabilities Other Net cash provided by operating activities Capital spending 5 Acquisitions of finance receivables and operating leases Collections of finance receivables and operating leases Purchases of marketable securities and other investments 28 Sales and maturities of marketable and other investments 29 Settlements of derivatives Other 31 Net cash used in investing activities 32 Cash payments for dividends and dividend equivalents Purchases of common stock Net changes in short-term debt Proceeds from issuance of long-term debt 36 Principal payments on long-term debt 26 5,260 6,204 41 17,639 (7,632) (55,576) 50,182 (17,472) 16,929 (114) (38) (13,721) (2,389) (237) (1,384) 47,604 (46,497) 6,781 1,306 17 15,022 (7,785) (62,924) 50,880 (17,140) 20,527 358 (177) (16,261) (2,905) (164) (2,819) 50,130 (44,172) 6,595 1,476 (1) 19,792 (6,992) (56,007) 38,834 (31,428) 29,354 825 27 6,089 1,997 65 18,096 (7,049) (59,354) 44,641 (27,567) 29,898 100 (61) (19,392) (2,584) (131) 1,229 45,801 (40,770) 7,758 (2,050) (700) 16,170 (7,196) (57,217) 38,130 (41,279) 40,766 134 62 500 30 33 (25,352) (3,376) (145) 3,864 45,961 (38,797) (26,162) (2,380) (129) 1,646 48,860 (33,358) 34 35 Balance Sheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement F B A TUTTOSCUOTACIODICCONTICS on TTCT TITUCSITTCTTD Sales and maturities of marketable and other investments Settlements of derivatives Other Net cash used in Investing 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 Principal payments on 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 Cash, cash equivalents, and restricted cash at beginning of period 16,929 (114) (38) (13,721) (2,389) (237) (1,384) 47,604 (46,497) (226) (3,129) C TLT ITT 20,527 358 (177) (16,261) (2,905) (164) (2,819) 50,130 (44,172) (192) (122) D TCIJUTT 29,898 100 (61) (19,392) (2,584) (131) 1,229 45,801 (40,770) (151) 3,394 E IZON 29,354 825 62 (25,352) (3,376) (145) 3,864 45,961 (38,797) (49) 7,458 40,766 134 500 (26,162) (2,380) (129) 1,646 48,860 (33,358) (317) 14,322 45 (370) 489 (265) (815) 834 (1,731) 2,587 1,633 3,515 16,907 18,638 15,905 14,272 10,757 Cash, cash equivalents, and restricted cash at end of period 17,741 16,907 18,492 15,905 14,272 = BalanceSheet Assets BalanceSheet Liabilities Equity Income Statement Complncome Cash FlowStatement Return on common equity (ROCE) Profit margin for ROCE Return to creditors Capital structure leverage Calculate the following 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

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

BondsA Concise Guide For Investors

Authors: M. Choudhry

2nd Edition

0230006493, 9780230006492

More Books

Students also viewed these Accounting questions

Question

=+3. What are the components of a social media communication audit?

Answered: 1 week ago