Scroll to the right to see the notes! IPG Photonics (IPGP) IPGP's competitors Formula "IPGP Year Ended 12/31/2017" "IPGP 2017 Results" "IPGP 2016 Results" Coherent, Inc. 9/30/2017 Results* Industry Averages LIQUIDITY measures Working Capital Current Assets - Current Liabilities $1,142,687,000 $892,519,000 Current Ratio Current Assets 8.2 3.1 2.1 Current Liabilities Quick (Acid Test) Ratio Quick Assets #DIV/0! 6.2 1.9 1.3 Current Liabilities Accounts Receivable Turnover Net Sales #DIV/0! 6.6 7.3 18.0 Average Accounts Receivable Days' Sales in Receivables Average Accounts Receivable #DIV/0! 55.6 49.9 20.3 Average Daily Sales Inventory Turnover COGS #DIV/0! 2.1 3.1 1.2 Average Inventory Days' Sales in Inventory Average Inventory #DIV/0! 178.0 117.7 304.2 Average Daily COGS SOLVENCY measures Net Assets "Total Assets - Total Liabilities" $1,557,724,000 $1,163,264,000 Debt Ratio Total Liabilities #DIV/0! 0.1 0.5 0.2 Total Assets Ratio of Liabilities to Stockholders' Equity Total Liabilities 0.0 0.1 1.0 0.4 Total Stockholders' Equity $2,022,322,000 "Ratio of Fixed Assets to Long-Term Liabilities" Fixed Assets (net) #DIV/0! 5.1 0.4 2.1 Long-Term Liabilities Times Interest Earned Income before Income Tax + Interest Expense 0.0 390.1 9.8 13.9 Interest Expense $2,583,000 PROFITABILITY measures "Gross Profit Percent (also called Gross Profit Margin)" Gross Profit #DIV/0! 54.9% 43.5% 24.6% Net Sales Markup Percent Gross Profit #DIV/0! 121.7% 77.1% 32.6% COGS "Return on Sales (also called Operating Profit Margin)" Operating Income #DIV/0! 36.2% 18.9% 26.0% Net Sales Asset Turnover Net Sales #DIV/0! 2.8 3.1 0.7 Average Long-Term Operating Assets Return on Total Assets "Net Income + Interest Expense" #DIV/0! 16.1% 13.9% 8.5% Average Total Assets Return on Stockholders' Equity Net Income 0.0% 18.5% 20.1% 13.2% Average Total Stockholders' Equity $1,789,940,000 Earnings per Share on Common Stock Net Income - Preferred Dividends $0.00 $4.91 $8.52 Weighted Avg. Shares of Common Stock Outstanding 53,495,000 Price-Earnings (P/E) Ratio Market Price per Share of Common Stock $214.13 #DIV/0! 20.1 27.6 23.6 Earnings per Share on Common Stock Dividends per Share Dividends $0.00 $0.00 $0.00 $0.40 "Weighted Avg. Shares of Common Stock Outstanding" 53,495,000 Dividend Yield Dividends per Share of Common Stock 0.0% 0.0% 0.0% 0.9% Market Price per Share of Common Stock $214.13

Calculator

SEE THE INSTRUCTIONS IN THE CANVAS MODULE BEFORE BEGINNING THIS ASSIGNMENT.

Enter the amounts you calculated for use on the Step 2 worksheet. Include all the zeros in your answers. Round your answers to the nearest dollar. Do not type commas in the numbers.

For IPG Photonic's year ended December 31, 2017:

Average Accounts Receivable $

Average Daily Sales $

Average Inventory $

Average Daily COGS $

Long-Term Liabilities $

Income before Income Taxes + Interest Expense $

Average Long-Term Operating Assets $

Average Total Assets $

Net Income - Preferred Dividends $

Enter the Results for the December 31, 2017 IPGP Photonics ratios you calculated on the Step 2 worksheet. Do not type commas in the numbers. Round all numbers to one decimal place, except dollar amounts, which should be rounded as they are shown on the worksheet (Working Capital and Net Assets to the nearest dollar and Earnings per Share and Dividends per Share to the nearest cent).

Working Capital $

Current Ratio

Quick (Acid Test) Ratio

Accounts Receivable Turnover

Days' Sales in Receivables

Inventory Turnover

Days' Sales in Inventory

Net Assets $

Debt Ratio

Ratio of Liabilities to Stockholders' Equity

Ratio of Fixed Assets to Long-Term Liabilities

Times Interest Earned

Gross Profit Percent (Gross Profit Margin) %

Markup Percent %

Return on Sales (Operating Profit Margin) %

Asset Turnover

Return on Total Assets %

Return on Stockholders' Equity %

Earnings per Share on Common Stock $

Price-Earnings (P/E) Ratio

Dividends per Share $

Dividend Yield %