Question: 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.)

Under the assumption that Ideko's market share will increase by 0.50 percent

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!