### Evaluating the desirability of adding a new product

Assignment Help Finance Basics
##### Reference no: EM13752733

Assume that you are employed by a wood milling company that is evaluating the desirability of adding a new product to their product mix. The product would require the addition of new and different CNC (computer numerical control) milling equipment. Your boss has asked you to analyze a project proposal and recommend whether the project should be accepted or rejected. The most likely project estimates are:

Unit selling price = \$50

Unit variable cost = \$30

Total fixed costs including depreciation = \$300,000

Expected sales = 30,000 units per year

The projects will last for 10 years and will require an initial investment of \$1 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 35% and the required rate of return is 12%.

Your boss recognizes that some of these estimates are subject to error and wants to better understand the risks associated with the project and alternatives for dealing with those risks. You have been asked to include a sensitivity analysis in your report. You are also to explain how changing the discount rate might be helpful.

Your boss has heard about cash flow estimates being biased for personal gain at the company's expense in another firm and would like to better understand that potential problem. You have been asked to address that in your report.

The team developing the proposal estimated that variable cost and sales volume may each turn out to be as much as 10% higher or 10% lower than the initial estimate. To complete this assignment, you are to submit a four to five page paper that includes the following:

Using MS Excel:

Calculate the project's NPV for the most likely results.

Calculate the project's NPV for the best-case scenario.

Calculate the project's NPV for the worst-case scenario.

Calculate the project IRR for the most likely results.

You will transfer your calculations into your final report. In a 4-5 page paper in MS Word:

Exhibit your Excel function entries and results, or your calculations using present value tables, for each of your NPV and IRR calculations (A-D) and provide an explanation of all calculations

Explain your recommendation regarding whether the project should be accepted and a justification of your response.

Provide an explanation of how adjusting the discount rate in the basic NPV model of capital budgeting deals with the problem of project risk.

Examine the potential motivation for unethical behavior by executives that may take place in the capital budgeting process and explain how biasing cash-flow estimates can work to the advantage of the executive who intentionally inserts such bias.

### Previous Q& A

#### What public policy inputs and goals

Would you describe the orientation of Reynolds toward tobacco regulation as cooperative or at arm's length? How about the attitude of Altria? What do you think explains the differences between the two companies' positions. What public policy input..

#### Advantage of corporations relative to partnerships

Question 1: Which of the following is an advantage of corporations relative to partnerships and sole proprietorships?

#### What osha standards/regulations were cited as violations

What were the issues/hazards noteworthy in this case? This should be at least a couple of paragraphs in length. What OSHA standards/regulations were cited as violations in the case. Remember, in most cases these with be CFR 1926. This section coul..

#### How would you handle budget planning

How would you handle budget planning. What you learned from completing your own floor plan. What is your rationale for design choices

#### How many continents in world

How many continents in world?

#### What combination of a and b will maximize contribution

What combination of A and B will maximize contribution, and what is the maximum possible contribution

#### What was the nature of the american affluent society

Between the end of the Korean War and the start of the Vietnam War what was the nature of the American "affluent society"? Why was youth culture such an integral part of this era?

#### Describe a time when you were trying to communicate

Describe a time when you were trying to communicate with another person and active listening would have been helpful. What was the situation. How did he/she respond. How did you respond. What could you have done to improve the communication

#### Determine which of the issues would present

Determine which of the issues would present the greatest challenge to the company you selected. Provide specific examples to support your response.

#### The uninsured and under-insured population

The uninsured and under-insured population, The U.S. health care system has numerous known issues that affect the overall quality, access, and cost of services available. For your Final Paper, you will create an eight- to ten-page proposal

### Similar Q& A

#### In a paper 850-1250words compare and contrast the major

1 in a paper 850-1250words compare and contrast the major elements of the reports by coyne et al. and messina et al.2

#### What level of expected sales should clockwatchers choose

If EBIT Break-even is how the firm evaluates its projects, then above what level of expected sales should ClockWatchers choose the high fixed cost alternative?

#### Justify analyze the following situation and answer

justify analyze the following situation and answer questions. after choosing a savings account with 3 interest rate you

#### Google external and internal environmental conditions

Considering Google's external and internal environmental conditions, does a SWOT analysis reveal any insights to enhance the company's efforts to compete or improve performance? Write around a 1,300 - 1550 Paper. Be sure to include a referenc..

#### What will be the new price of the stock

Jersey Mining earns \$9.50 a share, sells for \$90, and pays a \$6 per share dividend. The stock is spit two for one and a \$3 per share cash dividend is declared.

#### The bond presently sells for 925 and the companys tax rate

several years ago the metalusa inc. sold a 1000 par value noncallable bond that now has 20 years to maturity and a 7.00

#### What is mom return on assets

Mind-Over-Matter (MOM) Tutors has a total assets turnover equal to 3.0x, a net profit margin equal to 4 percent, and a return on equity (ROE) equal to 15 percent.

#### What is the best estimate of the stocks post-split price

Toombs Media Corp. recently completed a 3-for-1 stock split. Prior to the split, its stock sold for \$90 per share. The firm's total market value was unchanged by the split. Other things held constant, what is the best estimate of the stock's post-..

#### Should he buy the equipment

The value you obtain will apply to each of the six years. 2. what is the expected net present value? 3. should he buy the equipment? why or why not?

#### Shown is a probability distribution for the random variable

shown is a probability distribution for the random variable x.x fx3 ...................0.256 ....................0.509

#### What is the internal rate of return

The cash inflows generated by the project are estimated at \$76,000 for the first two years and \$30,000 for the following two years. What is the internal rate of return?

#### Define each of the following terms capital structure

define each of the following termsa. capital structure business risk financial riskb. operating leverage financial