EXCEL

Annual Report Project Finding Data in the Annual Report 43 points Note: Do not complete cells that are shaded in gray Rockwell Automation Parker-H 2018 2017 2018 1. What is the total $ amount of sales for 2018? $ 6,666.0 14,302,392 What is the % growth or decline from 2017? (round to one decimal place; minus sign or parens for declin 5.6% 18.9% 535.5 1,060,801 What is the % growth or decline from 2017? -35.1% 7.9% 3. What is the $ amount of cash dividends paid per common share? $3.51 $3.04 $2.74 4. What % of Current Assets is made up of Cash & Cash Equivalents? 21.9% 3190.0% 16.2% 5. What is the $ amount of accumulated depreciation? 1,561.40 1,511.90 3,359,016 What is the $ amount of depreciation expense? 136.4 138.7 237,806 6. What is the $ amount of free cash flow for Rockwell Automation? 1,174.50 892.3 9. Find the Notes to the financial statements. How many are there? 18 16 10. How much Goodwill, if any, is on the books of each company? 1075.5 5,504,420 12. What non-GAAP measures are reported by Rockwell Automation? 2. What is the Net Income amount for 2018? (for PH, use attributable to common sh) 7. What is the largest source of cash from financing activities? (description and $) Net issuance of short term debt… 200.6 Proceeds from the exersize of stock options… 181.9 proceeds from notes payable net…4,115 8. What is the largest use of cash in investing activities? (description and $) Purchases of investment… 1,296.9 Purchases of investments… 1,444.2 capital expenditures… $247,667 11. How many business operating segments does each company have? What are the names of those segments 2 businesses, architecture and software, and control products and solutions. 2 diversified industrial aerospace systems Oranic sales,total segment operating earnings and margin, adjustment income, adjustment EPS, adjusted effective tax return, and free cash flow.

13. Name two of the risks discussed by each company in the MD&A section foreign currency risk and internal rate risk. interest rate risk and foreign transaction and transaction risk

Annual Report Project Ratio Analysis 55 points Important Notes: 1. Enter all data needed for calculations on the tab "Financial Data for Ratios". For all calculations, you must use cell references on this page to link to the financial data. 2. Calculate to 1 decimal, except 2 decimals for Current Ratio. Show answer as a percentage where that is normal way to state the metric. 3. Format cells as needed. 4. For PH Net Income, use Net Income Attributable to Common Shareholders 5. If a 2016 figure is missing that you need for a calculation of a 2017 average amount, use the 2017 figure for the average. 6. For the trend, indicate whether 2018 is favorable (i.e., better) or unfavorable (i.e., worse) compared to 2017. Remember, an increase is not always favorable. Rockwell Automation Parker-Hannifin 2018 2017 Trend 2018 2017 Trend Liquidity Analysis Current Ratio 1.07 2.06 worse 1.59 1.41 better Accounts Receivable Turnover 5.7 5.6 better 7.0 6.2 better Average Collection Period 63.7 65.7 better 52.0 58.6 better Inventory Turnover 6.7 6.6 better 6.8 5.9 better Days in Inventory 54.9 55.3 worse 53.8 61.5 better Solvency Analysis Debt to Assets Ratio 74.2% 62.8% worse 61.7% 66.0% better Times Interest Earned 19.2 14.6 better 9.0 9.2 worse Profitability Analysis Gross Profit Rate 43.1% 41.6% better 24.7% 23.6% better Profit Margin 8.0% 13.1% worse 7.4% 8.2% worse Asset Turnover 0.99 0.88 better 0.93 0.78 better Return on Assets 8.0% 3.0% worse 6.9% 6.3% better

Rockwell Automation Parker-H 2018 2017 2018 Current Assets 2390.7 4420.7 5,085,238 Total Assets 6262.0 7161.7 15,320,087 Ave Total Assets 6711.9 7161.7 15,404,996 Trade Accounts Receivable 1190.1 1135.5 2,145,517 Ave Net AR 1162.8 1135.5 2,038,134 Inventories 581.6 558.7 1,621,304 Ave Inventories 570.2 558.7 1,585,399 Current Liabilities 2236.9 2145.8 3,197,594 Total Liabilities 4644.5 4498.1 9,454,594 Net Sales 6666.0 6311.3 14,302,392 Cost of Good Sold 3793.8 3687.1 10,762,841 Net Income 535.5 825.7 1,060,801 Interest Exp 73.0 76.2 213,873 Income Tax Exp 795.3 211.7 640,962

Trend Analysis for Rockwell Automation 20 points 1. Enter income statement amounts. 2. Express each item from 2017 and 2018 as a % of the base year, 2016. Round percentages to one decimal 3. Answer the two questions at the bottom. / Rockwell Automation Consolidated Statement of Operations Trend An $ in Millions 2016 2017 2018 2017 Net Sales 5879.5 6311.30 6666 7.34% Cost of Sales $ 3,404.0 $ 3,687.10 3793.8 8.3% Gross Profit 2,475.5 2624.2 2872.2 10.0% Selling, general and administrative expense 1,467.4 1591.5 1599 8.5% Other income 6.3 80.9 130.6 1184.1% Interest expense 71.3 76.2 73 6.9% Income before income taxes 943.1 1037.4 1330.8 10.0% Income tax provision 213.4 211.7 795.3 0.8% Net Income 729.7 825.7 535.5 13.2% Questions: 1. By what percentage did net sales change from 2016 to 2017? (be sure to indicate whether increase or dec Net sales increased by 7,3% 2. By what percentage did net income change from 2016 to 2017? (be sure to indicate whether increase or d The net income increased by 13.2%

point. nalysis 2018 5.62% 11.5% 16.0% 8.9% 1973.0% 2.3% 41.1% 273.0% 26.6% crease) decrease)