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) | ||||||
| 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | |
| New Investment | 4,900 | 4,900 | 4,900 | 4,900 | 4,900 | 19,600 |
| Depreciation | (5,420) | ( 5,368) | ( 5,321) | ( 5,279) | ( 5,241) | (6,677) |
Using this information and the information here
?(?IMPORTANT:
Please click on the
| Copy to Clipboard | + | |||
| Open in Excel | + | |||
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
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.)
| Save Accounting Table... | + | |||
| Copy to Clipboard... | + | |||
| Income Statement ($ 000) | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |
| Sales | 75,300 | ? | ? | ? | ? | ? |
Data Table Click on the icon to import the table into a spreadsheet.) Year Growth 2005 2006 2007 2008 2009 2010 Sales Data Market Size (000 units) Market Share Average Sales Price (S/unit) 4.95% 0.50% 2.00% 10,300 10,810 11,34511,907 12,496 13,115 9.85% 10.35% 10.85% 11.35% 11.85% 12.35% 81.94 74.22 75.70 77.22 78.76 80.34 Cost of Goods Data Raw Materials (S/unit) Direct Labor Costs (S/unit) 0.90% 3.90% 15.67 18.06 15.81 18.76 15.95 19.50 16.10 20.26 16.24 21.05 16.39 21.87 Operating Expense Data Sales and Marketing (% sales) Administrative (% sales) 14.84 18.13 19.24 13.13 (75) (6,481) 6,481) 6,481) 6,481) 6,481) 16.19 15.13 17.54 15.13 18.89 14.13 19.24 13.13 Interest on Term Loan ($ 000) Print Done
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
