Question

Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck is $19,000 and that for the pulley system is $20,000. The firm's cost of capital is 12%. After-tax cash flows, including depreciation, are as follows:

Year Truck Pulley
1 $5,100 $7,500
2 5,100 7,500
3 5,100 7,500
4 5,100 7,500
5 5,100 7,500

Required:
a. Calculate the IRR for each project.
b. What is the correct accept/reject decision for this project?
c. Calculate the NPV for each project. Round your answers to the nearest dollar, if necessary.
d. What is the correct accept/reject decision for this project?

Answer 1

Answer:

Find attached excel file

Explanation:

The internal rate of return is the discount rate at which the present value of future cash flows is the same as the initial investment outlay, which can be determined using excel the IRR function shown below:

=IRR(values)

values are the cash flows from initial investment outlay up until the cash inflow in year 5.

The net present value is the present value of future cash flows discounted at the firm's cost of capital minus the initial investment outlay