Finance > QUESTIONS & ANSWERS > Excel Crash Course Exam from Wall Street Prep - Wall Street Prep. (All)
Excel Crash Course Exam from Wall Street Prep - Wall Street Prep.
Document Content and Description Below
Excel Crash Course Exam from Wall Street Prep - Wall Street Prep. Instructions: Questions 1-4 use the financial model on tab Q1-4 in the Exam Workbook. Complete the model by filling in the blank cel l ... s before answering the 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. 1. What is forecast Revenue in 2017? 13,642,021 2. What is forecast Net Income in 2016? 925,777 3. If Depreciation&Amortization as a % of Capital Expenditures is changed to 30%, what is Net Income in 2017? 1,123,438 4. What is the EBITDA % Margin in 2018? 17.1% 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. [Show More]
Last updated: 3 years ago
Preview 1 out of 13 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$14.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Jul 21, 2022
Number of pages
13
Written in
All
Additional information
This document has been written for:
Uploaded
Jul 21, 2022
Downloads
0
Views
95
