Data_Ratios_and_Trend_Annual_Report_Project

.xlsx

School

Carthage College *

*We aren’t endorsed by this school

Course

MISC

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

8

Uploaded by MagistrateWorld5650

Report
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.
Hannifin 2017 $2.58 18.5% 3,249,456 202,868 Acquisitions… $4,069,197 proceeds from long-term borrowings… 2,614,463
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help