At Westonci.ca, we provide clear, reliable answers to all your questions. Join our vibrant community and get the solutions you need. Discover in-depth answers to your questions from a wide network of experts on our user-friendly Q&A platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

5. Use excel?s irr function for this problem. Rancho cucamonga has a 6% cost of capital. The firm has an investment opportunity that costs $2,000. Riverside expects the investment to generate annual cash inflows $600 for each of the next four years. The internal rate of return and rancho?s decision are a. 1. 7% and invest in the project. B. 1. 7% and don?t invest in the project. C. 7. 7% and invest in the project. D. 7. 7% and don?t invest in the project.

Sagot :

IRR function for this problem is 7. 7% and invest in the project

What is IRR function?

The Excel IRR function returns the internal rate of return (IRR) for a sequence of cash flows that occur at regular intervals. Determine the internal rate of return. Return was calculated as a percentage. =IRR (values, [guess])

IRR is the interest rate at which the sum of all cash flows equals zero, thus it is useful for comparing one investment to another. In the preceding example, if we substitute 8% with 13.92%, the NPV becomes 0, and your IRR becomes zero. As a result, IRR is defined as the discount rate at which a project's NPV becomes zero.

To know more about IRR function follow the link:

brainly.com/question/24301559

#SPJ4

We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. We appreciate your time. Please revisit us for more reliable answers to any questions you may have. Find reliable answers at Westonci.ca. Visit us again for the latest updates and expert advice.