Question

1 Approved Answer

Posted on Jul 27, 2024

We will calculate financial ratios for the Dover Corporation (stock symbol DOV) in this Excel case. Please see the instructions on the first tab of

We will calculate financial ratios for the Dover Corporation (stock symbol DOV) in this Excel case. Please see the instructions on the first tab of the attached spreadsheet. You will complete your work on the second tab. You must use cell references in Excel for your calculations. Do not do your calculations outside of Excel and input values. The work in this case relates to material in Chapter 3. You can make two submissions for this assignment. I will only grade the second submission if you do this. Let me know what questions you have. Here is a profile of the company: Dover Corporation provides equipment and components, consumable supplies, aftermarket parts, software and digital solutions, and support services worldwide. The company's Engineered Products segment provides various equipment, component, software, solution, and services that are used in aftermarket vehicle service, solid waste handling, industrial automation, aerospace and defense, industrial winch and hoist, and fluid dispensing end-market. This segment also offers manual and power clamp, rotary and linear mechanical indexer, conveyor, pick and place unit, glove port, and manipulator, as well as end-of-arm robotic gripper, slide, and end effector. Its Clean Energy \& Fueling segment offers component, equipment, and software and service solution enabling safe transport of traditional and clean fuel, and other hazardous substance along with supply chain, as well as operation of convenience retail, retail fueling, and vehicle wash establishment. The company's Imaging \& Identification segment provides precision marking and coding: packaging intelligence; product traceability equipment; brand protection; and digital textile printing equipment, as well as related consumable, software, and service to packaged and consumer good, pharmaceutical, indystrial manufacturing, fashion and apparel, and other endmarket. Its Pumps \& Process Solutions segment manufactures specialty pump, connector, and flow meter, fluid connecting solution, plastics and polymer processing equipment, and engineered components for rotating and reciprocating machines. The company's Climate \& Sustainability Technologies segment manufactures refrigeration system, refrigeration display case, commercial glass refrigerator and freezer door, and brazed plate heat exchanger for industrial heating and cooling, and residential climate control applications. It sells its products directly and through a network of distributors. The company was incorporated in 1947 and is headquartered in Downers Grove, Illinois: Subtotal. 3.00 15.00 18.00 Other points available. Filename format (example: Excel Case 1 MGwinn 01W) Excel Case 1 FirstinitialLastnamesectionnumber Submitted ontimethrough Blackboard 1.00 Total 20,00 DCVERCORP (pOV) BALANCE SHLET Fiscal year ends in December. USO in millions 202212 202112 202012 201912 2018-12 Aasets Current assets Cash and carh ecuivalents fieceivables Inventorie Dederredincometanes Prepald epenses Total current amets Non-current anset: Property, plant and equipment Aceumulated Depreciation Goodwill intanc ble aciest Other loneterm assets Total non-current assets Total anets Labilities Curtent liabilies Gentermidebt Acceunta pyrable Taxes pwyble Acerved liabilisies Defmred revinuies. Oter culient liabilities Total current liabalilier Non curreat liabilitiet tongterm stebt Deleried tute liabilitie Neryed labelitin other iond tern liabisities. Tota nonsurrent liabilities Teta tianiliet 38 Stockholders' equity 39 Coenmon stock 40 Additional paid an capital Aetained edrnines Treasury steck Total stockholders' equity \begin{tabular}{|l|r|} \hline 259 & 259 \\ 868 & 858 \\ 9,957 & 9,293 \\ (6,797) & (5,219) \\ 4,2187 & 4,191 \\ & \\ 10,1197 & 10,404 \end{tabular} Totar liabiilies and ntockholders equity \begin{tabular}{|r|r|r|r|r|} \hline 259 & 259 & 259 & 259 & 258 \\ 868 & 858 & 869 & 870 & 886 \\ 9,957 & 9,293 & 8,455 & 8,211 & 7,816 \\ (6,797) & (5,219) & (6,197) & (6,307) & (6,190) \\ 4,217 & 4,191 & 3,386 & 3,033 & 2,770 \\ & & & & \\ 16,4197 & 10,404 & 9,152 & 8,659 & 8,365 \end{tabular} We will calculate financial ratios for the Dover Corporation (stock symbol DOV) in this Excel case. Please see the instructions on the first tab of the attached spreadsheet. You will complete your work on the second tab. You must use cell references in Excel for your calculations. Do not do your calculations outside of Excel and input values. The work in this case relates to material in Chapter 3. You can make two submissions for this assignment. I will only grade the second submission if you do this. Let me know what questions you have. Here is a profile of the company: Dover Corporation provides equipment and components, consumable supplies, aftermarket parts, software and digital solutions, and support services worldwide. The company's Engineered Products segment provides various equipment, component, software, solution, and services that are used in aftermarket vehicle service, solid waste handling, industrial automation, aerospace and defense, industrial winch and hoist, and fluid dispensing end-market. This segment also offers manual and power clamp, rotary and linear mechanical indexer, conveyor, pick and place unit, glove port, and manipulator, as well as end-of-arm robotic gripper, slide, and end effector. Its Clean Energy \& Fueling segment offers component, equipment, and software and service solution enabling safe transport of traditional and clean fuel, and other hazardous substance along with supply chain, as well as operation of convenience retail, retail fueling, and vehicle wash establishment. The company's Imaging \& Identification segment provides precision marking and coding: packaging intelligence; product traceability equipment; brand protection; and digital textile printing equipment, as well as related consumable, software, and service to packaged and consumer good, pharmaceutical, indystrial manufacturing, fashion and apparel, and other endmarket. Its Pumps \& Process Solutions segment manufactures specialty pump, connector, and flow meter, fluid connecting solution, plastics and polymer processing equipment, and engineered components for rotating and reciprocating machines. The company's Climate \& Sustainability Technologies segment manufactures refrigeration system, refrigeration display case, commercial glass refrigerator and freezer door, and brazed plate heat exchanger for industrial heating and cooling, and residential climate control applications. It sells its products directly and through a network of distributors. The company was incorporated in 1947 and is headquartered in Downers Grove, Illinois: Subtotal. 3.00 15.00 18.00 Other points available. Filename format (example: Excel Case 1 MGwinn 01W) Excel Case 1 FirstinitialLastnamesectionnumber Submitted ontimethrough Blackboard 1.00 Total 20,00 DCVERCORP (pOV) BALANCE SHLET Fiscal year ends in December. USO in millions 202212 202112 202012 201912 2018-12 Aasets Current assets Cash and carh ecuivalents fieceivables Inventorie Dederredincometanes Prepald epenses Total current amets Non-current anset: Property, plant and equipment Aceumulated Depreciation Goodwill intanc ble aciest Other loneterm assets Total non-current assets Total anets Labilities Curtent liabilies Gentermidebt Acceunta pyrable Taxes pwyble Acerved liabilisies Defmred revinuies. Oter culient liabilities Total current liabalilier Non curreat liabilitiet tongterm stebt Deleried tute liabilitie Neryed labelitin other iond tern liabisities. Tota nonsurrent liabilities Teta tianiliet 38 Stockholders' equity 39 Coenmon stock 40 Additional paid an capital Aetained edrnines Treasury steck Total stockholders' equity \begin{tabular}{|l|r|} \hline 259 & 259 \\ 868 & 858 \\ 9,957 & 9,293 \\ (6,797) & (5,219) \\ 4,2187 & 4,191 \\ & \\ 10,1197 & 10,404 \end{tabular} Totar liabiilies and ntockholders equity \begin{tabular}{|r|r|r|r|r|} \hline 259 & 259 & 259 & 259 & 258 \\ 868 & 858 & 869 & 870 & 886 \\ 9,957 & 9,293 & 8,455 & 8,211 & 7,816 \\ (6,797) & (5,219) & (6,197) & (6,307) & (6,190) \\ 4,217 & 4,191 & 3,386 & 3,033 & 2,770 \\ & & & & \\ 16,4197 & 10,404 & 9,152 & 8,659 & 8,365 \end{tabular}