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

on 2015 Data obtained from WRDS: The attached file is based 1. Calculate the following: Sales Net Sales: Income =Income before extraordinary items:

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. K De H Standard Industry Global Company Key Data Year Data Dat Fiscal Income Before Extraordinary Items Sales/Turnover Ticker Assets Classification Company Name ECO BUILDING PRODUCTS IN (Net) Code Margin Symbol Total Turnove 08B 183901 20150630 2015 ECOB 0.316 2.09 2400 211 1174 175078 CANFOR PULP PRODUCTS IN STELLA-JONES INC . 2015 CEPUE 106 6 20151231 30421 20151231 2015 STUP 1776.218 141.377 1559.334 2400 6 KEWEENAW LAND ASSN LTD 11.34B 18724 20151231 2015 KEWL 25.069 1156 2400 LULOSA AB BY 1B035. 12409 28 136 MEVERHAFUSER CO 7022 wo 20151231 2015 wY 20151231 2015 EVA 574547 23.174 457374 1445 2400 9 23296 ENVIVA PARINERS LP 2100 10 15709 20151231 2015 PCL PLUM CREEK TIMBER CO INC 1990 19 CORP 165981 2015 ACAZF 449.77B 11 4LAL LN IM 1633 1509 2400 13 14313 20151231 2015 OSB NORBORD INC -56 LOUISIANA-PACIFIC CORP CONIFFX TIMBER INC 2400 14 6821 20151231 2015 LPX 2176.3 -86 1892.5 332.09B -17.321 2400 15 185051 20151231 2015 CFXTF 353.467 650.291 144207 23898 20151231 2015 RTKHQ RENTECH INC 295.044 Average: 18 19 20 21 23 24 25 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. K De H Standard Industry Global Company Key Data Year Data Dat Fiscal Income Before Extraordinary Items Sales/Turnover Ticker Assets Classification Company Name ECO BUILDING PRODUCTS IN (Net) Code Margin Symbol Total Turnove 08B 183901 20150630 2015 ECOB 0.316 2.09 2400 211 1174 175078 CANFOR PULP PRODUCTS IN STELLA-JONES INC . 2015 CEPUE 106 6 20151231 30421 20151231 2015 STUP 1776.218 141.377 1559.334 2400 6 KEWEENAW LAND ASSN LTD 11.34B 18724 20151231 2015 KEWL 25.069 1156 2400 LULOSA AB BY 1B035. 12409 28 136 MEVERHAFUSER CO 7022 wo 20151231 2015 wY 20151231 2015 EVA 574547 23.174 457374 1445 2400 9 23296 ENVIVA PARINERS LP 2100 10 15709 20151231 2015 PCL PLUM CREEK TIMBER CO INC 1990 19 CORP 165981 2015 ACAZF 449.77B 11 4LAL LN IM 1633 1509 2400 13 14313 20151231 2015 OSB NORBORD INC -56 LOUISIANA-PACIFIC CORP CONIFFX TIMBER INC 2400 14 6821 20151231 2015 LPX 2176.3 -86 1892.5 332.09B -17.321 2400 15 185051 20151231 2015 CFXTF 353.467 650.291 144207 23898 20151231 2015 RTKHQ RENTECH INC 295.044 Average: 18 19 20 21 23 24 25 27 WRDS

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!

Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but please ?cut and paste? your solutions into the...

Do you think a firm should not have any liquidity or solvency questions if it is very profitable? The financial information of ABC Inc. and the industry average of certain financial ratios are...

Please see the attached file for questions 1) Pickleball Company is considering the following investment proposal: Initial investment: Depreciable assets (straight-line) Working capital Operations...

PART ONE The financial statements of Big City News, Inc., include the following items: (Click the icon to view the financial statements.) Data Table Read the requirements. 2018 2017 2016 Requirement...

In November of 2020, Hayley and Francois Chouinard decided to open a restaurant and wine bar in McCall, Idaho, a resort town about 90 miles north of Boise. The Chouinards had been following the...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

I am going to give this one more try. On Monday I used this and got an F on my assignment. :( Please only accept if accounting is your fortay because it isn't mine. I have attached the documents...

Consider the information brought to the SEC by Harry Markopolos. Please explain the primary reasons why Mr. Markopolos believed that Madoffs fund was nothing more than a Ponzi scheme.

Find the general solution to the following systems. Distinguish between the vibrational and unstable modes. What constraints on the initial conditions ensure that the unstable modes are not excited?...

An example of a self - review threat for CPAS in business is: Serving as both the CFO of a company and member of it audit committee

Consider the function below. (If an answer does not exist, enter DNE.) h ( x ) = ( x + 1) 9 9 x 2 a) Find the inflection point b) Find the interval where the graph is concave upward c) Find the...

2. Your employee is only selling about half the items per week that he should be selling. How would you go about determining what the problem is and whether training is the solution.

1. Explain how you would apply our motivation points in developing a lecture, say, on orientation and training.

2. In the HR management course Jennifer took, the book suggested using a job instruction sheet to identify tasks performed by an employee. Should the Carter Cleaning Centers use a form like this for...