Question: Question 1 Instructions : Questions 1-4 use the financial model on tab Q1 -4 in the Exam Workbook . Complete the model by filling in

Question 1 Instructions : Questions 1-4 use the
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 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 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 s 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 bene fit 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 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!