team project
As a financial advisor at RedHat International (RHI), you have been asked to evaluate two capital investment alternatives submitted by the shipping department. Before beginning your analysis, you note that company policy has set the minimum desired rate of return at 18% for all proposed projects. You also learn that the corporate tax rate is 26%.
The proposed capital project calls for the shipping department to fully automate a warehouse using one of two different advanced robotics systems. System A will incur development costs of $2,500,000. System B will cost $4,000,000 to develop. Both systems will be capitalized and amortized using a CCA rate of 30%. In addition, the firm believes that Net Working Capital will rise by $50,000 at time zero and then by an additional $10,000 at the end of each year for each year that the new system is operating (except at the end of the final year of the project). This applies to both alternatives. However, all of the increase in Net Working Capital will be recovered at the end of the project.
The Shipping Department intends to hire an outside consultant at a cost of $10,000 to help it choose which of the two alternatives would be most effective. If neither alternative is financially attractive, the consultant will be expected to point this out to the company. The amount paid to the consultant will be expensed at the time it is incurred.
To recover a portion of the development cost, the shipping department intends to charge the manufacturing department for the use of computer time at the rate of $150 per hour for 50 hours per year for each year of the project. This amount will remain the same under either alternative. RHI owns all of its computer equipment, which has significant spare capacity. The company plans to maintain this spare capacity into the future. However, it is company policy not to rent spare computer capacity to outside users due to security concerns.
If the new automated robotics system is put into use, the pre-tax cost savings each year are estimated as follows:
|
Year |
System A |
System B |
|
1 |
$1,500,000 |
$2,000,000 |
|
2 |
$1,200,000 |
$1,750,000 |
|
3 |
$1,000,000 |
$1,500,000 |
|
4 |
$ 950,000 |
$1,250,000 |
|
5 |
$ 900,000 |
$1,100,000 |
Answer
4. NPV of each alternative:
The six stages of capital budgeting are:
Step a. Identify the opportunities or projects:
Two advanced robotics systems have been identified - System A and B - to fully automate the warehouse.
Step b. Gather information relating to the opportunities:
|
|
System A |
System B |
|
Development costs |
$2,500,000 |
$4,000,000 |
|
CCA rate |
30% |
30% |
|
Net Working capital - year 0 |
$50,000 |
$50,000 |
|
Net Working capital - subsequent years |
$10,000 |
$10,000 |
Step c. Identify the cash-flows of the alternatives:
|
Pre-tax cost savings |
|
|
|
Year |
System A |
System B |
|
1 |
$1,500,000 |
$2,000,000 |
|
2 |
$1,200,000 |
$1,750,000 |
|
3 |
$1,000,000 |
$1,500,000 |
|
4 |
$950,000 |
$1,250,000 |
|
5 |
$900,000 |
$1,100,000 |
Step d. Identify the risks:
No specific information available on risks of these alternatives. Thus, it is assumed both the alternatives carry equal risks.
Step e. Choose the best alternatives:
NPV of System A is $521,371 which is higher than NPV of System B of $257,465.
Hence System A is to be selected.
Workings:
Step f : Implement the chosen alternative
Start implementing the development of system A.