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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
