Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started