Question

2. Project P costs $35,800 and is expected to produce cash flows of $8,500 per year for six years. Project Q costs $90,000 anb. If the projects are independent, which project(s) should be selected? If they are mutually exclusive, which project should

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

a:

Project P Project Q
NPV 3494.48 7080.47
IRR 11.15% 10.55%
MIRR 9.69% 9.37%
Payback 4.21 4.29

b: If they are independent, select Both since both have positive NPVs

If they are mutually exclusive select Q since it has higher NPV.

Workings

Year Project P Cumulative CF Project Q Cumulative CF
0 -35800 -35800 -90000 -90000
1 8500 -27300 21000 -69000
2 8500 -18800 21000 -48000
3 8500 -10300 21000 -27000
4 8500 -1800 21000 -6000
5 8500 6700 21000 15000
6 8500 15200 21000 36000

Book1- Excel AutoSave Oi Sign in Comments Share O Tell me what you want to do File Home Formulas Review View Help Insert Draw

Add a comment
Know the answer?
Add Answer to:
2. Project P costs $35,800 and is expected to produce cash flows of $8,500 per year...
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
  • Please show all work. Must be completed using financial formulas, NO EXCEL. a. Calculate the NPV, IRR, MIRR, and traditional payback period for each project, assuming a required rate of return of 8%....

    Please show all work. Must be completed using financial formulas, NO EXCEL. a. Calculate the NPV, IRR, MIRR, and traditional payback period for each project, assuming a required rate of return of 8%. b. If the projects are independent, which project(s) should be selected? If they are mutually exclusive, which project should be selected? Project P costs $10,400 and is expected to produce cash flows of $3,650 per year for five years. Project Q costs $30,000 and is expected to...

  • Project S has a cost of $10,000 and is expected to produce benefits (cash flow) of...

    Project S has a cost of $10,000 and is expected to produce benefits (cash flow) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flow of $7,400 per year for 5 years. Calculate the two projects’ NPV, IRR, and MIRR, assuming a cost of capital of 12%. If these are two mutually exclusive projects, which project would be selected? Justify your answer(s).    HAND WRITE WORK PLEASE :)

  • 4. Project S has a cost of $10,000 and is expected to produce cash flows of...

    4. Project S has a cost of $10,000 and is expected to produce cash flows of $3000 per year for 5 years. Project L has a cost of $25,000 and is expected to produce cash flows of $7400 for 5 years. Calculate the NPV and IRR of the two projects assuming a cost of capital of 12%. Which project would you select, assuming they are mutually exclusive, using each ranking method?

  • Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...

    Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected the produce cash flows of $7,400 per year for 5 years. Calculate the two projects' NPVs, IRRs, MIRRs and Pls assuming a cost of capital of 12%? Which project would be selected assuming they are mutually exclusive, using each ranking method? Which project should actually be selected?

  • 2. Project S costs $10,000 and its expected cash flows would be $5,500 per year for...

    2. Project S costs $10,000 and its expected cash flows would be $5,500 per year for 5 years. Mutually exclusive Project L costs $45,000 and its expected cash flows would be $10,250 per year for 5 years. If both projects have a WACC of 15%, which project would you recommend? Select the correct answer. a. Both Projects S and L, since both projects have NPV's > 0. b. Both Projects S and L, since both projects have IRR's > 0....

  • Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of...

    Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,500 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $8,000 per year for 5 years. a. Calculate the two projects' NPVS, assuming a cost of capital of 14%. Round your answers to the nearest cent Project S Project L Which project would be selected, assuming they are mutually exclusive? -Select b. Calculate the two projects'...

  • Capital Budgeting Methods Project S has a cost of $9,000 and is expected to produce benefits...

    Capital Budgeting Methods Project S has a cost of $9,000 and is expected to produce benefits (cash flows) of $2,700 per year for 5 years. Project L costs $26,000 and is expected to produce cash flows of $7,100 per year for 5 years. Calculate the two projects' NPVs, assuming a cost of capital of 10%. Do not round intermediate calculations. Round your answers to the nearest cent. Project S: $   Project L: $   Which project would be selected, assuming they...

  • Project S costs $11,000 and its expected cash flows would be $4,500 per year for 5...

    Project S costs $11,000 and its expected cash flows would be $4,500 per year for 5 years. Mutually exclusive Project L costs $27,000 and its expected cash flows would be $7,500 per year for 5 years. If both projects have a WACC of 13%, which project would you recommend? Select the correct answer. I. Neither S or L, since each project's NPV < 0. II. Project L, since the NPVL > NPVS. III. Both Projects S and L, since both...

  • Project S costs $16,000 and its expected cash flows would be $4,500 per year for 5...

    Project S costs $16,000 and its expected cash flows would be $4,500 per year for 5 years. Mutually exclusive Project L costs $50,000 and its expected cash flows would be $12,200 per year for 5 years. If both projects have a WACC of 12%, which project would you recommend?

  • (Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year...

    (Discounted payback period) Gio's Restaurants is considering a project with the following expected cash flows: Year Project Cash Flow (millions) $(210) AWNO If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period? The project's discounted payback period is years. (Round to two decimal places.) (Mutually exclusive projects and NPV) You have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows: Project A Project B Year Cash Flow...

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