Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Under the assumption that Ideko's market share will increase by 0.65 percent per year, you project the following investment and depreciation: Fixed Assets and Capital

Under the assumption that Ideko's market share will increase by 0.65 percent per year, you project the following investment and depreciation:

Fixed Assets and Capital Investment ($ 000)

2005

2006

2007

2008

2009

2010

New Investment

5,000

5,000

5,000

5,000

5 comma 0005,000

19 comma 40019,400

Depreciation

(5,480)

(5,432)

(5,389)

(5,350)

( 5 comma 315 )(5,315)

( 6 comma 723 )(6,723)

Using this information and the information here

LOADING...

IMPORTANT:

Please click on the icon to import the table into a spreadsheet and use all the values as rounded on the spreadsheet. DO NOT recalculate the forecasted values.), project net income through 2010 (that is, reproduce Table 19.7

LOADING...

under the new assumptions). Assume the corporate tax rate is .35%.

Ideko's income statement for 2005 is shown here

LOADING...

.

To build the pro forma income statement, we begin with Ideko's sales.(Round to the nearest $ 000.)

Income Statement ($ 000)

2005

2006

2007

2008

2009

2010

Sales

76,674

(Click on the Icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.)

Estimated 2005 Income Statement Data for

Ideko Corporation

Income Statement ($ 000)

Sales 76,674

Cost of Goods Sold

Raw Materials (16,066)

Direct Labor Costs (18,146)

Gross Profi 42,462

Sales and Marketin (11,570)

Administrat (13,824)

EBITDA 17,068

Depreciation (5,480)

EBIT 11,588

Interest Expense (net) (77)

Pretax Income 11,511

Income Tax (4,029)

Net Income

Modifying 7 comma 482 with double underline 7,482

Year

Growth

2005

2006

2007

2008

2009

2010

Sales Data

Market Size (000 units)

5.005.00%

10 comma 20010,200

10 comma 71010,710

11 comma 24611,246

11 comma 80811,808

12 comma 39812,398

13 comma 01813,018

Market Share

0.650.65%

9.909.90%

10.5510.55%

11.2011.20%

11.8511.85%

12.5012.50%

13.1513.15%

Average Sales Price ($/unit)

1.851.85%

75.9375.93

77.3377.33

78.7778.77

80.2280.22

81.7181.71

83.2283.22

Cost of Goods Data

Raw Materials ($/unit)

1.051.05%

15.9115.91

16.0816.08

16.2516.25

16.4216.42

16.5916.59

16.7616.76

Direct Labor Costs ($/unit)

4.104.10%

17.9717.97

18.7118.71

19.4719.47

20.2720.27

21.1021.10

21.9721.97

Operating Expense Data

Sales and Marketing (% sales)

15.0915.09

16.4916.49

17.8917.89

19.2919.29

19.6919.69

19.6919.69

Administrative (% sales)

18.0318.03

15.0315.03

15.0315.03

14.0314.03

13.0313.03

13.0313.03

Interest on Term Loan ($ 000)

( 77 )(77)

( 6 comma 757 )(6,757)

( 6 comma 757 )(6,757)

( 6 comma 757 )(6,757)

( 6 comma 757 )(6,757)

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

Options Futures And Other Derivatives

Authors: John C. Hull

11th Edition

013693997X, 9780136939979

More Books

Students also viewed these Finance questions