Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started