Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Industry 2400, Delete any companies with missing data for AT, SALE, IB Using Your industry (from question title), please answer these questions using the Fiscal

image text in transcribed

Industry 2400, Delete any companies with missing data for AT, SALE, IB

Using Your industry (from question title), please answer these questions using the Fiscal year 2015 data, use Total Assets (AT) foraverage investment, Income Before Extraordinary Items (IB) for income, and Sales/Turnover (Net) (SALE) for Sales Revenue

What is the average Sales Margin for your industry?Answer in percentage, to the nearest hundredth of a percent, without the % sign, for example 3.45 for 3.45%, 0.45 for 0.45%

What is the average Turnover for your industryAnswer to the nearest hundredth

What is the average Return on Investment for your industryAnswer in percentage, to the nearest hundredth of a percent, without the % sign, for example 3.45 for 3.45%

Which company (use Global Company Key) has the highest ROI in your Industry?Answer with no leading zeros using the appropriate number of digits

image text in transcribedimage text in transcribed
A B C D E F G H Global Company Key Data Date Data Year - Fiscal Ticker Symbol Company Name Assets - Total Income Before Extraordinary Items Sales/Turnover (Net) Standard Industry Classification Code IN 006821 12/31/15 2015 LPX LOUISIANA-PACIFIC CORP 2176.3 -86 1892.5 2400 006821 12/31/15 2015 LPX LOUISIANA-PACIFIC CORP 2176.3 86 1892.5 2400 011456 12/31/15 2015 WY WEYERHAEUSER CO 12486 506 7082 2400 5 011456 12/31/15 2015 WY WEYERHAEUSER CO 12470 411 5246 2400 6 012368 12/31/15 2015 SVCBY SCA-SVENSKA CELLULOSA 18035.391 828.786 13649.287 2400 7 014042 12/31/15 2015 CFPZF CANFOR CORP 3294.6 24.7 3925.3 2400 8 014042 12/31/15 2015 CFPZF CANFOR CORP 3294.6 24.7 3925.3 2400 9 014313 12/31/15 2015 OSB NORBORD INC 1635 -56 1509 2400 10 014313 12/31/15 2015 OSB NORBORD INC 1633 -56 1509 2400 11 015709 12/31/15 2015 PCL PLUM CREEK TIMBER CO IN 4990 197 1445 2400 12 015709 12/31/15 2015 PCL PLUM CREEK TIMBER CO IN 4990 197 1445 2400 13 018724 12/31/15 2015 KEWL KEWEENAW LAND ASSN LT 25.069 1.156 11.348 2400 14 023296 12/31/15 2015 EVA ENVIVA PARTNERS LP 688.209 20.422 457.374 2400 15 023296 12/31/15 2015 EVA ENVIVA PARTNERS LP 574.547 23.174 457.374 2400 16 023898 12/31/15 2015 RTKHO RENTECH INC 650.291 61.161 156.457 2400 17 023898 12/31/15 2015 RTKHQ. RENTECH INC 650.291 -144.207 295.844 2400 18 026950 9/30/15 2015 WY.P WEYERHAEUSER CO-PROF 24635 476 6427 2400 19 030421 12/31/15 2015 STLJF STELLA-JONES INC 2400 20 030421 12/31/15 2015 STUJF STELLA-JONES INC 1776.218 141.377 1559.334 2400 21 119316 12/31/15 2015 TREX TREX CO INC 211.998 48.098 440.804 2400 22 119316 12/31/15 2015 TREX TREX CO INC 211.998 48.098 440.804 2400 23 165981 12/31/15 2015 ACAZF ACADIAN TIMBER CORP 449.778 13.641 84.422 2400 24 175078 12/31/15 2015 CFPUF CANFOR PULP PRODUCTS 841.3 106.6 1174.7 2400 25 175078 12/31/15 2015 CFPUF CANFOR PULP PRODUCTS 841.3 106.6 1174.7 2400 26 183901 6/30/15 2015 ECOB ECO BUILDING PRODUCTS 0.863 2.09 2400 27 183901 6/30/15 2015 ECOB ECO BUILDING PRODUCTS 0.88 0.316 2.09 2400 28 185051 12/31/15 2015 CFXTF CONIFEX TIMBER INC 332.098 -17.321 353.467 2400 29Industry 2400, Delete any companies with missing data for AT, SALE, IB Using Your industry (from question title), please answer these questions using Fiscal year 2015 data, use Total Assets (AT) for average investment, Income Before Extraordinary Items (IB) for income, and Sales/Turnover (Net) (SALE) for Sales Revenue What is the average Sales Margin for your industry? Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45%, 0.45 for 0.45% What is the average Turnover for your industry Answer to the nearest hundredth What is the average Return on Investment for your industry Answer in percentage, to the nearest hundredth of a percent, without the % sign, example 3.45 for 3.45% Which company (use Global Company Key) has the highest ROI in your Industry? Answer with no leading zeros using the appropriate number of digits

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

Accounting Principles Volume 2

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

8th Canadian Edition

1119502551, 1-119-50255-5, 978-1119502555

More Books

Students also viewed these Accounting questions

Question

Effort (person-hours) required to make the change, Wchange.

Answered: 1 week ago

Question

The number of new ideas that emerge

Answered: 1 week ago

Question

Technology

Answered: 1 week ago