Excel Crash Course Exam from Wall Street Prep

Document Content and Description Below

Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cells before answering the question below. Answers should be rounded t... o the nearest whole number, comma separating 000s, NOT written in currency format. So if the answer is $5,505,210.50, you would input 5,505,210. What is forecast Revenue in 2017? Question 2 Instructions: See question 1. What is forecast Net Income in 2016? Question 3 Instructions: See question 1. If Depreciation&Amortization as a % of Capital Expenditures is changed to 30%, what is Net Income in 2017? Question 4 Instructions: See question 1. Format your answer to this question as a percentage, rounded to one decimal place. So if your answer is 10.25%, you would input: 10.3% (include percentage sign). What is the EBITDA % Margin in 2018? Question 5 Instructions: Questions 5-19 use the data table on tab Q5-19 in the Exam Workbook. We strongly recommend you analyze this data with the aid of a pivot table. You may also benefit from adding some extra calculation columns to the dataset. Answers for numerical data should be rounded to the nearest 1 decimal, comma separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would input 10,500.7. Over the entire analysis period, which sales rep sold the highest cumulative quantity of a single item? Question 6 Instructions: See question 5. In the last question you determined the sales person who sold the highest cumulative quantity of a single item. What is the item code of that item? Question 7 Instructions: See question 5. Over the entire analysis period, what is the highest selling item code by quantity? Question 8 Instructions: See question 5. Over the entire analysis period, what is the second highest selling item code by quantity? Question 9 Instructions: See question 5. Only considering postal codes 93372, 93403 and 93434, which postal code had the highest total profit during the month of March? [Show More]

Last updated: 5 months ago

Preview 1 out of 13 pages