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.50 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.50 percent per year, you project the following investment and depreciation:

Fixed Assets and Capital Investment ($ 000)

New InvestmentDepreciation

20055,000(5,430)

20065,000(5,387)

20075,000(5,348)

20085,000(5,314)

20095,000(5,282)

201019,800(6,724)

Use this information and the information on the attached Excel data table.IMPORTANT: DO NOT recalculate the forecasted values.), project net income through 2010 (that is, reproduce Table 19.7 attached, under the new assumptions). Assume the corporate tax rate is 35%. Ideko's income statement for 2005 is shown on the attached Estimated 2005 Income Statement. To build the pro forma incomestatement, we begin with Ideko's sales. See attached Accounting Table.(Round to the nearest $ 000.)

image text in transcribed 9a3b5987c4b2b58fc9957cfea9977da69d279131 Income Statement ($ 000) Sales 2005 2006 2007 2008 2009 2010 74509 Page 1 Growth Sales Data Market Size (000 units) Market Share Average Sales Price ($/unit) Cost of Goods Data Raw Materials ($/unit) Direct Labor Costs ($/unit) Operating Expense Data Sales and Marketing (% sales) Administrative (% sales) Interest on Term Loan ($ 000) 5.15% 0.50% 2.05% 2005 2006 2007 2008 2009 10200 10725 11277 11858 12469 9.85% 10.35% 10.85% 11.35% 11.85% 74.16 75.68 77.23 78.81 80.43 1.00% 4.05% 16.09 17.82 14.83 18.02 (78) 16.25 18.54 16.41 19.29 16.58 20.07 16.74 20.89 16.43 18.03 19.63 20.23 15.02 15.02 14.02 13.02 (6,681) (6,681) (6,681) (6,681) 2010 13111 12.35% 82.08 16.91 21.73 20.23 13.02 (6,681)

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

Investing In Financial Research A Decision Making System For Better Results

Authors: Cheryl Strauss Einhorn, Tony Blair

1st Edition

1501732757, 9781501732751

More Books

Students also viewed these Finance questions

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago