H K L M C D TULET CESULTATS UFUUWr corpUGOTOVI wil answers should be denoted on the DOV Financial Stmts worksheet, below the income statements Use the formulasin Table 3.5 Points available Calculate the following for each of the six most recent years. Correct format Correct calculation Total 1 Net Working Capital format currency. O decimal places 0.20 1.00 1.20 2 Capital Structure idet Capital Soucture equity format percentage decimal format percentage, decimal places 0.600 0.100 0100 0.50 0.50 0.600 3 Operatine Cash Flow format currency. O decimal places 0.20 1.00 120 4 Current Ratio format number 2 decimal places 0.20 1.00 120 10 11 12 13 14 15 16 17 18 5 Times Interest Eamed format number, 2 decimal places 0.20 1.00 120 6 Inventory Turnover 0:20 1.00 1 20 format number, 2 decimal places format number, 2 decimal places 7 Days Sales in Inventory 0.20 1.00 120 B Receivables Tumover Format number, 2 decimal places 0.20 1.00 1.20 5 Days' Sales in Receivables format number, 2 decimal 0.20 1.00 1.20 10 Total Asset Tumover Format number, 2 decimal places 0.20 1.00 120 11 Profit Margin format percentage 2 decimal places 1.00 0.20 1 20 20 21 22 23 24 25 26 27 28 29 10 31 32 33 34 35 35 97 12 0.20 format percentage 2 decimal places 1.00 120 Return on Assets 0.20 1.00 1 20 11 Resumon Equity format percentage decimal places 0.20 1.00 120 tomat number, 2 decimal places 14 Pricemingsrutin 0.20 1.00 1. 20 15 Gross Margin-Gross Prof/ Revenue format percentage decimal places 1.00 15.00 18 00 Subtotal Other points available 1.00 Fename format esample Excelle1 Dover Mowinnow ExcelCase 1 Doverlastname sectionumber 19 40 41 42 42 44 45 46 1.00 Submited online through Blackboard Total 20.00 DOVER CORP (OV) BALANCE SHEET Fhcal year ends in December. USD in millions 2020-12 2019-12 2018-12 2017-12 2016-12 2015-12 513 1,137 836 133 2,619 3 397 1,217 806 128 2,548 396 1,232 749 754 1,386 879 189 3,208 349 1,265 870 104 2,588 362 1,120 803 115 2,420 127 2,504 0 1 2 3 4 5 .6 -7 -8 19 20 1 22 23 Assets Current assets Cash and cash equivalents Receivables Inventories Prepaid expenses Total current assets Non-current assets Property, plant and equipment Accumulated Depreciation Goodwin Intangible assets Other long-term assets Total non-current assets Total assets 2403 (1.506) 4,073 1,084 479 6,533 9,152 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 1610 249 7,450 10,658 2469 (1,523) 4,563 1,803 216 7,528 10,116 2,374 (1,520) 3,738 1413 194 6,199 8,619 854 18 338 185 85 983 54 242 40 346 1,750 Liabilities Current abilities Short-term debt Accounts payable Taxes payable Accrued liabilities Deferred revenues Other current liabilities Total current liabilities Non-current abilities Long-term debt Deferred taxes liabilities Accrued liabilities Other long-term liabilities Total non-current liabilities Total liabilities 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 344 1,739 2,617 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 576 3.109 298 50 570 4,027 5,766 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 30 189 3,412 4,975 Stockholders' equity Common stock Additional paid in capital Retained eamings Treasury stock Total stockholders' equity 259 869 8,608 (6,350) 3,386 259 870 8,211 (6,307) 3,033 258 886 7816 (6,190) 2,770 257 942 8,456 (5,272) 4,383 257 947 7,927 (5,332) 3,799 256 928 7,687 (5,227) 3,644 Total liabilities and stockholders' equity 9,152 8,669 8,366 10,658 8,619 10,116 43 44 45 46 DOVER CORP (DOV) INCOME STATEMENT Focal year ends in December. USD in milion except per share data 2020-12 2019-12 2016-12 2017-12 2016-12 2015-12 46 47 &B 49 50 51 52 53 54 55 56 57 58 59 GO 61 62 63 64 65 66 67 68 69 Revenue (Sales) Cost of revenue Cost of good old Gross proth Sales, general and administrative Operating income Interest Expense Other Income (expense) Income before taxes Provision for income taxes Net income 6,684 4210 2,474 1.541 933 112 21 842 158 684 7.16 4515 2,01 1.646 925 126 16) 143 165 678 6. 4413 2.50 1,716 843 131 18 725 134 591 7,810 4,940 2,00 1916 914 145 205 974 162 812 794 4322 2,472 1.758 714 136 111 689 180 500 6.946 43 2.568 14 921 132 12 B01 205 596 Price per share Earnings per share 126 25 4.70 115.26 461 70.95 3.75 8158 5.15 60.52 3.25 49.52 5.46 1,212 1247 1.126 1191 988 1,202 EBITDA wewe 1 Cu FE 1 11 Capi denta 1 02 WE 1 KE 1 1 10.ke/ WIE OFT . 110 1 3 114 13 hi Name: Answer Key Dover Corporation (DOV) 2020-12 2019-12 2010-12 2018-12 2017-12 2016-12 2015-12 1 Net Working Capital 2 Capital Structure-debt Capital Structure-equity 3 Operating Cash Flow 4 Current Ratio 5 Times interest Eamed 6 inventory Tumover 7 Days' Sales in Inventory 8 Receivables Tumover 9 Days' Sales in Receivables 10 Total Asset Tumover 11 Profit Margin 12 Retum on Assets 13 Retum on Equity 1 2 14 Price-eamings ratio 3 4 15 Gross Margin Gross Profit/ Revenue 15 36 07
