MGM Co. has decided to sell a new line of golf clubs. The clubs will sell for $850 per set and have a variable cost of $400 per set. The company has spent $300,000 for a marketing study that determined the company will sell 68,500 sets per year for seven years. The marketing study also determined that the company will lose sales of 12,400 sets of its high-priced clubs. The high-priced clubs sell at $1,200 and have variable costs of $660. The company will also increase sales of its cheap clubs by 14,400 sets. The cheap clubs sell for $420 and have variable costs of $210 per set. The fixed costs each year will be $10,400,000. The company has also spent $2,500,000 on research and development for the new clubs. The plant and equipment required will cost $38,500,000 and will be depreciated on a straight-line basis. The new clubs will also require an increase in net working capital of $2,900,000 that will be returned at the end of the project. The tax rate is 21 percent, and the cost of capital is 12 percent.

Suppose you feel that the values are accurate to within only +/- 10 percent. What are the best-case and worst-case NPVs? (hint: the price and variable costs for the two existing sets of clubs are known with certainty; only the sales gained or lost are uncertain) *(Can Not use Excel)

20. Project Analysis. McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $845 per set and have a variable cost of $405 per set. The company has spent $150,000 for a marketing study that determined the company will sell 60,000 sets per year for seven years. The marketing study also determined that the company will lose sales of 10,000 sets of its high-priced clubs. The high- priced clubs sell at $1,175 and have variable costs of $620. The company will also increase sales of its cheap clubs by 12,000 sets. The cheap clubs sell for $435 and have variable costs of $200 per set. The fixed costs each year will be $9.75 million. The company has also spent $1 million on research and development for the new clubs. The plan and equipment required will cost $37.1 million and will be depreciated on a straight-line basis. The new clubs will also require an increase in net working capital of $1.7 million that will be returned at the end of the project. The tax rate is 25 percent, and the cost of capital if 10 percent. Calculate the payback period, the NPV, and the IRR.

21. Sensitivity Analysis. In the previous problem, you feel that the values are accurate to within +/ 10 percent. What are the best-case and worst-case NPVs? Hint: The price and variable costs for the two existing sets of clubs are known with certainty only the sales gained or lost are uncertain.

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $167,700 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 9,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $70,000 per month?

Outback Outfitters sells recreational equipment. One of the company's products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove and fixed expenses associated with the stove total $175,000 per month.

REQUIRED:

1. What is the break -even point in unit sales and in dollar sales?

2. If the variable expenses per stove increases as a percentage of the selling price, will it result in a higher or lower break - even point? (Assume that the fixed expenses remain unchanged)

3. At present, the company selling 12,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $75,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $179,400 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 8,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $77,000 per month?

Outback Outfitters sells recreational equipment. One of the company’s products, a small camp stove, sells for $130 per unit. Variable expenses are $91 per stove, and fixed expenses associated with the stove total $195,000 per month.

Required:

1. What is the break-even point in unit sales and in dollar sales?

2. If the variable expenses per stove increase as a percentage of the selling price, will it result in a higher or a lower break-even point? (Assume that the fixed expenses remain unchanged.)

3. At present, the company is selling 18,000 stoves per month. The sales manager is convinced that a 10% reduction in the selling price would result in a 25% increase in monthly sales of stoves. Prepare two contribution format income statements, one under present operating conditions, and one as operations would appear after the proposed changes.

4. Refer to the data in Required 3. How many stoves would have to be sold at the new selling price to attain a target profit of $74,000 per month?