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.)
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started