Complete the model by filling in the blank cells before answering the question below. Answers should be
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Transcribed Image Text:
ASSUMPTIONS Sales Price per Unit Gross Margin = (Revenues - cost of goods sold) / Reve Depreciation & amortization as a % of capital expendi Tax Rate Year Units Sold Growth Rate Of Unit Sold Operating Expenses as of Sales (2014 Only) Operating Expense Growth Rate Capital Expenditures Interest Expense Income Statement Year Units Sold Price per Unit Revenue Cost of goods sold Gross Profit (defined as Revenue COGS) $49.99 Interest Expense Pre-tax Net Income (Operating Income - Interest Expense) Income Taxes 25% 25% 35% Net Income (Pret-tax Net Income Income Taxes) 2014 200,000 10% Operating Expenses Earnings Before Interest Taxes Depreciation And Amortization (Ebitda) EBITDA/ Revenue (8) $0 Depreciation and Amortization Operating Income (defined as EBITDA - Depreciation and Amortization) 2014 2015 5% 2016 $1,750,000 $1,775,000 $1,800,000 $1,825,000 $1,850,000 $10,000 $10,000 $10,000 $12,500 2015 13% 2017 2016 15% 2018 2017 98 2018 ASSUMPTIONS Sales Price per Unit Gross Margin = (Revenues - cost of goods sold) / Reve Depreciation & amortization as a % of capital expendi Tax Rate Year Units Sold Growth Rate Of Unit Sold Operating Expenses as of Sales (2014 Only) Operating Expense Growth Rate Capital Expenditures Interest Expense Income Statement Year Units Sold Price per Unit Revenue Cost of goods sold Gross Profit (defined as Revenue COGS) $49.99 Interest Expense Pre-tax Net Income (Operating Income - Interest Expense) Income Taxes 25% 25% 35% Net Income (Pret-tax Net Income Income Taxes) 2014 200,000 10% Operating Expenses Earnings Before Interest Taxes Depreciation And Amortization (Ebitda) EBITDA/ Revenue (8) $0 Depreciation and Amortization Operating Income (defined as EBITDA - Depreciation and Amortization) 2014 2015 5% 2016 $1,750,000 $1,775,000 $1,800,000 $1,825,000 $1,850,000 $10,000 $10,000 $10,000 $12,500 2015 13% 2017 2016 15% 2018 2017 98 2018
Expert Answer:
Answer rating: 100% (QA)
To calculate the forecast revenue in 2017 we need to use the given information and assumptions to fi... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-6. On December 12, Irene purchased the building where her store is located. She paid...
-
Since the early 1990s, woodstove sales have declined from 1,200,000 units per year to approximately 100,000 units per year. The decline has occurred because of (1) stringent new federal EPA...
-
The mass of the crane?s boom is 9000 kg. Its weight acts at?G. The sum of the moments about?P?due to the boom?s weight, the force exerted at?B?by the cable?AB,?and the force exerted at?C?by the...
-
A drag force on an object moving through a medium (like a car through air or a submarine through water) is Fd = 0.225 A V2. Verify the unit becomes Newton?
-
Arnison Company has a December 31 fiscal year end and follows ASPE. The following selected transactions are related to its property, plant, and equipment in 2021: Jan. 12 All of the company?s light...
-
Consider an economy with risk-neutral individuals. There are three types of individuals. An individual of type 1 can invest \($200\) and get a gross return of \($400\) with certainty. An individual...
-
1. Create a customer profile for each CardioGood Fitness treadmill product line by developing appropriate tables and charts. 2. Write a report to be presented to the management of Car-dioGood Fitness...
-
50 ft mi + and sees a mirror on the ground. m the mirror to practice her Geometry. the height of the school. She also kn the school from a previous Geometry distance she is standing from the mir
-
Let f(x) be a pdf and let a be a number such that, for all > 0, f(a + ) = f(a - ). Such a pdf is said to be symmetric about the point a. (a) Give three examples of symmetric pdfs. (b) Show that if X...
-
We will develop an SVM Kernel Trick 1 for Linear SVM for weighted dataset: Each data point in the dataset has a weight associated: {xn, yn, Un} Where un is the weight associated with the nth data...
-
What is R of a fiberglass batt ( thermal conductivity = 0 . 0 3 9 at 3 0 0 K ) that is 6 inches thick? Give two answers, one in American units based on BTUs, one in SI units based on joules
-
You buy a share for $18.98 and sell it exactly one year later for $16.83. During the year the share pays dividends totalling $1.25. What was the total return on this investment?
-
Use the following for questions 6 through 8: Below is an Excel Output of MONTHLY data for AAPL Intercept 0.0051 MKT-RF 1.3250 8) Suppose next year the risk-free rate is again 2% and the market has a...
-
You have been asked to calculate the discount rate for 3 years from now using an interest rate of 3% and a risk factor of 2. What should the discount rate be?
-
At what height does the dolphin catch the ball if it leaves the water with an initial speed of 8.22 m/s? [Answer: Ya Y = 0.680 m. If the dolphin's initial speed is less than 7.50 m/s, it reenters the...
-
Please solve in the red color . The ?rst table presents multiples for 5 peers of Firm X and the second table presents information for Firm X. Use approaches that are consistent with the approac...
-
How can you tell from the vertex form y = a(x - h) 2 + k whether a quadratic function has no real zeros?
-
XYZ plc, a paint manufacturer, operates a process costing system. The following details related to process 2 for the month of October: There are no further processing costs associated with either...
-
PDR plc manufactures four products using the same machinery. The following details relate to its products: (a) Determine the production plan which will maximize the weekly profit of PDR plc and...
-
Variance investigation decisions are normally explained in textbooks by simple models, which assume the availability of a significant amount of information. An example of this approach is: The...
-
1. Several successful chains of warehouse stores such as Costco have merchandising policies that differ considerably from those of traditional department stores. Identify characteristics of these...
-
The Ibunez Tool Company has two products: a plain circular saw and a fancy circular saw. The plain circular saw sells for $66 and has a variable cost of $50. The fancy circular saw sells for $100 and...
-
The following is the income statement of a manufacturer of blue jeans: Hunter had manufactured 2 million units, which had been sold to various clothing wholesalers and department stores. In early...
Study smarter with the SolutionInn App