What function in Excel computes the internal rate of return on a project? A) ireturn B) rate C) returnrate D) irr
Added by Michael B.
Close
Step 1
Step 1: Open Excel and go to the cell where you want to compute the internal rate of return (IRR). Show more…
Show all steps
Your feedback will help us improve your experience
Jennifer Stoner and 88 other Chemistry 101 educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
What is the internal rate of return (IRR) on an investment? How is it determined?
You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IRR function: The cost of the investment is $500,000. Cash flows in years 1 through 5 are $200,000; $160,000; $120,000; $80,000; and $40,000, respectively. The residual value of the investment is $25,000. Using Excel's IRR function, what is the internal rate of return on the investment after 5 years
Manasvee S.
What is the internal rate of return (IRR) of a project that costs $20,070 if it is expected to generate $8,500 per year for 3 years? How to manually work it out if I don't use the IRR spreadsheet function.
Akash M.
Recommended Textbooks
Chemistry: Structure and Properties
Chemistry The Central Science
Chemistry
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD