Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate ratios for the pink shaded areas. Prior ratios are given. Use formulas. 50 2016-12 2017-12 2018-12 2019-12 2020-12 51 52 Days Sales Outstanding 53
Calculate ratios for the pink shaded areas. Prior ratios are given. Use formulas.
50 2016-12 2017-12 2018-12 2019-12 2020-12 51 52 Days Sales Outstanding 53 Days Inventory 54 Payables Period 55 Cash Conversion Cycle 56 Receivables Turnover 57 Inventory Turnover 58 Fixed Assets Turnover 59 Asset Turnover 165,47 34,95 69,4 131,02 61,95 104,6 60 114,89 57,17 123 59,93 156,46 1,91 14,7 4,88 0,66 4,65 0,63 4,48 0,62 4,29 0,61 3,46 0,48 2016-12 151800 126584 25216 2017-12 156776 131332 25444 2018-12 160338 136269 24069 2019-12 155900 134693 21207 2020-12 127144 112752 14392 FORD MOTOR CO (F) INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. Revenue Cost of revenue Gross profit Operating expenses Sales, General and administrative Total operating expenses Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net income from continuing operations Other Net income Net income available to common shareholders Earnings per share Basic Diluted Weighted average shares outstanding Basic Diluted EBITDA 12196 12196 13020 9798 3574 6796 2189 4607 -11 4596 4596 11527 11527 13917 10237 4468 8148 520 7628 -26 7602 7602 11403 11403 12666 10691 2370 4345 650 3695 -18 3677 3677 11161 11161 10046 10521 -165 -640 -724 84 -37 47 47 10193 10193 4199 10256 4941 -1116 160 -1276 -3 -1279 -1279 0,01 1,16 1,15 1,91 1,9 0,93 0,92 -0,32 -0,32 0,01 3973 3999 25311 3975 3998 26838 3974 3998 23344 3972 4004 18371 3973 3973 16597 B D E F 2016-12 2017-12 2018-12 2019-12 2020-12 15905 18492 17504 22922 38827 57368 8898 3368 108461 20435 38927 62809 10277 3889 115902 16718 17233 33951 65548 11220 3930 114649 17147 34651 62888 10786 5722 114047 25243 24718 49961 52394 10808 3581 116744 59876 -27804 32072 32133 65189 -29862 35327 31320 69931 -32848 37083 32852 66421 -30243 36178 31828 264 178 10412 63031 141891 256540 67489 -31020 36469 31749 278 188 11863 63943 144490 9705 55580 129490 237951 10973 64286 141906 257808 12423 68159 150517 267261 258537 1 FORD MOTOR CO (F) BALANCE SHEET 2 Fiscal year ends in December. USD in millions except per share data. 3 Assets 4 Current assets 5 Cash 6 Cash and cash equivalents 7 Short-term investments 8 Total cash 9 Receivables 10 Inventories 11 Other current assets 12 Total current assets 13 Non-current assets 14 Property, plant and equipment 15 Gross property, plant and equipment 16 Accumulated Depreciation 17 Net property, plant and equipment 18 Equity and other investments 19 Goodwill 20 Intangible assets 21 Deferred income taxes 22 Other long-term assets 23 Total non-current assets 24 Total assets 25 Liabilities and stockholders' equity 26 Liabilities 27 Current liabilities 28 Short-term debt 29 Capital leases 30 Accounts payable 31 Accrued liabilities 32 Deferred revenues 33 Other current liabilities 34 Total current liabilities 35 Non-current liabilities 36 Long-term debt 37 Capital leases 38 Deferred taxes liabilities 39 Deferred revenues 40 Pensions and other benefits 41 Minority interest 42 Other long-term liabilities 43 Total non-current liabilities 44 Total liabilities 45 Stockholders' equity 46 Common stock 47 Additional paid-in capital 48 Retained earnings 49 Treasury stock 50 Accumulated other comprehensive income 51 Total stockholders' equity 52 Total liabilities and stockholders' equity 49669 51621 53493 21296 974 3866 14476 90281 23282 1057 2107 16533 94600 21520 988 2095 17473 95569 53946 367 20673 1128 2091 19927 98132 51343 323 22204 1215 2161 19946 97192 93301 102666 100720 691 3687 15666 17 5138 118500 208781 815 3829 15753 28 5227 128318 222918 597 3985 14643 34 5060 125039 220608 101361 1047 490 4191 15618 45 4468 127220 225352 110341 991 538 4559 16974 121 5855 139379 236571 41 21630 15634 -1122 -7013 29170 237951 41 21843 21218 - 1253 -6959 34890 257808 41 22006 22668 -1417 -7366 35932 256540 41 22165 20320 - 1613 -7728 33185 258537 41 22290 18243 - 1590 -8294 30690 267261Step 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