Question: Instructions: For questions 1 - 5 , use tab Q 1 - 5 in the Exam Workbook. Complete the financial model using the assumptions provided

Instructions: For questions 1-5, use tab Q1-5 in the Exam Workbook. Complete the financial model using the assumptions provided by filling in the
blank cells highlighted in yellow. All dollar amounts (except price and cost per unit) should be rounded to the nearest whole number, with commas
separating 000s and no currency format. For example, if the answer is $1,234.567, you would input 1,235. All percentages should be expressed with one
decimal point.
What is forecasted revenue in Year 5?
95,412
124,950
151,252
161,197 Instructions: See question 1.
What is forecasted gross profit as a % of revenue in Year 5?
59.2%
59.4%
60.0%
62.3% Instructions: See question 1.
What is forecasted EBITDA as a % of revenue in Year 5?
48,458
61,502
74,950
95,412 Instructions: See question 1.
What is forecasted net income in Year 5?
36,119
38,052
40,770
54,360Instructions: See question 1.
What would forecasted net income in Year 5 be if the effective tax rate was changed to 30% for all years?
36,119
38,052
40,770
54,360
 Instructions: For questions 1-5, use tab Q1-5 in the Exam Workbook.

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!