Reference no: EM131166921
Capital Budgeting Decision
Project:
HamptonCompany: The production department has been investigating possible ways to trim total production costs. One possibility currently being examined is to make the cans instead of purchasing them. The equipment needed would cost $1,000,000, with a disposal value of $200,000, and would be able to produce 27,500,000 cans over the life of the machinery. The production department estimates that approximately 5,500,000 cans would be needed for each of the next 5 years.
The company would hire six new employees. These six individuals would be full-time employees working 2,000 hours per year and earning $15.00 per hour. They would also receive the same benefits as other production employees, 15% of wages in addition to $2,000 of health benefits.
It is estimated that the raw materials will cost 30¢ per can and that other variable costs would be 10¢ per can. Because there is currently unused space in the factory, no additional fixed costs would be incurred if this proposal is accepted.
It is expected that cans would cost 50¢ each if purchased from the current supplier. The company's minimum rate of return (hurdle rate) has been determined to be 11% for all new projects, and the current tax rate of 35% is anticipated to remain unchanged. The pricing for thecompany's products as well as number of units sold will not be affected by this decision. The unit-of-production depreciation method would be used if the new equipment is purchased.
Required:
1. Based on the above information and using Excel, calculate the following items for this proposed equipment purchase.
o Annual cash flows over the expected life of the equipment
o Payback period
o Simple rate of return
o Net present value
o Internal rate of return
The check figure for the total annual after-tax cash flows is $271,150.
2. Would you recommend the acceptance of this proposal? Why or why not? Prepare a short, double-spaced paper in MS Wordelaborating on and supporting your answer.
Attachment:- Sample Project Solution.xlsx
|
Heckscher-ohlin theorem
: According to the Heckscher-Ohlin theorem, trade arises are due to
|
|
Suppose economic boom causes incomes to increase
: Suppose an economic boom causes incomes to increase and at the same time drives up wages for the sales reps who work for the cell phone companies. Explain what will happen to the demand for and supply of phones and predict the direction of the change..
|
|
Trade opens between the two countries
: Assuming that Country A has a comparative advantage in wheat and Country B in wine, which of the following is true? a. The price of wheat in country B falls when trade opens between the two countries. b. The price of wine in country B falls when trad..
|
|
Why is values-based leadership so important to the influence
: Why is values-based leadership so important to the influence of culture? Does a symbolic act communicate more about company values than an explicit statement? Explain thoroughly.
|
|
Annual cash flows over the expected life of the equipment
: Calculate the items for proposed equipment purchase - Annual cash flows over the expected life of the equipment
|
|
Determine the setting
: Determine the setting for μ so that no more than 1% of the bottles of cough syrup prepared by this machine will be rejected.
|
|
Describe it is impact on your demand for new cell phone
: In the following examples, name the factor that affects demand and describe it's impact on your demand for a new cell phone.
|
|
Important economic-political-social issues
: What should we consider in microeconomics in today's three most important economic-political-social issues? Give solutions to 5 issues you think are important affecting our economy.
|
|
Compare the number of comparisons needed to sort lists
: Compare the number of comparisons needed to sort lists of n elements for n = 100, 1000, and 10,000 from the set of positive integers less than 1,000,000, where the elements are randomly selected positive integers, using the selection sort, the ins..
|