Question

123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will...

123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $800,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge $22 per widget. The production department, has indicated that the variable cost per widget will be $9. The company has forecasted that the incremental fixed costs associated with the project are $120,000 per year. The company believes that the project will require an initial investment in operating net working capital of $160,000. Thereafter, the investment in operating net working capital will be 8% of sales. Assume the asset class remains open.

The CCA rate is 30%, the tax rate is 24%, and the required rate of return is 8%.

  1. Using net present value (NPV) calculation, determine if the company should purchase the new machine. Show all work.
  2. Your boss has a number of concerns regarding the project. Therefore, she has asked you to determine the number of units that the company must sell each year for the NPV to be greater than zero.
  3. Your boss has also asked you to determine which input (units sold, price per unit, variable cost per unit, or fixed cost) has the greatest forecasting risk. Therefore, your boss has asked you to do a sensitivity analysis. Your boss wants you to vary the input forecast by 10% and determine the impact on the NPV of the project. Based on this analysis you are to determine which input has the greatest forecasting risk.
  4. Finally, your boss has asked you to perform a scenario analysis. Therefore, your boss has asked to include two new scenarios. A pessimistic scenario and an optimistic scenario. Your boss wishes to know the NPV of the project under these two additional scenarios. The value of the inputs for each scenario are shown in the table below.

Pessimistic

Optimistic

Units sold

180,000

400,000

Price per unit

$16

$32

Variable cost per unit

$12

$7

Fixed Cost

$150,000

$80,000

Please show calculations through excel.

Homework Answers

Answer #1

a) NPV Calculation

The same with Excel Formulas shown:

b) Minimum Required Units

The same with Excel Formulas shown:

c) Calculation of Forecasting Risk

The same with Excel Formulas shown:

The same with Excel Formulas shown:

Price per unit has the highest forecasting risk

d) Scenario Analysis

The same with Excel Formulas shown:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will...
123 Inc. is considering purchasing a new machine. The machine will cost $3,250,000. The machine will be used for a project that lasts 3 years. The expected salvage of the machine at the end of the project is $800,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 280,000 widgets per year. The marketing department believes that the company will be able to charge $22 per widget. The...
Joe is considering the purchase of a new machine that will produce widgets. The widget maker...
Joe is considering the purchase of a new machine that will produce widgets. The widget maker will require an initial investment of $10,000 and has an economic life of five years and will be fully depreciated by the straight line method. The machine will produce 1,500 widgets per year with each costing $2.00 to make. Each will be sold at $4.50. Assume Joe uses a discount rate of 14 percent and has a tax rate of 34 percent. What is...
1. Cardillo Corp is considering buying a new piece of manufacturing equipment. The new piece of...
1. Cardillo Corp is considering buying a new piece of manufacturing equipment. The new piece of equipment will increase their ability to manufacture widgets by 11,000 units per year. They sell widgets for $31 per unit, and the cost of goods sold per unit (consider this as cash) is $17 per unit. Additionally, Cardillo Corp will have to pay cash for the additional costs associated with this new equipment per year: $20,000 for utilities, $4,500 for maintenance costs, and $61,500...
King’s Department Store is contemplating the purchase of a new machine at a cost of $22,000....
King’s Department Store is contemplating the purchase of a new machine at a cost of $22,000. The machine will provide $3,500 per year in cash flow for nine years. King’s has a cost of capital of 10%. Calculate NPV of the project.
You make widgets that attach to your main product which is a whatchamacallit. You have identified...
You make widgets that attach to your main product which is a whatchamacallit. You have identified another company from whom you could buy widgets and then you would not have to make them for yourself. Below are your cost for making widgets, calculate which cost as Avoidable and which are Unavoidable and the Avoidable and unavoidable Cost Per Widget. Total in House Avoidable Unavoidable Loan on Widget Making Machine $50,000 Wages of Widget Makers $150,000 Raw Materials for Widgets $37,000...
The Sisyphean Corporation is considering investing in a new machine that has an estimated life of...
The Sisyphean Corporation is considering investing in a new machine that has an estimated life of three years. The cost of the machine is $50,000 and the machine will be depreciated straight line over its three-year life to a residual value of $0. The machine will result in sales of 3,000 widgets in year 1. Sales are estimated to grow by 9% per year each year through year three. The price per widget that Sisyphean will charge its customers is...
You are the financial analyst for a tennis racket manufacturer. The company is considering using a...
You are the financial analyst for a tennis racket manufacturer. The company is considering using a graphitelike material in its tennis rackets. The company has estimated the information in the following table about the market for a racket with the new material. The company expects to sell the racket for four years. The equipment required for the project has no salvage value and will be depreciated on a straight-line basis. The required return for projects of this type is 12...
Emily’s Napkins and Accessories, Inc. is considering making an investment in a new production machine. The...
Emily’s Napkins and Accessories, Inc. is considering making an investment in a new production machine. The firm has estimated that the machine has a useful life of three years. At the end of the three years, you expect all of your investment to be worthless. The total investment required to open this enterprise is $12,000. Your after–tax cash flow is expected to be $3,000 per year and your required rate of return for this project is 12 percent. A.What is...
XYZ corp. is considering investing in a new machine. The new machine cost will $ 8,000...
XYZ corp. is considering investing in a new machine. The new machine cost will $ 8,000 installed. Depreciation expense on the new machine will be $ 1,200 per year for the next five years. At the end of the fifth year XYZ expects to sell the machine for $3000. XYZ will also sell its old machine today that has a book value of $4000 for $4000. The old machine has depreciation expense of $800 per year and zero salvage value....
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an...
A company is considering a new project requiring an upfront fixed-asset investment of $1,000,000 with an economic life of five years. Depreciation is taken on a straight-line basis, with no expected salvage value. Net working capital required immediately is expected to be $100,000 and will be recovered in full upon the project's completion in five years. In the pessimistic-scenario forecast, the annual sales volume is 44,700 units, while the sale price is $143 per unit with a variable cost of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT