Question

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 7,500

Calculate the IRR for each project. Do not round intermediate calculations. Round your answers to two decimal places.

Truck:   %

What is the correct accept/reject decision for this project?
Based on the IRR, this project should be -Select-acceptedrejectedItem 2 .

Pulley:   %

What is the correct accept/reject decision for this project?
Based on the IRR, this project should be -Select-acceptedrejectedItem 4 .

Calculate the NPV for each project. Do not round intermediate calculations. Round your answers to the nearest dollar. Use a minus sign to enter negative values, if any.

Truck: $   

What is the correct accept/reject decision for this project?
Based on the NPV, this project should be -Select-acceptedrejectedItem 6 .

Pulley: $   

What is the correct accept/reject decision for this project?
Based on the NPV, this project should be -Select-acceptedrejectedItem 8 .

Calculate the MIRR for each project. Do not round intermediate calculations. Round your answers to two decimal places.

Truck:   %

What is the correct accept/reject decision for this project?
Based on the MIRR, this project should be -Select-acceptedrejectedItem 10 .

Pulley:   %

What is the correct accept/reject decision for this project?
Based on the MIRR, this project should be -Select-acceptedrejectedItem 12 .

1 0
Add a comment Improve this question Transcribed image text
Answer #1

Using excel formula to calculate IRR,NPV,MIRR

A B
Year Project A Project B
1 0 -18000 -22000
2 1 5100 7500
3 2 5100 7500
4 3 5100 7500
5 4 5100 7500
6 5 5100 7500
IRR 12.86% 20.88%
Using excel formula IRR(A1:A6) IRR(B1:B6)
NPV ($491.29) $3,748.11
Using excel formula NPV(14%,A2:A6)+A1 NPV(14%,B2:B6)+B1
MIRR 13.37% 17.64%
Using excel formula MIRR(A1:A6,14%,14%) MIRR(B1:B6,14%,14%)

Based on IRR Pulley project should be accepted because IRR is higher
Based on NPV Pulley project should be accepted because NPV is higher
Based on MIRR project Pulley project should be accepted because MIRR is higher

Add a comment
Know the answer?
Add Answer to:
NPVs, IRRs, and MIRRs for Independent Projects Edelman Engineering is considering including two pieces of equipment,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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 $19.000 and that for the puley system is $20,000. The firm's cost of capitals 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,100...

  • Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this yea...

    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 yea...

    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....

  • *accept/reject decision for each NPVS IRRs and MIRRs for Independent Projects - 3 points Edelman Engineering...

    *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,...

    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...

  • Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system,...

    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....

  • Score: /12 Attempts: 11. Problem 10-08 eBook Problem 10-08 NPVS, IRRs, and MIRRs for Independent Projects...

    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...

  • Part C: Calculate MIRR for Puley also. Its cut off from the picture. Thanks Problem 10-08...

    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...

  • . NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.) NPV A project has an initial...

    . NEED ANSWER ASAP / ANSWER NEVER USED BEFORE a.) NPV A project has an initial cost of $60,000, expected net cash inflows of $11,000 per year for 9 years, and a cost of capital of 10%. What is the project's NPV? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to the nearest cent. $   b.) NPVs and IRRs for Mutually Exclusive Projects Davis Industries must choose between a gas-powered and an electric-powered...

  • for the truck $17,100 and that for the pulley system is $27,430. The firm's cost of...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT