Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill out projected data for 2015-2019 using data provided. Sales COGS (excluding dgpc.) Gross Profit SG&A Exp. EBITDA EBITDA Margin Depreciation EBIT Taxes (35.0%)
Please fill out projected data for 2015-2019 using data provided.
Sales COGS (excluding dgpc.) Gross Profit SG&A Exp. EBITDA EBITDA Margin Depreciation EBIT Taxes (35.0%) Tax-effected EBIT Depreciation Capital Expenditures Change in working capital Free Cash Flow Operating Assumptions Sales Growth COGS (0/0 of sales) SG&A (% of sales) R&D Exp. (% of sales) Primary Expenditure Assumptions (% of sales) Depreciation (% of gpE8) Change in Working Capital (% of A sales) Dollar values in thousands Historical 2012 $4,132.5 $1,303.4 $2,829.1 $2,449.2 $0.0 $379.9 9.19% $41.8 $338.1 $4.4 $333.7 $41.8 $142.2 $10.8 $222.5 31.5% 59.3% 0.0% 3.4% 29.4% 2013 $7,491.2 $1,632.7 $5,858.5 $4,342.5 $0.0 $1,516.0 20.24% $149.0 $1,367.0 $74.2 $1,292.8 $149.0 $1,194.4 $271.2 ($23.8) 81.3% 21.8% 58.0% 0.0% 15.9% 12.5% 8.1% 2014 $11,000.0 $2,397.48 $8,602.5 $6,376.5 $0.0 $2,226.0 20.24% $24.75 $2,201.3 $770.4 $1,430.8 $24.8 $33.0 $68.0 $1,354.6 46.8% 21.8% 58.0% 0.0% 0.3% 75.0% 1.9% Projected 2015 $13,200.0 $1,000.0 20.0% 21.8% 57.0% 0.1% 7.6% 80.0% 1.9% 2016 40.0% 21.8% 56.0% 0.1% 0.3% 85.0% 1.9% 2017 25.0% 21.8% 55.0% 0.1% 0.3% 90.0% 1.9% 2018 25.0% 21.8% 54.0% 0.1% 0.3% 95.0% 1.9% 2019 25.0% 21.8% 53.0% 0.1% 0.3% 100.0% 1.9%
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