Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Given the information in the projected income statements, and assuming the projected improvements in working capital (that is, Ideko's working capital requirements though 2010 will

Given the information in the projected income statements, and assuming the projected improvements in working capital (that is, Ideko's working capital requirements though 2010 will be as shown here), use EBITDA as a multiple to estimate the continuation value in 2010 (reproduce Table 19.15), assuming the EBITDA multiple for Ideko remains at 9.1× Infer the EV/sales and the unlevered and levered P/E ratios implied by the continuation value you calculated. Also assume that Ideko's production plant will require an expansion in 2010, and that the cost of this expansion, $15.3 million, will be added to Ideko's debt in 2010. Ideko's balance sheet for 2005 is shown here. Ideko's free cash flows through 2010 are shown here 

Income Statement ($ 000)

2005

2006

2007

2008

2009

2010

Sales

74,600

85,148

96,453

108,901

122,594

137,644

Cost of Goods Sold







Raw Materials

-16,000

-17,667

-19,815

-22,153

-24,694

-27,454

Direct Labor Costs

-18,000

-21,092

-24,408

-28,154

-32,378

-37,139

Gross Profit

40,600

46,389

52,230

58,594

65,522

73,051

Sales and Marketing

-11,250

-14,024

-17,284

-21,094

-24,298

-27,281

Administrative

-13,500

-12,925

-14,642

-15,442

-16,158

-18,141

EBITDA

15,850

19,440

20,304

22,058

25,066

27,629

Depreciation

-5,500

-5,950

-5,850

-5,760

-5,679

-7,136

EBIT

10,350

13,490

14,454

16,298

19,387

20,493

Interest Expense (net)

-75

-6,680

-6,680

-6,680

-6,680

-6,680

Pretax Income

10,275

6,810

7,774

9,618

12,707

13,813

Income Tax

-3,596

-2,384

-2,721

-3,366

-4,447

-4,835

Net Income

6,679

4,426

5,053

6,252

8,260

8,978

Working Capital Days

2005

> 2005

Assets 

Based on: 

Days 

Days

Accounts Receivable 

Sales Revenue 

90

90

Raw Materials 

Raw Materials Costs 

45

45

Finished Goods 

Raw Materials+Labor Costs 

45

45

Minimum Cash Balance 

Sales Revenue

30

30

Liabilities

Wages Payable 

Direct Labor+Admin Costs 

15

15

Other Accounts Payable 

Raw Materials+Sales and Marketing 

45

45

Working Capital ($ 000)

2005

2006

2007

2008

2009

2010

Assets







Accounts Receivable

54,550

20,995

23,783

26,852

30,229

33,940

Raw Materials

1,973

2,178

2,443

2,731

3,044

3,385

Finished Goods

4,192

4,779

5,452

6,202

7,036

7,964

Minimum Cash Balance

6,132

6,998

7,928

8,951

10,076

11,313

Total Current Assets

66,847

34,950

39,606

44,736

50,385

56,602

Labilities







Wages Payable

1,295

1,398

1,605

1,792

1,995

2,272

Other Accounts Payable

3,360

3,907

4,574

5,332

6,040

6,748

Total Current Liabilities

4,655

5,305

6,179

7,124

8,035

9,020

Net Working Capital

62,192

29,645

33,427

37,612

42,350

47,582

Increase in Net Working Capital


-32,547

3,782

4,185

4,738

5,232

Estimated 2005 Balance Sheet Data for
 Ideko Corporation


Balance Sheet ($ 000)


Assets


Cash and Equivalents 

6164


Accounts Receivable 

54550


Inventories 

6165


Total Current Assets 

66879


Property, Plant, and Equipment 

54550


Goodwill 

72332


Total Assets 

193761


Liabilities and Stockholders' Equity


Accounts Payable 

4654


Debt 

100000


Total Liabilities 

104654


Stockholders' Equity 

89107


Total Liabilities and Equity 

193761


Free Cash Flow ($ 000)

2005

2006

2007

2008

2009

2010

Net Income


4,426

5,053

6,252

8,260

8,978

Plus: After-tax Interest Expense


4,342

4,342

4,342

4,342

4,342

Unlevered Net Income


8,768

9,395

10,594

12,602

13,320

Plus: Depreciation


5,950

5,850

5,760

5,679

7,136

Less: Increase in NWC


32,547

-3,782

-4,185

-4,738

-5,232

Less: Capital Expenditures


-4,950

-4,950

-4,950

-4,950

-20,250

Free Cash Flow of Firm


42,315

6,513

7,219

8,593

-5,026

Plus: Net Borrowing






15,300

Less: After-tax Interest Expense


-4,342

-4,342

TABLE 19.15 SPREADSHEET Continuation Value: Multiples Approach ($ 000) EBITDA in 2010 32,094 EBITDA multiple Continuation Enterprise Value Continuation Equity Value 1 2 3 4 5 Continuation Value Estimate for Ideko Debt 9.1x 292,052 (120,000) 172,052 Common Multiples EV/Sales P/E (levered) P/E (unlevered) 18x 16.3x 18.4x

Step by Step Solution

3.26 Rating (144 Votes )

There are 3 Steps involved in it

Step: 1

To estimate the continuation value in 2010 using the EBITDA multiple we need the EBITDA for 2010 and ... 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

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta

10th Canadian edition

1259261018, 1259261015, 978-1259024979

More Books

Students also viewed these Accounting questions

Question

=+d) Are all of these rolls within the specification limits?

Answered: 1 week ago