Using Excel to calculate
| Truck | Pulley | ||
| Year | Project A | Project B | |
| 1 | 0 | -19000 | -20000 |
| 2 | 1 | 5100 | 7500 |
| 3 | 2 | 5100 | 7500 |
| 4 | 3 | 5100 | 7500 |
| 5 | 4 | 5100 | 7500 |
| 6 | 5 | 5100 | 7500 |
| IRR | 10.68% | 25.41% | |
| Using excel formula | IRR(A1:A6) | IRR(B1:B6) | |
| NPV | -615.64 | $7,035.82 | |
| Using excel formula | NPV(12%,A2:A6)+A1 | NPV(12%,B2:B6)+B1 | |
| MIRR | 12.15% | 19.91% | |
| Using excel formula | MIRR(A1:A6,14%,14%) | MIRR(B1:B6,14%,14%) |
Based on IRR of truck it should be rejected
Based on IRR of Pulley it should be accepted
Based on NPV of Truck it should be rejected since it is
negative
Based on NPV of Pulley it should be accepted since it is
positive
NPVS, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces of equipment,...
NPVs, IRRs, and MIRRs for Independent Projects 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 $18,000 and that for the pulley system is $22,000. The firm's cost of capital is 14%. 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...
*accept/reject decision for each
NPVS IRRs and MIRRs for Independent Projects - 3 points 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 $17,100 and that for the pulley system is $22,430. The firm's cost of capital is 14%. After tax cash flows including depreciation are as follows: Year Truck Pulley 1 5,100 7,500 2 5,100 7,500...
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 $15,000 and that for the pulley system is $21,000. The firm's cost of capital is 11%. 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 Calculate the IRR for each project....
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 $17,100 and that for the pulley system is $22,430. The firm's cost of capital is 14%. 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 Calculate the IRR for each project....
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 $15,000 and that for the pulley system is $21,000. The firm's cost of capital is 11%. 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 Calculate the IRR for each project....
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 $18,000, and that for the pulley system is $22,000. The firm's cost of capital is 14%. 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 Calculate the IRR, the NPV, and...
Score: /12 Attempts: 11. Problem 10-08 eBook Problem 10-08 NPVS, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in tax cash flows, including depreciation, are as follows: Pulley $7,500 Year Truck $5,100 5,100 5,100 5,100 5,100 7,sv0 7,500 7,500 7,500 a. Calculate the IRR for each project Round your answers to two decimal places. Truck: what is the correct accept/reject decision for this project? Pulley: What...
Edelman engineering is considering two pieces of equipment, a truck and an overhead pulley system, in this years capital budget. The projects are independent. the cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firms cost of capital is 14%. After tax flows, including depreciation, are as follows: year: 1. 2. 3. 4. 5 truck 5,100 5,100 5,100 5,100 5,100 pulley. 7500 7500 7500 7500 7500 1. Calculate the IRR for each project....
Part C: Calculate MIRR for Puley also. Its cut off from the
picture.
Thanks
Problem 10-08 NPVS, IRRS, and MIRRS for Independent Projects 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 $17,100 and that for the pulley system is $22,430. The firm's cost of capital is 14 %. After - tax cash flows, including depreciation, are...
for the truck $17,100 and that for the pulley system is $27,430. The firm's cost of capital is Problem 10-09 NPVS, IRRS, and HTRRS for Independent Projects Fidelman Engineering is considering including two pieces of equlament, a truck and an overhead pullay system, In this year's capital budget. The projects are independent. The cash out 14%. After-tax cash flons, induding depreciation, are as follows: Year Truck Pulley $5.100 $7,500 5,100 7,500 5,100 5.100 7.500 5,100 7,500 a. Calculate the IRR...