Excel Crash Course Exam from Wall
Street Prep - Wall Street Prep
Questions And Answers Updated 2024
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the
n n n n n n n n n n n
n Exam Workbook. Complete the model by filling in the blank cells before
n n n n n n n n n n n
n answering the question below. Answers should be rounded to the nearest
n n n n n n n n n n
n whole number, comma separating 000s, NOT written in currency format.
n n n n n n n n n
n So if the answer is $5,505,210.50, you would input 5,505,210.
n n n n n n n n n
1. What is forecast Revenue in 2017? 13,642,021
n n n n n n
2. What is forecast Net Income in 2016? 925,777
n n n n n n n
3. If Depreciation&Amortization as a % of Capital Expenditures is
n n n n n n n n
n changed to 30%, what is Net Income in 2017? 1,123,438
n n n n n n n n n
4. What is the EBITDA % Margin in 2018? 17.1%
n n n n n n n n
Instructions: Questions 5-19 use the data table on tab Q5-19 in the
n n n n n n n n n n n
n Exam Workbook. We strongly recommend you analyze this data with
n n n n n n n n n
n the aid of a pivot table. You may also benefit from adding some extra
n n n n n n n n n n n n n
n calculation columns to the dataset. n n n n
Answers for numerical data should be rounded to the nearest 1
n n n n n n n n n n
n decimal, comma separating 000s, NOT written in currency format. So
n n n n n n n n n
n if the answer is $10,500.658, you would input 10,500.7.
n n n n n n n n
5. Over the entire analysis period, which sales rep sold the highest
n n n n n n n n n n
, n cumulative quantity of a single item?n n n n n
Rob Stewart n
6. In the last question you determined the sales person who sold the
n n n n n n n n n n n
n highest cumulative quantity of a single item. What is the item code of
n n n n n n n n n n n n
n that item? n
16
7. Over the entire analysis period, what is the second highest selling
n n n n n n n n n n
n item code by quantity?
n n n
39
8. Over the entire analysis period, what is the highest selling item code
n n n n n n n n n n n
n by quantity?
n
16
, 9. Only considering postal codes 93372, 93403 and 93434, which
n n n n n n n n
n postal code had the highest total profit during the month of
n n n n n n n n n n
n March? 93372 n
10. In the last question you determined the postal code that had
n n n n n n n n n n
n the highest total profit during the month of March. What was the
n n n n n n n n n n n
n profit? 13691.4 n
11. During the month of April, which postal code bought the most of item
n n n n n n n n n n n n
n 13 by quantity?
n n
93558
12. In the last question, you determined the postal code that bought the
n n n n n n n n n n n
n most of item 13 by quantity for the month of April. What was that
n n n n n n n n n n n n n
n quantity?
24
13. What is the total of Amy Adam’s sales over the analysis period?
n n n n n n n n n n n
n 492,153.8
14. In the previous question, you determined the the total of Amy’s sales
n n n n n n n n n n n
n over the analysis period. What was her total profit?
n n n n n n n n
255,548.1
Street Prep - Wall Street Prep
Questions And Answers Updated 2024
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the
n n n n n n n n n n n
n Exam Workbook. Complete the model by filling in the blank cells before
n n n n n n n n n n n
n answering the question below. Answers should be rounded to the nearest
n n n n n n n n n n
n whole number, comma separating 000s, NOT written in currency format.
n n n n n n n n n
n So if the answer is $5,505,210.50, you would input 5,505,210.
n n n n n n n n n
1. What is forecast Revenue in 2017? 13,642,021
n n n n n n
2. What is forecast Net Income in 2016? 925,777
n n n n n n n
3. If Depreciation&Amortization as a % of Capital Expenditures is
n n n n n n n n
n changed to 30%, what is Net Income in 2017? 1,123,438
n n n n n n n n n
4. What is the EBITDA % Margin in 2018? 17.1%
n n n n n n n n
Instructions: Questions 5-19 use the data table on tab Q5-19 in the
n n n n n n n n n n n
n Exam Workbook. We strongly recommend you analyze this data with
n n n n n n n n n
n the aid of a pivot table. You may also benefit from adding some extra
n n n n n n n n n n n n n
n calculation columns to the dataset. n n n n
Answers for numerical data should be rounded to the nearest 1
n n n n n n n n n n
n decimal, comma separating 000s, NOT written in currency format. So
n n n n n n n n n
n if the answer is $10,500.658, you would input 10,500.7.
n n n n n n n n
5. Over the entire analysis period, which sales rep sold the highest
n n n n n n n n n n
, n cumulative quantity of a single item?n n n n n
Rob Stewart n
6. In the last question you determined the sales person who sold the
n n n n n n n n n n n
n highest cumulative quantity of a single item. What is the item code of
n n n n n n n n n n n n
n that item? n
16
7. Over the entire analysis period, what is the second highest selling
n n n n n n n n n n
n item code by quantity?
n n n
39
8. Over the entire analysis period, what is the highest selling item code
n n n n n n n n n n n
n by quantity?
n
16
, 9. Only considering postal codes 93372, 93403 and 93434, which
n n n n n n n n
n postal code had the highest total profit during the month of
n n n n n n n n n n
n March? 93372 n
10. In the last question you determined the postal code that had
n n n n n n n n n n
n the highest total profit during the month of March. What was the
n n n n n n n n n n n
n profit? 13691.4 n
11. During the month of April, which postal code bought the most of item
n n n n n n n n n n n n
n 13 by quantity?
n n
93558
12. In the last question, you determined the postal code that bought the
n n n n n n n n n n n
n most of item 13 by quantity for the month of April. What was that
n n n n n n n n n n n n n
n quantity?
24
13. What is the total of Amy Adam’s sales over the analysis period?
n n n n n n n n n n n
n 492,153.8
14. In the previous question, you determined the the total of Amy’s sales
n n n n n n n n n n n
n over the analysis period. What was her total profit?
n n n n n n n n
255,548.1
