Question
In: Finance
Problem Six (15 marks) Use excel 123 Inc. is considering purchasing a new machine. The machine...
Problem Six
Use excel
123 Inc. is considering purchasing a new machine. The machine will cost $2,500,000. The machine will be used for a project that lasts 4 years. The expected salvage of the machine at the end of the project is $200,000. The machine will be used to produce widgets. The marketing department has forecasted that the company will be able to sell 180,000 widgets per year. The marketing department believes that the company will be able to charge $12 per widget. The production department, has indicated that the variable cost per widget will be $5. The company has forecasted that the incremental fixed costs associated with the project are $80,000. The company believes that the project will require an initial investment in operating net working capital of $60,000. Thereafter, the investment in operating net working capital will be 10% of sales.
The CCA rate is 30%, the tax rate is 26%, and the required rate of return is 10%.
- Using net present value (NPV) calculation, determine if the company should purchase the new machine. Show all work.
- 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.
- 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.
- 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 |
125,000 |
200,000 |
|
Price per unit |
$10 |
$15 |
|
Variable cost per unit |
$7 |
$4 |
|
Fixed Cost |
$120,000 |
$60,000 |
Solutions
jeff jeffy answered 1 year agoRelated Solutions
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...
A firm is considering purchasing a new machine, which costs $600,000 and has a six-year life,...
A firm is considering purchasing a new machine, which costs
$600,000 and has a six-year life, a CCA rate of 25 percent and an
expected salvage value of $40,000. The asset class will remain
open. The project will generate sales revenue of $200,000 in the
first year, which will grow at 6 percent per year in the subsequent
years. Variable costs will be $80,000 for the first year, which
will grow at 7 percent per year. The firm's marginal tax...
A firm is considering purchasing a machine that costs $69,000. It will be used for six...
A firm is considering purchasing a machine that costs $69,000.
It will be used for six years, and the salvage value at that time
is expected to be zero. The machine will save
$42,000 per year in labor, but it will incur $10,000 in
operating and maintenance costs each year. The machine will be
depreciated according to five-year MACRS. The firm's tax rate
is
35%, and its after-tax MARR is 11%. What is the present worth
of the project?
Nuff Folding Box Company, Inc. is considering purchasing a new gluing machine. The gluing machine costs...
Nuff Folding Box Company, Inc. is considering purchasing a new
gluing machine. The gluing machine costs $50,000 and requires
installation costs of $2,500. This outlay would be partially offset
by the sale of an existing gluer. The existing gluer originally
cost $10,000 and is four years old. It is being depreciated under
MACRS using a five-year recovery schedule and can currently be sold
for $15,000. The existing gluer has a remaining useful life of five
years. If held until year...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$243,257. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7:
Year
1
$390,900
2...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$245,090. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7:
Year 1 $389,800
2 399,800...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$240,164. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7: Year 1 $390,800 2...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$241,378. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7:
Year
1
$390,000
2...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$242,006. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7:
Year
1
$389,300
2...
Hillsong Inc. manufactures snowsuits. Hillsong is considering purchasing a new sewing machine at a cost of...
Hillsong Inc. manufactures snowsuits. Hillsong is considering
purchasing a new sewing machine at a cost of $2.45 million. Its
existing machine was purchased five years ago at a price of $1.8
million; six months ago, Hillsong spent $55,000 to keep it
operational. The existing sewing machine can be sold today for
$243,956. The new sewing machine would require a one-time, $85,000
training cost. Operating costs would decrease by the following
amounts for years 1 to 7:
Year
1
$391,000
2...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- What experience have you had with Organization Development or with Change Management? Describe the organization, the...
- 1. Renfro Rentals has issued bonds that have a 12% coupon rate, payable semiannually. The bonds...
- Given an array of positive integers a, your task is to calculate the sum of every...
- Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a...
- In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis...
- Increase all of the listing prices by 5% for all listings under $500,000 and 10% for...
- Samsung Industry that requires you to act as a change agent to form an organizational change...
ADVERTISEMENT