Question
Build a pro forma Income Statement, began with sales the sale for 2005 is 74,572 Under the assumption that Ideko's market share will increase by0.65percent
Build a pro forma Income Statement, began with sales the sale for 2005 is 74,572
Under the assumption that Ideko's market share will increase by0.65percent per year, you project the following investment and depreciation
Fixed Assets and Capital Investment ($ 000) |
| ||||||
2005 | 2006 | 2007 | 2008 | 2009 | 2010 | ||
New Investment | 5,150 | 5,150 | 5,150 | 5,150 | 5,150 | 19,350 | |
Depreciation | (5,590) | (5,546) | (5,506) | (5,471) | (5,439) | (6,830) |
Using this information and the information here (IMPORTANT:
Please click on theicon 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.7under the new assumptions). Assume the corporate tax rate is.35%. Ideko's income statement for 2005 is shown here
Growth | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | |
Sales Data | |||||||
Market Size (000 units) | 5.00% | 9800 | 10290 | 10805 | 11345 | 11912 | 12508 |
Market Share | 0.65% | 10.10% | 10.75% | 11.40% | 12.05% | 12.70% | 13.35% |
Average Sales Price ($/unit) | 1.90% | 75.34 | 76.77 | 78.23 | 79.72 | 81.23 | 82.77 |
Cost of Goods Data | |||||||
Raw Materials ($/unit) | 1.15% | 16.35 | 16.54 | 16.73 | 16.92 | 17.12 | 17.31 |
Direct Labor Costs ($/unit) | 3.85% | 18.09 | 18.79 | 19.51 | 20.26 | 21.04 | 21.85 |
Operating Expense Data | |||||||
Sales and Marketing (% sales) | 15.13 | 16.78 | 18.43 | 20.08 | 20.73 | 20.73 | |
Administrative (% sales) | 18.12 | 15.12 | 15.12 | 14.12 | 13.12 | 13.12 | |
Interest on Term Loan ($ 000) | (78) | (6,716) | (6,716) | (6,716) | (6,716) | (6,716) |
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