Question

9. The Ott Group, Inc., has identified the following two mutually exclusive projects: Year 0 Cash Flow (S) - $12,500 4,000 5,please show full steps of the solution for full credit. not excel solutions please. thank you!!!

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

a)

Project S:

IRR is the rate of return that makes initial investment equal to present value of cash inflows

12500 = 4000 / (1 + r)1 + 5000 / (1 + r)2 + 6000 / (1 + r)3 + 1000 / (1 + r)4

Using trial and error method, i.e., after trying various values for R, let try R as 11.85%

12500 = 4000 / (1 + 0.1185)1 + 5000 / (1 + 0.1185)2 + 6000 / (1 + 0.1185)3 + 1000 / (1 + 0.1185)4

12500 = 12500

Therefore, IRR of project S is 11.85%

Project L:

IRR is the rate of return that makes initial investment equal to present value of cash inflows

12500 = 1000 / (1 + r)1 + 6000 / (1 + r)2 + 5000 / (1 + r)3 + 4000 / (1 + r)4

Using trial and error method, i.e., after trying various values for R, let try R as 9.53%

12500 = 1000 / (1 + 0.0953)1 + 6000 / (1 + 0.0953)2 + 5000 / (1 + 0.0953)3 + 4000 / (1 + 0.0953)4

12500 = 12500

Therefore, IRR of project L is 9.53%

Project S should be accepted as it has the higher IRR

b)

Project S:

NPV = Present value of cash inflows - present value of cash outflows

NPV = -12500 + 4000 / (1 + 0.11)1 + 5000 / (1 + 0.11)2 + 6000 / (1 + 0.11)3 + 1000 / (1 + 0.11)4

NPV = $207.60

Project L:

NPV = Present value of cash inflows - present value of cash outflows

NPV = -12500 + 1000 / (1 + 0.11)1 + 6000 / (1 + 0.11)2 + 5000 / (1 + 0.11)3 + 4000 / (1 + 0.11)4

NPV = -438.48

Project S should be accepted as it has a positive NPV

Add a comment
Know the answer?
Add Answer to:
please show full steps of the solution for full credit. not excel solutions please. thank you!!!...
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
  • 9. The Ott Group, Inc., has identified the following two mutually exclusive projects: Year 0 Cash...

    9. The Ott Group, Inc., has identified the following two mutually exclusive projects: Year 0 Cash Flow (S) - $12,500 4,000 5,000 6,000 1,000 Cash Flow (L) - $12,500 1,000 6,000 5,000 4,000 a. What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? b. If the required return is 11 percent, what is the NPV for each of these projects? Which project will you choose if you...

  • please show full work step by step for full points and not excel workings. thank you!! 10. Consider the following two mu...

    please show full work step by step for full points and not excel workings. thank you!! 10. Consider the following two mutually exclusive projects: Year Cash Flow (A) - $175,000 10,000 25,000 25,000 375,000 Cash Flow (B) - $20,000 10,000 5,000 3,000 1,000 Whichever project you choose, if any, you require a 15 percent return on your investment. a. If you apply the payback criterion, which investment will you choose? b. If you apply the NPV criterion, which investment will...

  • Bumble's Bees, Inc., has identified the following two mutually exclusive projects: Cash Flow (A) ...

    PLEASE SHOW WORK AND CALCULATIONS THANKS Bumble's Bees, Inc., has identified the following two mutually exclusive projects: Cash Flow (A) Cash Flow (B) Year 0 17,000 8,000 7,000 5,000 3,000 17,000 2,000 5,000 4 What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? Is this decision necessarily correct? If the required return is 11%, what is the NPV for each of these projects? which project will you...

  • NPV versus IRR Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow...

    NPV versus IRR Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$77,500 -$77,500 43,000 21,500 29,000 28,000 23,000 34,000 21,000 41,000 a. What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? Is this decision necessarily correct? b. If the required return is 11 percent, what is the NPV for each of these projects? Which project will you choose...

  • NOTE: SUBJECT BUSINESS FINANCE SOLUTION REQUIRED ON THE SAME PAGE PLEASE AND NEED CORRECT SOLUTION Alfa...

    NOTE: SUBJECT BUSINESS FINANCE SOLUTION REQUIRED ON THE SAME PAGE PLEASE AND NEED CORRECT SOLUTION Alfa Corporation has identified the following two mutually exclusive projects. The CFO of the company wants to evaluate the identified projects. For this purpose he asked Mr. Naveed to evaluate those projects and establish their feasibility with the help of different capital budgeting techniques. Following are the details of the two mutually exclusive projects. Period Project A Project B (Rs.) (Rs.) 0 -42,000 -42,000 1...

  • Senior management asks you to recommend a decision on which project(s) to accept based on the...

    Senior management asks you to recommend a decision on which project(s) to accept based on the cash flow forecasts provided.The firm uses a 3-year cutoff when using the payback method. The hurdle rate used to evaluate capital budgeting projects is 15%. Assume the projects are mutually exclusive and answer the following: Which project(s) would you accept based on the payback criterion? Which projects would you accept based on the IRR criterion? Which projects would you accept based on the NPV...

  • 2 Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash...

    2 Piercy, LLC, has identified the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$ 77.500 43,000 29,000 23,000 21,000 -$ 77.500 10 points 21,500 28,000 34,000 41,000 2 00.25.04 4 eBook a-1. What is the IRR for each of these projects? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) a-2.If you apply the IRR decision rule. which project should the company accept? b-1. Assume...

  • please use excel formula, Thank You in advance Garage, Inc., has identified the following two mutually...

    please use excel formula, Thank You in advance Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? A 0 Year o Year 1 Year 2 Year 3 Year 4 0 (43,500) 21,400 18,500 13,800 7,600 $ (43,500) 6,400 14,700 22,800 25,200 0 $ 0 Required return...

  • 12. NPV versus IRR (LO1, 5) Parkallen Inc. has identified the following two mutually exclusive projects:...

    12. NPV versus IRR (LO1, 5) Parkallen Inc. has identified the following two mutually exclusive projects: m Cash Flow (A) Cash Flow (B) Year -$29,000 14,400 -$29000 0 1 4,300 2 12,300 q.800 4.200 15,200 4 5,100 16,800 Click here for a description of Table: Questions and Problems 12. a. What is the IRR for each of these projects? Using the IRR decision rule, which project should the company accept? Is this decision necessarily correct? b. If the required return...

  • PLEASE ANSWER A-D WITH WORK, THANK YOU! 2. Consider the following two mutually exclusive projects: Year Cash Flow...

    PLEASE ANSWER A-D WITH WORK, THANK YOU! 2. Consider the following two mutually exclusive projects: Year Cash Flow A Cash Flow B 0 $-318,844 $-27,476 1 $27,700 $9,057 2 $56,000 $10,536 3 $55,000 $11,849 4 $399,000 $13,814 The required return is 15 percent for both projects. Based on NPV rule, Reject or Accept? Based on IRR rule, Reject or Accept? Based on PI, Accept or Reject? Which rule in this case would be preferred?

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