Investment Evaluation Analysis
Widget Company is considering upgrading its manufacturing equipment. The Vice-President of Production has identified three possible actions Widget could take to accomplish the upgrade, though none is required. One option would upgrade their current equipment and the other two options would replace the existing equipment with purchases of new equipment. The review committee has asked you to review each of the options to identify relevant cost data and to prepare a schedule comparing the three options to see if any are worth implementing. Your analysis schedule is to include comparative relevant costs and a present value calculation.
Option One: Using this option Widget would upgrade their current equipment to make it more efficient. The equipment, which is three quarters depreciated but has reached the end of its projected useful life, would be upgraded at a cost of $75,000. The upgrades would extend the useful life of the equipment by 8 years. The cost of the upgrade would be depreciated over the new useful life and result is tax savings (a cash inflow) of $1,000 per year. At the end of its useful life, you estimate the equipment can be sold for $44,000.
Option Two: This option would require Widget to purchase new up-to-date equipment at a cost of $311,000. This new equipment would have an expected useful life of 6 years and result in an annual tax savings of $4,700. At the end of its useful life, it is estimated the new equipment can be sold for $135,600.
Option Three: Another equipment manufacturer has provided a proposal offering to supply a competing brand. Under this proposal, Widget would purchase the equipment for $257,000. This equipment has a 9 year useful life and an estimate $100,500 salvage value with an annual tax savings of $3,500.
Additional Information:
Required:
and the present value of each option (use PV and/or NPV function) (28 pts)
Your layout should distinguish between cash flows based on their
timing.
Use highlighting for input cells (5 pts)
Use appropriate titles/labels for columns and rows. (18
pts)
Use formulas wherever possible to eliminate user input errors
(users should not have to rekey input data where they must be the
same as other cells). (2 points)
Assume Widget can invest its money at a 9.5% annual interest rate and expects all capital projects to return this rate at a minimum. Also assume that all upfront costs are paid for immediately, but all other cash flows, including payments, occur at the end of the year.
2. Create a second worksheet that references the first one so that no numbers except the new interest rate have to be input to show the analysis. (35 pts)
Does your recommendation change if the
annual interest rate changes to 5%? (3
pts)
Particulars | Option - 1 | Option - 2 | Option - 3 |
Upgrade cost | $ 75,000 | ||
Purchase cost of new equipment | $ 311,000 | $ 257,000 |
Annual Cash inflow / (outflow) | |||
Option - 1 | Option - 2 | Option - 3 | |
[Yr. 1 - 8] | [Yr. 1 - 6] | [Yr. 1 - 9] | |
Annual Tax savings | $ 1,000 | $ 4,700 | $ 3,500 |
Maintenance cost | $ (19,800) | $ (15,500) | $ (17,000) |
Reduced material cost | $ 29,400 | $ 17,900 | $ 19,000 |
Increase in gross margin | $ 9,300 | $ 56,600 | $ 39,700 |
Net annual cash inflow / (outflow) | $ 19,900 | $ 63,700 | $ 45,200 |
Ans. 1:- Annual interest rate = 9.5% :-
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 9.5% | of cash flow | ||
1 | $ 19,900 | 0.9132 | $ 18,173.52 |
2 | $ 19,900 | 0.8340 | $ 16,596.82 |
3 | $ 19,900 | 0.7617 | $ 15,156.91 |
4 | $ 19,900 | 0.6956 | $ 13,841.93 |
5 | $ 19,900 | 0.6352 | $ 12,641.03 |
6 | $ 19,900 | 0.5801 | $ 11,544.32 |
7 | $ 19,900 | 0.5298 | $ 10,542.76 |
8 | $ 19,900 | 0.4838 | $ 9,628.09 |
8 | $ 44,000 | 0.4838 | $ 21,287.20 |
Total | $ 129,412.57 | ||
Less : Initial investment | $ (75,000.00) | ||
Net Present Value | $ 54,412.57 |
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 9.5% | of cash flow | ||
1 | $ 63,700 | 0.9132 | $ 58,173.52 |
2 | $ 63,700 | 0.8340 | $ 53,126.50 |
3 | $ 63,700 | 0.7617 | $ 48,517.35 |
4 | $ 63,700 | 0.6956 | $ 44,308.08 |
5 | $ 63,700 | 0.6352 | $ 40,464.00 |
6 | $ 63,700 | 0.5801 | $ 36,953.43 |
6 | $ 135,600 | 0.5801 | $ 78,661.56 |
Total | $ 360,204.44 | ||
Less : Initial investment | $ (311,000.00) | ||
Net Present Value | $ 49,204.44 |
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 9.5% | of cash flow | ||
1 | $ 45,200 | 0.9132 | $ 41,278.54 |
2 | $ 45,200 | 0.8340 | $ 37,697.30 |
3 | $ 45,200 | 0.7617 | $ 34,426.75 |
4 | $ 45,200 | 0.6956 | $ 31,439.96 |
5 | $ 45,200 | 0.6352 | $ 28,712.29 |
6 | $ 45,200 | 0.5801 | $ 26,221.27 |
7 | $ 45,200 | 0.5298 | $ 23,946.37 |
8 | $ 45,200 | 0.4838 | $ 21,868.83 |
9 | $ 45,200 | 0.4418 | $ 19,971.53 |
9 | $ 100,500 | 0.4418 | $ 44,400.90 |
Total | $ 309,963.73 | ||
Less : Initial investment | $ (257,000.00) | ||
Net Present Value | $ 52,963.73 |
Ans. 2:- Annual interest rate = 5% :-
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 5% | of cash flow | ||
1 | $ 19,900 | 0.9950 | $ 19,801.00 |
2 | $ 19,900 | 0.9901 | $ 19,702.48 |
3 | $ 19,900 | 0.9851 | $ 19,604.46 |
4 | $ 19,900 | 0.9802 | $ 19,506.93 |
5 | $ 19,900 | 0.9754 | $ 19,409.88 |
6 | $ 19,900 | 0.9705 | $ 19,313.31 |
7 | $ 19,900 | 0.9657 | $ 19,217.22 |
8 | $ 19,900 | 0.9609 | $ 19,121.62 |
8 | $ 44,000 | 0.9609 | $ 42,279.60 |
Total | $ 197,956.49 | ||
Less : Initial investment | $ (75,000.00) | ||
Net Present Value | $ 122,956.49 |
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 5% | of cash flow | ||
1 | $ 63,700 | 0.9950 | $ 63,383.08 |
2 | $ 63,700 | 0.9901 | $ 63,067.75 |
3 | $ 63,700 | 0.9851 | $ 62,753.98 |
4 | $ 63,700 | 0.9802 | $ 62,441.77 |
5 | $ 63,700 | 0.9754 | $ 62,131.11 |
6 | $ 63,700 | 0.9705 | $ 61,822.00 |
6 | $ 135,600 | 0.9705 | $ 131,599.80 |
Total | $ 507,199.49 | ||
Less : Initial investment | $ (311,000.00) | ||
Net Present Value | $ 196,199.49 |
Year | Cash inflow / (outflow) | Discount factor | Present value |
@ 5% | of cash flow | ||
1 | $ 45,200 | 0.9950 | $ 44,975.12 |
2 | $ 45,200 | 0.9901 | $ 44,751.37 |
3 | $ 45,200 | 0.9851 | $ 44,528.72 |
4 | $ 45,200 | 0.9802 | $ 44,307.19 |
5 | $ 45,200 | 0.9754 | $ 44,086.75 |
6 | $ 45,200 | 0.9705 | $ 43,867.42 |
7 | $ 45,200 | 0.9657 | $ 43,649.17 |
8 | $ 45,200 | 0.9609 | $ 43,432.01 |
9 | $ 45,200 | 0.9561 | $ 43,215.93 |
9 | $ 100,500 | 0.9561 | $ 96,088.05 |
Total | $ 492,901.74 | ||
Less : Initial investment | $ (257,000.00) | ||
Net Present Value | $ 235,901.74 |
Investment Evaluation Analysis Widget Company is considering upgrading its manufacturing equipment. The Vice-President of Production has...
Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows....
P12.3A (LO 2, 3, 4), AN Service Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its main- tenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The...
Questions #1 Storey, Inc. is considering the purchase and installation of new manufacturing equipment to replace its old, worn-out equipment. The following information is available. 1. Useful life of the new equipment, 8 years. 2. Cost of new equipment, $3,600,000. 3. Cost to set up new equipment, $200,000. 4. Estimated selling price of the new equipment at the end of its useful life, $60,000. 5. Annual operating savings, $700,000. 6. Working capital investment required, $600,000. This amount will be released...
Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows....
Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows....
Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows....
Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the cash flows....
13. A manufacturing company, called "Manufacturing Co", must purchase new equipment for one of its assembly lines. Three different options (A, B, and C) are under consideration. Option A, which has an acquisition cost of $110,000, is standard equipment that has already been on the market for a number of years. Options B and C are new equipment recently developed by a new company, called "EquipmentCo". EquipmentCo will offer a reduced price of $75,000 for option B and $25,000 for...
Marston Manufacturing Company is considering a project that requires an investment in new equipment of $3,200,000, with an additional $160,000 in shipping and installation costs. Marston estimates that its accounts receivable and inventories need to increase by $640,000 to support the new project, some of which is financed by a $256,000 increase in spontaneous liabilities (accounts payable and accruals). The total cost of Marston's new equipment is and consists of the price of the new equipment plus the In contrast,...
Problem 25-03A Brooks Clinic is considering investing in new heart-monitoring equipment. It has two options. Option A would have an initial lower cost but would require a significant expenditure for rebuilding after 4 years. Option B would require no rebuilding expenditure, but its maintenance costs would be higher. Since the Option B machine is of initial higher quality, it is expected to have a salvage value at the end of its useful life. The following estimates were made of the...