Answered step by step
Verified Expert Solution
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
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
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