Please show work. Need help on #3 - #15 on the last picture. All information I have is in pictures.

Excel Case \#1 - Analysis of Dover Corporation (DOV) all answers should be denoted on the DOV Financial Stmts worksheet, below the income statements Use the formulas in Table 3.5 Points available 4 Calculate the following for each of the five most recent years: Correct Correct format calculations Total \begin{tabular}{|l|l|l|l|} \hline 6 & 1 & Net Working Capital & format: currency, 0 decimal places \\ \hline 7 & & & \\ \hline 8 & 2 & Capital Structure (debt \%) & format: percentage, 0 decimal places \\ \hline \end{tabular} 0.20 format: percentage, 0 decimal places format: currency, 0 decimal places 4 Current Ratio format: number, 2 decimal places 5 Times Interest Earned format: number, 2 decimal places 6 Inventory Turnover format: number, 2 decimal places 7 Days' Sales in Inventory 8 Receivables Turnover 9 Days' Sales in Receivables 10 Total Asset Turnover 11 Profit Margin 12 Return on Assets 13 Return on Equity 14 Price-earnings ratio 15 Gross Margin \% = Gross Profit / Revenue format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: percentage, 2 decimal places format: percentage, 2 decimal places format: percentage, 2 decimal places format: number, 2 decimal places format: percentage, 2 decimal places G I K 0.10 0.10 1.00 0.50 0.50 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.00 0.20 1.20 0.600 0.600 1.20 1.20 1.20 1.20 1.20 1.20 1.20 1.20 1.20 1.20 0.20 0.20 1.00 1.00 = 1.20 1.20 1.20 1.20