Finance > EXAM REVIEW > Creighton University FINANCE 301 Excel Crash Course Exam from Wall Street Prep - Wall Street Prep-VE (All)
Review: Excel Crash Course Exam Question 1 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 th... e question below. Answers should be rounded to 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? Question 10 Instructions: See question 5. Your answer for this question 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. In the last question you determined the postal code that had the highest total profit during the month of March. What was the profit? [Show More]
Last updated: 1 year ago
Preview 1 out of 11 pages
Connected school, study & course
About the document
Uploaded On
May 28, 2021
Number of pages
11
Written in
This document has been written for:
Uploaded
May 28, 2021
Downloads
0
Views
143
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·