In: Accounting
Keller Construction is considering two new investments. Project
E calls for the purchase of earthmoving equipment. Project H
represents an investment in a hydraulic lift. Keller wishes to use
a net present value profile in comparing the projects. The
investment and cash flow patterns are as follows: Use Appendix B
for an approximate answer but calculate your final answer using the
formula and financial calculator methods.
  
| Project E | Project H | |||||||
| ($37,000 Investment) | ($35,000 Investment) | |||||||
| Year | Cash Flow | Year | Cash Flow | |||||
| 1 | $ | 9,000 | 1 | $ | 17,000 | |||
| 2 | 12,000 | 2 | 18,000 | |||||
| 3 | 18,000 | 3 | 17,000 | |||||
| 4 | 20,000 | |||||||
a. Determine the net present value of the projects
based on a zero percent discount rate.
Project E - ____________________
Project H - _____________________
b. Determine the net present value of the projects
based on a discount rate of 9 percent. (Do not round
intermediate calculations and round your answers to 2 decimal
places.)
  
Project E - ____________________
Project H - _____________________
c. If the projects are not mutually exclusive,
which project(s) would you accept if the discount rate is 9
percent?
  
| Project E | |
| Project H | |
| Both H and E | 
Net present value (NPV) = Present value of cash inflow - present value of cash outflow.
| Cash flow | Discounted cash flow | ||||
| 1 | 2 | 3 | 4 | 5 | |
| Year | Project E | Project H | Discount rate @9% | Project E (1*3) | Project H (2*3) | 
| 0 | ($37,000) | ($35,000) | 1 | ($37,000) | ($35,000) | 
| 1 | $9,000 | $17,000 | 0.9174 | $8,256.60 | $15,595.80 | 
| 2 | $12,000 | $18,000 | 0.8417 | $10,100.4 | $15,150.60 | 
| 3 | $18,000 | $17,000 | 0.7722 | $13,899.6 | $13,127.40 | 
| 4 | $20,000 | $0 | 0.7084 | $14,168 | $0 | 
| NPV at 0% | $22,000 | $17,000 | NPV at 9% | $9,424.60 | $8,873.80 | 
a) Determine the net present value of the projects based on a zero percent discount rate.
| Project E | $22,000 | 
| Project H | $17,000 | 
b) Determine the net present value of the projects based on a discount rate of 9 percent.
| Project E | $9,424.60 | 
| Project H | $8,873.80 | 
c) If the projects are not mutually exclusive, which project(s) would you accept if the discount rate is 9 percent?
Both H and E.