Excel Crash Course Exam from Wall Street Prep - EXAMINATION COMPLETE QUESTIONS AND DETAILED SOLUTIONS LATEST UPDATE THIS YEAR JUST RELEASED

Excel Crash Course Exam from Wall Street Prep - EXAMINATION
COMPLETE QUESTIONS AND DETAILED SOLUTIONS LATEST UPDATE THIS
YEAR JUST RELEASED



Question 1: What is forecast Revenue in 2017?
Answer:

13,642,021


Question 2: What is forecast Net Income in 2016?
Answer:

925,777


Question 3: If Depreciation&Amortization; as a % of Capital
Expenditures is changed to 30%, what is Net Income in 2017?
Answer:

1,123,438


Question 4: What is the EBITDA % Margin in 2018?
Answer:

17.1%


Question 5: Over the entire analysis period, which sales rep sold
the highest cumulative quantity of a single item?
Answer:

Rob Stewart

, Question 6: 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?
Answer:

16


Question 7: Over the entire analysis period, what is the second
highest selling item code by quantity?
Answer:

39


Question 8: Over the entire analysis period, what is the highest
selling item code by quantity?
Answer:

16


Question 9: Only considering postal codes 93372, 93403 and 93434,
which postal code had the highest total profit during the month of
March?
Answer:

93372


Question 10: In the last question you determined the postal code
that had the highest total profit during the month of March. What
was the profit?
Answer:

13691.4