Question
Compute the sum of the two IRRs
4. The following cash-flow pattern has two IRRs. Use Excel to draw a graph of the NPV of these cash flows as a function of th
1 0
Add a comment Improve this question Transcribed image text
Answer #1

Year Cash Flow PV Factor Present Value

0 (500) 1 (500)

1 600 .8333 500

2 300 .6944 208

3 300 .579 174

4 200 .482 96

5   (1000) .402   (402)

NPV 76

Since NPV(Net present value is positive the investment in project should be done.

Add a comment
Know the answer?
Add Answer to:
Compute the sum of the two IRRs 4. The following cash-flow pattern has two IRRs. Use...
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 use excel, need help with functions because I am only used to using a financial...

    Please use excel, need help with functions because I am only used to using a financial calculator, thanks! The following cash-flows have two IRRs. Draw a graph of the NPV of these cash flows as a function of the discount rate. Then use the IRR function to identify the two IRRs. Would you invest in this project if the opportunity cost were 20%? Year Cash Flow 0 -500 1 600 2 300 3 300 4 200 5 -1,000

  • Geraldine Consultants, Inc. is considering a project that has the following cash flows: Year Cash Flow...

    Geraldine Consultants, Inc. is considering a project that has the following cash flows: Year Cash Flow 0 -$1,000 1 400 2 300 3 500 4 400 The company's WACC is 10%. What are the project's payback, internal rate of return, and net present value? Select one: a. Payback = 2.6, IRR = 21.22%, NPV = $300. b. Payback = 2.4, IRR = 21.22%, NPV = $260. c. Payback = 2.6, IRR = 24.12%, NPV = $300. d. Payback = 2.4,...

  •  Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern....

     Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern. Year Cash Flow 0 ​$100 1 −460 2 791 3 −602.6 4 171.6 a. Calculate the​ project's NPV at each of the following discount​ rates: 0​%, 5​%, 10​%, 20​%, 30%​, 40​%, 50​%. b. What do the calculations tell you about this​ project's IRR? The IRR rule tells managers to invest if a​ project's IRR is greater than the cost of capital. If Acme​ Oscillators'...

  • 4. Consider a ten-year project with an after-tax cash flow of $11 in year t=1. You...

    4. Consider a ten-year project with an after-tax cash flow of $11 in year t=1. You expect a constant growth rate of g=10% for the next ten years. The initial outflow is $100 in year t=0. (a) What is the internal rate of return (IRR) on the project? (b) According to the IRR rule, would you invest in this project at a cost of capital equal to 5%? (c) A project can have only one NPV but multiple IRRs. True...

  • Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern....

    Acme Oscillators is considering an investment project that has the following rather unusual cash flow pattern. Year Cash Flow 0 ​$100 1 −460 2 791 3 −602.6 4 171.6 a. Calculate the​ project's NPV at each of the following discount​ rates: 30%​, 40​%, 50​%. b. What do the calculations tell you about this​ project's IRR? The IRR rule tells managers to invest if a​ project's IRR is greater than the cost of capital. If Acme​ Oscillators' cost of capital is...

  • Your firm is considering two projects with the following cash flows: Cash flows from project B...

    Your firm is considering two projects with the following cash flows: Cash flows from project B (£000) (500) 200 250 170 25 30 Year Cash flows from project A (£000) 0(500) 167 180 160 100 100 4 1. Calculate the ARR and payback rule 2. If the appropriate discount rate is 12%, rank the two projects 3. Which project is preferred if you rank by IRR? 4. Calculate the discount rate (r) for which the NPVs of both projects are...

  • Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR...

    Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR Cash Flow......($200).....$850....($700)......15% What is the best decision for Project Theta (accept or reject) if the project’s required rate of return is 15% and why? a. Accept the project because the payback is short b. Accept the project because the NPV is greater than zero c. Reject the project because the IRR is less than the required rate of return d. Reject the project because...

  • 11. Beta Co. is considering two mutually exclusive projects to invest in per the Cash Flows...

    11. Beta Co. is considering two mutually exclusive projects to invest in per the Cash Flows and IRRs below. The Discount Rate (MARR) for Beta Corp. is 18% APR compounded annually. Project #1 Year Cash Flow -$14,000 +$17,000 +$1,400 IRR: 29.17% Project #2 Y ear: Cash Flow: IRR: -$10,000 +$13,000 +S400 33.01% Which of the two Projects (if any) should Beta invest in? (Show your work and the basis for your answer. No credit for answer only!) (5 Pts)

  • Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel...

    Compute the Modified IRR (MIRR) of the following cash flow schedule using the =IRR( ) Excel function Why is your answer different than in Q4? What are you assuming about the company's project? The discount rate is 11.9% Time 0 1 2 3 4 5 6 CFs -200 -100 0 120 120 120 100

  • 16) You are offered an investment that will pay the following cash flows at the end...

    16) You are offered an investment that will pay the following cash flows at the end of each of the next five years at a cost of $800. What is the Net Present Value (NPV) if the required rate of return is 12% per year? Period Cash Flow 0 $0 1 $100 2 $200 3 $300 4 $400 5 $500 Remember that Excel’s NPV function doesn't really calculate the net present value. Instead, it simply calculates the present value of...

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