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

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) 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, for 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, 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

Industry 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 Answer in percentage, to the What is the average Return on Investment for your industry 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? with no leading zeros using the appropriate number of digits Answer A B E F . Data Year - Fiscal 1 Global Company Key 2 2 006821 3 006821 4 011456 5 011456 6 012368 7 014042 8 014042 9 014313 10 014313 11 015709 12 015709 13 018724 14 023296 15 023296 16 023898 17 023898 18 026950 19 030421 20 030421 21 119316 22 119316 23 165981 24 175078 25 175078 26 183901 27 183901 28 185051 29 Data Date 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 9/30/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 12/31/15 6/30/15 6/30/15 12/31/15 D Ticker Symbol 2015 LPX 2015 LPX 2015 WY 2015 WY 2015 SVCBY 2015 CFPZF 2015 CFPZF 2015 OSB 2015 OSB 2015 PCL 2015 PCL 2015 KEWL 2015 EVA 2015 EVA 2015 RTKHQ 2015 RTKHQ 2015 WY.P 2015 STLJF 2015 STLJF 2015 TREX 2015 TREX 2015 ACAZE 2015 CFPUF 2015 CFPUF 2015 ECOB 2015 ECOB 2015 CFXTF Company Name Assets - Total LOUISIANA-PACIFIC CORP 2176.3 LOUISIANA-PACIFIC CORP 2176.3 WEYERHAEUSER CO 12486 WEYERHAEUSER CO 12470 SCA-SVENSKA CELLULOSA 18035.391 CANFOR CORP 3294.6 CANFOR CORP 3294.6 NORBORD INC 1635 NORBORD INC 1633 PLUM CREEK TIMBER COIN 4990 PLUM CREEK TIMBER COIN 4990 KEWEENAW LAND ASSN LT 25.069 ENVIVA PARTNERS LP 688.209 ENVIVA PARTNERS LP 574.547 RENTECH INC 650.291 RENTECH INC 650.291 WEYERHAEUSER CO-PROF 24635 STELLA-JONES INC STELLA-JONES INC 1776.218 TREX COINC 211.998 TREX COINC 211.998 ACADIAN TIMBER CORP 449.778 CANFOR PULP PRODUCTS 841.3 CANFOR PULP PRODUCTS 841.3 ECO BUILDING PRODUCTS 0.863 ECO BUILDING PRODUCTS 0.88 CONIFEX TIMBER INC 332.098 Income Before Extraordinary Items -86 -86 506 411 828.786 24.7 24.7 -56 -56 197 197 1.156 20.422 23.174 -61.161 -144.207 476 Sales/Turnover (Net) Standard Industry Classification Code 1892.5 2400 1892.5 2400 7082 3400 5246 2400 13649.287 2400 3925.32400 3925.32400 1509 2400 1509 2400 1445 2400 1445 2400 11.348 2400 457.374 2400 457.374 2400 156.457 2400 295.844 2400 6427 2400 2400 141.377 48.098 48.098 13.641 106.6 106.6 1559.334 2400 440.804 2400 440.804 2400 84.422 2400 1174.7 2400 1174.7 2400 2.09 2400 2.09 2400 353.467 2400 0.316 -17.321 20

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

Managerial Accounting Tools For Business Decision Making

Authors: Strayer University

2010th Custom Edition

0470603534, 978-0470603536

More Books

Students also viewed these Accounting questions