The IRR is the discount rate r that makes a project have an NPV of $0. You

Question:

The IRR is the discount rate r that makes a project have an NPV of $0. You can find IRR in Excel with the built-in IRR function, using the syntax = IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax = IRR(range of cash flows, guess), where “guess” is your best guess for the IRR. It is best to try a range of guesses (say, 290% to 100%). Find the IRR of the project described in Problem 34.

Discount Rate
Depending upon the context, the discount rate has two different definitions and usages. First, the discount rate refers to the interest rate charged to the commercial banks and other financial institutions for the loans they take from the Federal...
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science

ISBN: 978-1305250901

5th edition

Authors: Wayne L. Winston, Christian Albright

Question Posted: