Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

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

Step: 3

blur-text-image

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

Financial Accounting

Authors: Harrison, Horngren, Thomas

1st Edition

0558823513, 978-0558823511

More Books

Students also viewed these Accounting questions

Question

For chemical disposal, why is dichromate converted to Cr(OH)3(s)?

Answered: 1 week ago

Question

Kai & Chung

Answered: 1 week ago