Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Historical Projected 2012 2013 2014 2015 2016 2017 2018 2019 Sales $4,132.5 $7,491.2 $11,000.0 $13,200.0 COGS (excluding depr.) $1,303.4 $1,632.7 $2,397.48 Gross Profit $2,829.1 $5,858.5

Historical

Projected

2012

2013

2014

2015

2016

2017

2018

2019

Sales

$4,132.5

$7,491.2

$11,000.0

$13,200.0

COGS (excluding depr.)

$1,303.4

$1,632.7

$2,397.48

Gross Profit

$2,829.1

$5,858.5

$8,602.5

SG&A

$2,449.2

$4,342.5

$6,376.5

R&D Exp.

$0.0

$0.0

$0.0

EBITDA

$379.9

$1,516.0

$2,226.0

EBITDA Margin

9.19%

20.24%

20.24%

Depreciation

$41.8

$149.0

$24.75

EBIT

$338.1

$1,367.0

$2,201.3

Taxes (35.0%)

$4.4

$74.2

$770.4

Tax-effected EBIT

$333.7

$1,292.8

$1,430.8

Depreciation

$41.8

$149.0

$24.8

Capital Expenditures

$142.2

$1,194.4

$33.0

$1,000.0

Change in working capital

$10.8

$271.2

$68.0

Free Cash Flow

$222.5

($23.8)

$1,354.6

Operating Assumptions

Sales Growth

NA

81.3%

46.8%

20.0%

40.0%

25.0%

25.0%

25.0%

COGS (% of sales)

31.5%

21.8%

21.8%

21.8%

21.8%

21.8%

21.8%

21.8%

SG&A (% of sales)

59.3%

58.0%

58.0%

57.0%

56.0%

55.0%

54.0%

53.0%

R&D Exp. (% of sales)

0.0%

0.0%

0.0%

0.1%

0.1%

0.1%

0.1%

0.1%

Primary Expenditure Assumptions

CapEx (% of sales)

3.4%

15.9%

0.3%

7.6%

0.3%

0.3%

0.3%

0.3%

Depreciation (% of CapEx)

29.4%

12.5%

75.0%

80.0%

85.0%

90.0%

95.0%

100.0%

Change in Working Capital (% of sales)

NA

8.1%

1.9%

1.9%

1.9%

1.9%

1.9%

1.9%

Dollar values in thousands

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: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso, J. Mather

8th Edition

0470929383, 978-0470929384

More Books

Students also viewed these Accounting questions

Question

What steps will Sara need to take to conduct a benefit audit?

Answered: 1 week ago