Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Population Source Level of Consolidation - Company Annual Descript Data Format STD STD STD ISO Currency Code USD USD USD CAD STD USD Global Company

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Population Source Level of Consolidation - Company Annual Descript Data Format STD STD STD ISO Currency Code USD USD USD CAD STD USD Global Company Key Data Date Data Year - Fisca Industry Forn 6821 20151231 2015 INDL 11456 20151231 2015 INDL 12368 20151231 2015 INDL 14042 20151231 2015 INDL 14313 20151231 2015 INDL 15709 20151231 2015 INDL 18724 20151231 2015 INDL 23296 20151231 2015 INDL 23898 20151231 2015 INDL 30421 20151231 2015 INDL 119316 20151231 2015 INDL 165981 20151231 2015 INDL 175078 20151231 2015 INDL 183901 20150630 2015 INDL 185051 20151231 2015 INDL uuuuuuuuuuuuuu STD STD STD STD STD Ticker Symbol LPX WY SVCBY CFPZF OSB PCL KEWL EVA RTKHQ STLJF TREX ACAZE CFPUF ECOB CFXTE Company Name LOUISIANA-PACIFIC CORP WEYERHAEUSER CO SCA-SVENSKA CELLULOSA AB CANFOR CORP NORBORD INC PLUM CREEK TIMBER CO INC KEWEENAW LAND ASSN LTD ENVIVA PARTNERS LP RENTECH INC STELLA-JONES INC TREX COINC ACADIAN TIMBER CORP CANFOR PULP PRODUCTS INC ECO BUILDING PRODUCTS INC CONIFEX TIMBER INC STD USD USD USD USD CAD USD CAD CAD USD CAD STD STD STD STD D STD -86 Income Before Extraordinary Assets - Tot Items Sales/Turnover (NeActive/Inactive Status Marke 2176.3 1892.5 A 12486 506 7082 A 18035.391 828.786 13649.287 A 3294.6 24.7 3925.3 A 1633 -56 1509 A 4990 197 1445 25.069 1.156 11.348 A 574.547 23.174 457.374 A 650.291 -144.207 295.844 1776.218 141.377 1559.334 A 211.998 48.098 440.804 A 449.778 13.641 84.422 A 841.3 106.6 1174.7 A 0.88 0.316 2.09 332.098 -17.321 353.467 A Standard Industry Classification Cod 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 QUESTION 1 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 nearest hundredth of a percent, without What is the average Return on Investment for your industry the % sign, example 3.45 for 3.45% Which company (use Global Company Key) has the highest ROI in your Industry? number of digits Answer with no leading zeros using the appropriate You need to calculate the Margin, Turnover, Rol for EACH company in your sample. Also calculate the average of margin, turnover, and ROI using the individual company values. Use the sort function to determine the company with the highest ROI. Answer the questions, paying careful attention to the instructions on the number of digits, etc. 4.6 and 4.60 are not the same to the system... follow instructions! NOTE: Average Margin is the sum of the Margin for each company divided by the number of companies, NOT the sum of income divided by the sum of sales.... They are not the same! Population Source Level of Consolidation - Company Annual Descript Data Format STD STD STD ISO Currency Code USD USD USD CAD STD USD Global Company Key Data Date Data Year - Fisca Industry Forn 6821 20151231 2015 INDL 11456 20151231 2015 INDL 12368 20151231 2015 INDL 14042 20151231 2015 INDL 14313 20151231 2015 INDL 15709 20151231 2015 INDL 18724 20151231 2015 INDL 23296 20151231 2015 INDL 23898 20151231 2015 INDL 30421 20151231 2015 INDL 119316 20151231 2015 INDL 165981 20151231 2015 INDL 175078 20151231 2015 INDL 183901 20150630 2015 INDL 185051 20151231 2015 INDL uuuuuuuuuuuuuu STD STD STD STD STD Ticker Symbol LPX WY SVCBY CFPZF OSB PCL KEWL EVA RTKHQ STLJF TREX ACAZE CFPUF ECOB CFXTE Company Name LOUISIANA-PACIFIC CORP WEYERHAEUSER CO SCA-SVENSKA CELLULOSA AB CANFOR CORP NORBORD INC PLUM CREEK TIMBER CO INC KEWEENAW LAND ASSN LTD ENVIVA PARTNERS LP RENTECH INC STELLA-JONES INC TREX COINC ACADIAN TIMBER CORP CANFOR PULP PRODUCTS INC ECO BUILDING PRODUCTS INC CONIFEX TIMBER INC STD USD USD USD USD CAD USD CAD CAD USD CAD STD STD STD STD D STD -86 Income Before Extraordinary Assets - Tot Items Sales/Turnover (NeActive/Inactive Status Marke 2176.3 1892.5 A 12486 506 7082 A 18035.391 828.786 13649.287 A 3294.6 24.7 3925.3 A 1633 -56 1509 A 4990 197 1445 25.069 1.156 11.348 A 574.547 23.174 457.374 A 650.291 -144.207 295.844 1776.218 141.377 1559.334 A 211.998 48.098 440.804 A 449.778 13.641 84.422 A 841.3 106.6 1174.7 A 0.88 0.316 2.09 332.098 -17.321 353.467 A Standard Industry Classification Cod 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 2400 QUESTION 1 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 nearest hundredth of a percent, without What is the average Return on Investment for your industry the % sign, example 3.45 for 3.45% Which company (use Global Company Key) has the highest ROI in your Industry? number of digits Answer with no leading zeros using the appropriate You need to calculate the Margin, Turnover, Rol for EACH company in your sample. Also calculate the average of margin, turnover, and ROI using the individual company values. Use the sort function to determine the company with the highest ROI. Answer the questions, paying careful attention to the instructions on the number of digits, etc. 4.6 and 4.60 are not the same to the system... follow instructions! NOTE: Average Margin is the sum of the Margin for each company divided by the number of companies, NOT the sum of income divided by the sum of sales.... They are not the same

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_2

Step: 3

blur-text-image_3

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

Warren Buffett Accounting Book Reading Financial Statements For Value Investing

Authors: Stig Brodersen, Preston Pysh

1st Edition

1939370159, 9781939370150

More Books

Students also viewed these Accounting questions

Question

THE QUESTION 1 THE QUESTION 1

Answered: 1 week ago

Question

Understand the purpose and methods of cross-cultural training

Answered: 1 week ago