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

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