Question: give information about Roper technology from factset NOTES: 1) Change the name of this excel file to your name! 2) Questions 1 to 12 are

give information about Roper technology from factset
give information about Roper technology from factset NOTES: 1) Change the name
of this excel file to your name! 2) Questions 1 to 12
are based on your assigned company (see "Assigned Company" tab of this
spreadsheet). COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Assigned

NOTES: 1) Change the name of this excel file to your name! 2) Questions 1 to 12 are based on your assigned company (see "Assigned Company" tab of this spreadsheet). COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Assigned Companies" tab of this spreadsheet. What is its name? 1b What is the stock ticker symbol for your company? 2 How many employees does the company have? 3 What percent of analysts believe it is a HOLD rating? 1 4 What was the \% Sales growth rate between the most recent FISCAL year and the year before that? 1 5 Download your company's Debt Capital Structure (DCS) Summary from the DCS Overview into a new excel spreadsheet then copy it's contents into the "Insert 1" tab of this spreadsheet. 1 6 Go to the RATINGS section and take a screenshot showing the Long Term debt rating for your Company 1 7 How much did your company spend on capital expenditures in its most recently reported FISCAL year? (Give your answer in \$ Millions eg. \$2,000,000 would be "2") 1 8. What is the most recently reported 12 months of EBIT? (Give your answer in S Millions) 1 SMillions 1 S Millions 9 Name the top 5 comparable companies (use Source = Factset Peer Group) 1 What is the Long Term debt rating for your Company 1 ? Take a screenshot and put it in the "Insert 2 " tab of this spreadsheet. NOTES: 1) Change the name of this excel file to your name! 2) Questions 1 to 12 are based on your assigned company (see "Assigned Company" tab of this spreadsheet). COMPANY/SECURITY TAB: 1a Look up your assigned company in the "Assigned Companies" tab of this spreadsheet. What is its name? 1b What is the stock ticker symbol for your company? 2 How many employees does the company have? 3 What percent of analysts believe it is a HOLD rating? 1 4 What was the \% Sales growth rate between the most recent FISCAL year and the year before that? 1 5 Download your company's Debt Capital Structure (DCS) Summary from the DCS Overview into a new excel spreadsheet then copy it's contents into the "Insert 1" tab of this spreadsheet. 1 6 Go to the RATINGS section and take a screenshot showing the Long Term debt rating for your Company and paste it into the "Insert 2 " tab of this spreadsheet. 1 7 How much did your company spend on capital expenditures in its most recently reported FISCAL year? (Give your answer in \$ Millions eg. \$2,000,000 would be " 2" ") 1 8. What is the most recently reported 12 months of EBIT? (Give your answer in $ Millions) 1 SMillions 1 5 Mitlions 9 Name the top 5 comparable companies (use Source = Factset Peer Group) 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!