Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction To Concepts Methods And Uses

Authors: Clyde P. Stickney, Roman L. Weil

12th Edition

0324381980, 978-0324381986

More Books

Students also viewed these Accounting questions

Question

3. Experiment with cooperative learning activities.

Answered: 1 week ago