FINANCIAL LINK : https://www.sec.gov/Archives/edgar/data/1111928/000111192818000
ID: 2400994 • Letter: F
Question
FINANCIAL LINK : https://www.sec.gov/Archives/edgar/data/1111928/000111192818000034/ipgp-20171231x10k.htm#sBB98AE063457A096E358C71AC54098B3
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 times per year
Days' Sales in Receivables days
Inventory Turnover times per year
Days' Sales in Inventory days
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
ADMG 302 Final Project-Step 2 35 points Scroll to the right to see the notes! IPGP's competitors Look over this worksheet to understand what is presented in each column. Notice IPG Photonics' 12/31/2017 and IPGP Year Ended 1213112017 IPGP 2017 Coherent, Inc. Indust IPGP ry Avera12/31/2016 ratios are in the first three numerical columns Formula 913012017 Results 2016 Results ResultsA IPG Photonics closest competitor is Coherent, Inc., a company of similar size to IPGP that sells similar products and services The ratios for Coherent Inc. shown in Column G were calculated from Coherent's financial statements $1,142.687,000$892.519.000 Vorking CapitalLisbilitios In Column H, the industry averages reflect averages of all companies competing in the "Semiconductor and Other Electronic Components Manufacturing" industry Current Ratio.t Liskiii«, DIYIO! Quick (Acid Test)eick a Use the 12/31/2017 IPG Photonics financial statements in the Form 10-K filed Feb. 28, 2018 to find the data you need to calculate IPGPs 2017 mensures. If you have not already printed the financial statements, see the information in the Canvas module. Or, if you prefer, you can use the data on the "IPG Photonics Vertical and Horizontal Analysis file you completed for Step 1. To find Dividends (row 44), though, you will need to look at the financial statements (Cash Flow Statement and/or Statement of Equity) DIYIO! Ratio Accounts Receivable Turnover Moe s.lr DIYIO! 18.0 Days Sales i Receirables R.c.ie·t l. DIYIO! 55.6 49.9 20.3 Fill in the missing information in column C. Include all the zeros in each of the numbers. or 365/Acct. Rec. Tumover) Inventorg Turnover If you need help with column C, you can look at the 2016 calculations in column E for clues. Notice column E is hidden. To unhide it, you can double-click the double vertical line between columns D and Or you can select columns D through F, right-click, and click Unhide.] DIYIO! F in the column headers. Days' Sales in Inventor DIYIO! 178.0 304.2 n the PGP 2017 Results column (column D), enter formulas that calculate the first two ratios. Most o already contain formulas. After entering the data, you might want to check a few ratios with your calculator to be sure they are calculated correctly the remaining Net Assets $1,557,724,000 $1.163,264,000 Ttl Libilitiar The formatting is already set for you T-tal LisLiliti Debt Ratio DIV/0! 0.2 Several of the cells are protected (only so you will not accidentally change somethingl If you need to changeExplanation / Answer
The ratios for 2017 have been calculated as follows:
Liquidity Measures Remarks Formula IPGP Year Ended 12/31/2017 IPGP 2017 Results Working Capital Current Assets - Current Liabilities $1,555,107,000 Current Ratio Current Assets 1,754,010,000 8.8 Current Liabilities 198,903,000 Quick (Acid)Test Ratio Quick Assets 1,353,435,000 6.8 Both inventories and prepaid expenses have been deducted from total current assets to arrive at quick assets Current Liabilities 198,903,000 Accounts Receivable Turnover Ratio Net Sales 1,408,889,000 7.2 Average Accounts Receivable 196,589,500 Days Sales in Receivables 365 365 50.9 Actual value of accounts receivable turnover ratio (and not the rounded off value of 7.2) has been used in the calculation Accounts Receivable Turnover Ratio 7.2 Inventory Turnover Ratio COGS 611,978,000 2.2 Average Inventory 273,361,000 Days Sales in Inventory 365 365 163 Actual value of inventory turnover ratio (and not the rounded off value of 2.2) has been used in the calculation Inventory Turnover Ratio 2.2 Solvency Measures Net Assets Total Assets - Total Liabilities $2,022,322,000 Debt Ratio Total Liabilities 3,44,933,000 0.1 Total Assets 2,367,255,000 Ratio of Liabilities to Stockholder's Equity Total Liabilities 344,933,000 0.2 Total Stockholder's Equity 2,022,322,000 Ratio of Fixed Assets to Long Term Liabilities Fixed Assets (Net) 460,206,000 3.2 Long-Term Liabilities 146,030,000 Times Interest Earned Ratio EBIT 551,112,000 213.4 Interest expense of $2583,000 as provided in the question is taken. Interest Expense 2,583,000 Profitability Measures Gross Profit Percent Gross Profit 796,911,000 56.6% Net Sales 1,408,889,000 Markup Percent Gross Profit 796,911,000 130.2% Cost of Goods Sold 611,978,000 Return on Sales Net Income - Interest Expense 345,031,000 16.6% Interest expense of $2583,000 as provided in the question is taken. Average Total Asset 2,078,627,000 Return on Stockholder's Equity Net Income 347,614,000 19.4% Average total stockholder's equity of $1,789,940,000 as provided in the question is taken. Average Total Stockholder's Equity 1,789,940,000 Earnings Per Share on Common Stock Net Income - Preferred Dividends 347,614,000 6.5 Weighted average shares of common stock of 53,495,000 as provided in the question is taken. Weighted Average Shares of Common Stock Outstanding 53,495,000 Price-Earnings Ratio Market Price Per Share of Common Stock 214.13 32.9 Earnings Per Share on Common Stock 6.5 Dividends Per Share Dividends 0 $0.0 No dividends have been paid during the year. Weighted Average Shares of Common Stock Outstanding 53,495,000 Dividend Yield Dividends Per Share of Common Stock 0 0.0% No dividends have been paid during the year. Market Price Per Share of Common Stock 214.13Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.