Excel Crash Course Exam from Wall
h h h h h
Street Prep - Wall Street Prep h h h h h
Questions
And Answers Updated
h
h h
2024 h
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the
h h h h h h h h h h h
h Exam Workbook. Complete the model by filling in the blank cells
h h h h h h h h h h
h before answering the question below. Answers should be rounded to the
h h h h h h h h h h
h nearest whole number, comma separating 000s, NOT written in
h h h h h h h h
h currency format. So if the answer is $5,505,210.50, you would input
h h h h h h h h h h
h 5,505,210.
1. What is forecast Revenue in 2017? Ans>> 13,642,021
h h h h h h h
2. What is forecast Net Income in 2016? Ans>> 925,777
h h h h h h h hh
3. If Depreciation&Amortization as a % of Capital
h h h h h h
Expenditures is changed to 30%, what is Net Income in
h h h h h h h h h h
2017? Ans>> 1,123,438
h h hh
4. What is the EBITDA % Margin in 2018? Ans>> 17.1%
h h h h h h h h hh
Instructions: Questions 5-19 use the data table on tab Q5-19 in h h h h h h h h h h
hthe Exam Workbook. We strongly recommend you analyze this
h h h h h h h h
hdata with the aid of a pivot table. You may also benefit from
h h h h h h h h h h h h
hadding some extra calculation columns to the dataset. Answers
h h h h h h h h
hfor numerical data should be rounded to the nearest 1
h h h h h h h h h
hdecimal, comma separating 000s, NOT written in currency
h h h h h h h
hformat. So if the answer is $10,500.658, you would input
h h h h h h h h h
h10,500.7.
5. Over the entire analysis period, which sales rep sold the
h h h h h h h h h
highest cumulative quantity of a single item? Ans>> Rob
h h h h h h h h hh
Stewart
h
6. In the last question you determined the sales person who sold
h h h h h h h h h h
the highest cumulative quantity of a single item. What is the
h h h h h h h h h h h
item code of that item?
h h h h h
Ans>> 16 h
7. Over the entire analysis period, what is the second highest
h h h h h h h h h
selling item code by quantity?
h h h h h
Ans>> 39 h
8. Over the entire analysis period, what is the highest selling
h h h h h h h h h
item code by quantity?
h h h h
, Ans>> 16 h
9. Only considering postal codes 93372, 93403 and 93434,
h h h h h h h
hwhich postal code had the highest total profit during the
h h h h h h h h h
hmonth of March? 93372
h h h
, 10. In the last question you determined the postal code that
h h h h h h h h h
had the highest total profit during the month of March. What
h h h h h h h h h h h
was the profit?
h h h
Ans>> 13691.4 h
11. During the month of April, which postal code bought the h h h h h h h h h
most of item 13 by quantity?
h h h h h h
Ans>> 93558 h
12. In the last question, you determined the postal code
h h h h h h h h
that bought the most of item 13 by quantity for the month of
h h h h h h h h h h h h h
April. What was that quantity?
h h h h h
Ans>> 24 h
13. What is the total of Amy Adam’s sales over the
h h h h h h h h h
h analysis period? Ans>> 492,153.8 h h h
14. In the previous question, you determined the the total
h h h h h h h h
of Amy’s sales over the analysis period. What was her total
h h h h h h h h h h h
profit?
h
Ans>> 255,548.1 h
15. During the three-month period of January through March,
h h h h h h h
what was the quantity of item 23 sold while Fred Rubble was
h h h h h h h h h h h h
the Manager on duty? Ans>> 784
h h h h h h
16. During the month of May, how many postal codes h h h h h h h h
bought more than 700 products by quantity?
h h h h h h h
Ans>> 4 h
17. Over the entire analysis period, which sales rep gave
h h h h h h h h
the most discounts by dollar amount? Enter the name as:
h h h h h h h h h h
FirstnameLastname. Ans>> Oliver Winslow
h h h h
18. In the previous question, you determined which sales
h h h h h h h
rep gave the most discounts by dollar amount. What was
h h h h h h h h h h
that amount? Ans>> 17444.4
h h h hh
19. Over the entire analysis period, which item code did
h h h h h h h h
postal code 93930 spend the greatest dollars on? Ans>> 16
h h h h h h h h h hh
20.
h h h h h
Street Prep - Wall Street Prep h h h h h
Questions
And Answers Updated
h
h h
2024 h
Instructions: Questions 1-4 use the financial model on tab Q1-4 in the
h h h h h h h h h h h
h Exam Workbook. Complete the model by filling in the blank cells
h h h h h h h h h h
h before answering the question below. Answers should be rounded to the
h h h h h h h h h h
h nearest whole number, comma separating 000s, NOT written in
h h h h h h h h
h currency format. So if the answer is $5,505,210.50, you would input
h h h h h h h h h h
h 5,505,210.
1. What is forecast Revenue in 2017? Ans>> 13,642,021
h h h h h h h
2. What is forecast Net Income in 2016? Ans>> 925,777
h h h h h h h hh
3. If Depreciation&Amortization as a % of Capital
h h h h h h
Expenditures is changed to 30%, what is Net Income in
h h h h h h h h h h
2017? Ans>> 1,123,438
h h hh
4. What is the EBITDA % Margin in 2018? Ans>> 17.1%
h h h h h h h h hh
Instructions: Questions 5-19 use the data table on tab Q5-19 in h h h h h h h h h h
hthe Exam Workbook. We strongly recommend you analyze this
h h h h h h h h
hdata with the aid of a pivot table. You may also benefit from
h h h h h h h h h h h h
hadding some extra calculation columns to the dataset. Answers
h h h h h h h h
hfor numerical data should be rounded to the nearest 1
h h h h h h h h h
hdecimal, comma separating 000s, NOT written in currency
h h h h h h h
hformat. So if the answer is $10,500.658, you would input
h h h h h h h h h
h10,500.7.
5. Over the entire analysis period, which sales rep sold the
h h h h h h h h h
highest cumulative quantity of a single item? Ans>> Rob
h h h h h h h h hh
Stewart
h
6. In the last question you determined the sales person who sold
h h h h h h h h h h
the highest cumulative quantity of a single item. What is the
h h h h h h h h h h h
item code of that item?
h h h h h
Ans>> 16 h
7. Over the entire analysis period, what is the second highest
h h h h h h h h h
selling item code by quantity?
h h h h h
Ans>> 39 h
8. Over the entire analysis period, what is the highest selling
h h h h h h h h h
item code by quantity?
h h h h
, Ans>> 16 h
9. Only considering postal codes 93372, 93403 and 93434,
h h h h h h h
hwhich postal code had the highest total profit during the
h h h h h h h h h
hmonth of March? 93372
h h h
, 10. In the last question you determined the postal code that
h h h h h h h h h
had the highest total profit during the month of March. What
h h h h h h h h h h h
was the profit?
h h h
Ans>> 13691.4 h
11. During the month of April, which postal code bought the h h h h h h h h h
most of item 13 by quantity?
h h h h h h
Ans>> 93558 h
12. In the last question, you determined the postal code
h h h h h h h h
that bought the most of item 13 by quantity for the month of
h h h h h h h h h h h h h
April. What was that quantity?
h h h h h
Ans>> 24 h
13. What is the total of Amy Adam’s sales over the
h h h h h h h h h
h analysis period? Ans>> 492,153.8 h h h
14. In the previous question, you determined the the total
h h h h h h h h
of Amy’s sales over the analysis period. What was her total
h h h h h h h h h h h
profit?
h
Ans>> 255,548.1 h
15. During the three-month period of January through March,
h h h h h h h
what was the quantity of item 23 sold while Fred Rubble was
h h h h h h h h h h h h
the Manager on duty? Ans>> 784
h h h h h h
16. During the month of May, how many postal codes h h h h h h h h
bought more than 700 products by quantity?
h h h h h h h
Ans>> 4 h
17. Over the entire analysis period, which sales rep gave
h h h h h h h h
the most discounts by dollar amount? Enter the name as:
h h h h h h h h h h
FirstnameLastname. Ans>> Oliver Winslow
h h h h
18. In the previous question, you determined which sales
h h h h h h h
rep gave the most discounts by dollar amount. What was
h h h h h h h h h h
that amount? Ans>> 17444.4
h h h hh
19. Over the entire analysis period, which item code did
h h h h h h h h
postal code 93930 spend the greatest dollars on? Ans>> 16
h h h h h h h h h hh
20.
