Question: Please fill out chat. please show how you get the depreciation answer in the cell, ASSUMPTIONS Sales Price per Unit $49.99 Gross Margin = (Revenues

Please fill out chat. please show how you get the depreciation answer in the cell,
ASSUMPTIONS
Sales Price per Unit $49.99
Gross Margin = (Revenues - cost of goods sold) / Revenues 25%
Depreciation & amortization as a % of capital expenditures 25%
Tax Rate 35%
Year 2014 2015 2016 2017 2018
Units Sold 200,000
Growth Rate Of Unit Sold 5% 13% 15% 9%
Operating Expenses as % of Sales (2014 Only) 10%
Operating Expense Growth Rate 4% 4% 4% 4%
Capital Expenditures $1,750,000 $1,775,000 $1,800,000 $1,825,000 $1,850,000
Interest Expense $0 $10,000 $10,000 $10,000 $12,500
Income Statement
Year 2014 2015 2016 2017 2018
Units Sold 200,000 210,000 237,300 272,895 297,456
Price per Unit $49.99 $49.99 $49.99 $49.99 $49.99
Revenue 9,998,000 10,497,900 11,862,627 13,642,021 14,869,803
Cost of goods sold
Gross Profit (defined as Revenue - COGS)
Operating Expenses
Earnings Before Interest Taxes Depreciation And Amortization (Ebitda)
EBITDA / Revenue (%)
Depreciation and Amortization
Operating Income (defined as EBITDA - Depreciation and Amortization)
Interest Expense
Pre-tax Net Income (Operating Income - Interest Expense)
Income Taxes
Net Income (Pret-tax Net Income - Income Taxes)

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 Finance Questions!