Help! I do not know how to operate excel. Chegg solvers are saying upload an excel file, but i do not know how to do so. The formulas need to be in the cells to get the answers.
C D E H 1 Answers should be denoted in the section below: 2019-12 2017-12 2018-12 Dover Corporation (DOV) 2016-12 2014-12 2015-12 16 1 Net Working Capital 7 8 2 Capital Structure-debtk 9 Capital Structure-equity 0 1 3 Operating Cash Flow 4 Current Ratio 34 35 5 Times Interest Earned 36 37 6 Inventory Turnover 7 Days' Sales in Inventory 30 31 8 Receivables Turnover 32 9 Days' Sales in Receivables 94 95 10 Total Asset Turnover 96 97 11 Profit Margin 98 99 12 Return on Assets 100 101 13 Return on Equity 102 103 14 Price earnings ratio 104 105 15 Gross Margin % = Gross Profit/Revenue 106 Instructions DOV Financial Stmts 257 942 Stockholders' equity Common stock Additional paid-in capital Retained earnings Treasury stock Total stockholders' equity 259 870 8,211 (6,307) 3,033 258 886 7,816 (6,190) 2,770 8,456 (5,272) 4,383 257 947 7,927 (5,332) 3,799 256 928 7,687 (5,227) 3,644 256 901 7,075 (4,532) 3,700 3 4 S 6 7 8,669 Total liabilities and stockholders' equity 8,366 10,658 8.619 10,116 9,091 1 DOVER CORP (DOV) INCOME STATEMENT Fiscal year ends in December. USD in millions except per share data. 2018-12 2018-12 2017-12 2016-12 2015-12 2014-12 5 6 Revenue (Sales) Cost of revenue (Cost of goods sold) Gross profit Sales, general and administrative Operating income Interest Expense Other income (expense) Income before taxes Provision for income taxes Net Income 7,136 4,515 2,621 1,646 975 126 (6) 843 165 678 6,992 4,433 2,559 1,716 843 131 13 725 134 591 7,830 4,940 2,890 1,976 914 145 205 974 162 812 6,794 4,322 2,472 1,758 714 136 111 689 180 509 6,956 4,388 2,568 1,647 921 132 12 801 205 596 7,753 4,778 2,975 1,759 1,216 132 10 1,094 316 778 9 0 1 2 3 4 5 6 7 Price per share Earnings per share 115.26 4.61 70.95 3.75 81.58 5.15 60.52 3.25 49.52 5.46 59.93 4.59 1,449 EBITDA 1,139 1,513 1,259 1,186 1,533 DOVER CORP (DOV) BALANCE SHEET Fiscal year ends in December. USD in millions. 2019-12 2018-12 2017-12 2016-12 2015-12 2014-12 397 1,217 806 396 1,232 749 754 1,386 879 349 1,265 870 362 1,120 803 682 1,187 864 63 101 2,897 128 2,548 127 2,504 189 3,208 104 2,588 135 2,420 2,232 (1,390) 3,783 1,055 441 6,121 8,669 2,139 (1,332) 3,677 1,134 244 5,862 8,366 2,603 (1,604) 4,592 1,610 249 7,450 10,658 2,469 (1,523) 4,563 1,803 216 7,528 10,116 2,374 (1,520) 3,738 1,413 194 6,199 8,619 2,291 (1,454) 3,492 1,370 495 6,194 9,091 Assets 5 Current assets 3 Cash and cash equivalents 7 Receivables 3 Inventories 9 Deferred income taxes LO Prepaid expenses 11 Total current assets 12 Non-current assets 13 Property, plant and equipment 14 Accumulated Depreciation 15 Goodwill 16 Intangible assets 17 Other long-term assets 18 Total non-current assets 19 Total assets 20 21 Liabilities 22 Current liabilities 23 Short-term debt 24 Accounts payable 25 Taxes payable 26 Accrued liabilities 27 Deferred revenues 28 Other current liabilities 29 Total current liabilities 30 Non-current liabilities 31 Long-term debt 32 Deferred taxes liabilities 33 Accrued liabilities 34 Other long-term liabilities 35 Total non-current liabilities 36 Total liabilities 37 778 515 85 983 54 242 40 346 1,750 220 970 49 297 36 423 1,995 581 979 60 313 53 511 2,497 415 830 74 305 42 471 2,137 151 651 32 241 28 460 1,563 40 266 21 320 2,040 2,986 322 52 526 3,886 5,636 2,944 339 31 287 3,601 5,596 2,987 439 34 318 3,778 6,275 3,206 710 31 233 4,180 6,317 2,617 576 30 189 3,412 4,975 2.253 564 32 502 3,351 5,391 Instructions DOV Financial Stmts + Calculate the following for each of the six most recent years: 1 Net Working Capital format: currency, 0 decimal places 2 Capital Structure (debt %) Capital Structure (equity %) format: percentage, 0 decimal places format: percentage, 0 decimal places 3 Operating Cash Flow format: currency, 0 decimal places 1 2 3 4 Current Ratio format: number, 2 decimal places 4 5 Times Interest Earned format: number, 2 decimal places 6 Inventory Turnover format: number, 2 decimal places 7 Days' Sales in Inventory format: number, 2 decimal places 8 Receivables Turnover format: number, 2 decimal places 9 Days' Sales in Receivables format: number, 2 decimal places 10 Total Asset Turnover 5 6 7 8 9 CO 1 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 format: number, 2 decimal places 11 Profit Margin format: percentage, 2 decimal places 12 Return on Assets format: percentage, 2 decimal places 13 Return on Equity format: percentage, 2 decimal places 14 Price earnings ratio format: number, 2 decimal places 15 Gross Margin % = Gross Profit/ Revenue format: percentage, 2 decimal places
