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.
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.