Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Bond Markets Analysis And Strategies

Authors: Frank J.Fabozzi

7th Edition

0136078974, 978-0136078975

More Books

Students also viewed these Finance questions