Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Step: 3

blur-text-image

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

Machine Learning In Finance From Theory To Practice

Authors: Matthew F Dixon, Igor Halperin, Paul Bilokon

1st Edition

3030410676, 978-3030410674

More Books

Students also viewed these Finance questions

Question

What is involved in the administration of a labor agreement?

Answered: 1 week ago

Question

What are topics included in virtually all labor agreements?

Answered: 1 week ago