can someone please help me with this. the instructions for the problem is in the first screenshot. It must be done with excel formulas and cell references.

File Home Insert 51 B D E all answers should be denoted on the DOV Financial Stmts worksheet, below the income statements 3 Use the formulas in Table 3.5 format: currency, 0 decimal places format: percentage, 0 decimal places format: percentage, 0 decimal places format: currency, 0 decimal places 4 format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places Calculate the following for each of the six most recent years: 5 5 1 Net Working Capital 7 3 2 Capital Structure (debt %) Capital Structure (equity %) 0 1 3 Operating Cash Flow 2 3 Current Ratio 4 5 5 Times Interest Earned 6 7 6 Inventory Turnover 8 9 7 Days' shes in Inventory 20 21 8 Receivables Turnover 2 3 9 Days' Sales in Receivables 24 25 10 Total Asset Turnover 26 27 11 28 29 12 Return on Assets 30 81 13 Return on Equity 32 33 Price-earnings ratio 34 35 15 Gross Margin % = Gross Profit / Revenue 36 37 format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places Profit Margin format: percentage, 2 decimal places format: percentage, 2 decimal places format: percentage, 2 decimal places 14 format: number, 2 decimal places format: percentage, 2 decimal places Instructions DOV Financial Stmts Subtotal General C H F D E 2018-12 2017-12 2019-12 2016-12 2015-12 DOVER CORP (DOV) BALANCE SHEET Fiscal year ends in December. USD in millions. 2014-12 396 1,232 749 397 1,217 806 754 1,386 879 349 1,265 870 362 1.120 803 682 1,187 864 63 101 2,897 135 128 2,548 127 2,504 189 3,208 104 2,588 2,420 Assets Current assets Cash and cash equivalents Receivables Inventories Deferred income taxes Prepaid expenses Total current assets Non-current assets Property, plant and equipment Accumulated Depreciation Goodwill Intangible assets Other long-term assets Total non-current assets Total assets 2,232 (1,390) 3,783 1,055 441 5,121 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 7169 3 3 1 3 4 5 6 Liabilities Current liabilities Short-term debt Accounts payable Taxes payable Accrued liabilities Deferred revenues Other current liabilities Total current liabilities Non-current liabilities Long-term debt Deferred taxes liabilities Accrued liabilities Other long-term liabilities Total non-current liabilities Total liabilities 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 778 615 40 266 21 320 2,040 7 8 29 30 31 32 33 34 35 36 37 2,987 439 34 2,986 322 52 526 3,886 5,636 2,944 339 31 287 3,601 5,596 318 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 3,778 6,275 Instructions DOV Financial Stmts B 1 C 5,636 Total liabilities D 5,595 E 6,275 5,391 6,317 4,975 Stockholders' equity Common stock Additional paid in capital Retained earnings Treasury stock Total stockholders' equity 259 870 8,211 (6,3071 3,033 258 886 7,816 (6,190) 2,770 257 942 8,456 (5,272) 4,383 257 947 7,927 15,332) 3,799 256 928 7,687 (5,227) 3,644 256 901 7,075 (4,532) 3,700 Total liabilities and stockholders' equity 8,669 8,366 10,658 10,116 8,619 9,091 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 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 7,830 4,940 2,890 1,976 914 6,992 4,433 2,559 1,716 843 131 13 725 134 591 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 7,753 4,778 2,975 1,759 1,216 132 10 1,094 316 778 145 801 205 974 162 812 205 596 678 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 EBITDA 1,449 1,139 1,513 1,186 1,259 1,533 Answers should be denoted in the section below: Instructions DOV Financial Stmts eneral File Home Insert Draw Page Layout Formulas Data Review View Help O Search 71 Answers should be denoted in the section below: D E H Answers should be denoted in the section below: Dover Corporation (DOV) 2019-12 2018-12 2017-12 2016-12 2015-12 2014-12 1 Net Working Capital 2 Capital Structure - debt% Capital Structure-equity% 3 Operating Cash Flow 4 Current Ratio 1 5 5 Times Interest Earned 7 3 6 Inventory Turnover 7 Days' Sales in Inventory 1 8 Receivables Turnover 2 3 9 Days' Sales in Receivables 1 5 10 Total Asset Turnover b 7 11 Profit Margin 9 12 Return on Assets 50 1 13 Return on Equity 02 3 14 Price-earnings ratio 04 5 15 Gross Margin% Gross Profit/ Revenue 16 37 Instructions DOV Financial Stmts