Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is all the data I got, where I can find other date? I tried to use compustat to find income date but I couldn't
this is all the data I got, where I can find other date? I tried to use compustat to find income date but I couldn't reach it because it limits for business only, so what should I do to get income data before I even start this question.
on 2015 Data obtained from WRDS: The attached file is based 1. Calculate the following: Sales Net Sales: Income =Income before extraordinary items: Assets Total Assets Margin Income/Sales b. Turnover Sales/Assets a. - Return on Investment = Income/Assets = ROI c. 2. Calculate the averages for the ab. & c. above. Use average function for the column 3. Find the company with the highest ROI. Using the ticker symbol and Yahoo Finance Provide a summary including the following in a text box within the Excel file: Give the company name and ticker symbol a. b. 2015 ROI Current or most Recent CEO d. Current or most recent address for company quarters C. P R T V X Standard Industry Global Company Sales/Turnover |(Net) 183901 119316 175078 30421 18724 Classification Code 2.09 1 Key Margin Turnover ROI 2400 440.804 2400 1174.7 2400 1559.334 2400 2400 2400 6 11.348 12368 13649.287 8 11456 7082 2400 9 23296 457.374 2400 15709 1445 10 2400 11 165981 84.422 2400 14042 14313 12 3925.3 2400 1509 13 2400 6821 14 1892.5 2400 15 185051 353.467 2400 23898 295,844 16 2400 17 Average: 18 19 20 21 22 23 24 25 26 27 WRDS +) on 2015 Data obtained from WRDS: The attached file is based 1. Calculate the following: Sales Net Sales: Income =Income before extraordinary items: Assets Total Assets Margin Income/Sales b. Turnover Sales/Assets a. - Return on Investment = Income/Assets = ROI c. 2. Calculate the averages for the ab. & c. above. Use average function for the column 3. Find the company with the highest ROI. Using the ticker symbol and Yahoo Finance Provide a summary including the following in a text box within the Excel file: Give the company name and ticker symbol a. b. 2015 ROI Current or most Recent CEO d. Current or most recent address for company quarters C. P R T V X Standard Industry Global Company Sales/Turnover |(Net) 183901 119316 175078 30421 18724 Classification Code 2.09 1 Key Margin Turnover ROI 2400 440.804 2400 1174.7 2400 1559.334 2400 2400 2400 6 11.348 12368 13649.287 8 11456 7082 2400 9 23296 457.374 2400 15709 1445 10 2400 11 165981 84.422 2400 14042 14313 12 3925.3 2400 1509 13 2400 6821 14 1892.5 2400 15 185051 353.467 2400 23898 295,844 16 2400 17 Average: 18 19 20 21 22 23 24 25 26 27 WRDS +)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