Chapter 8. Internal Rate of Return
How can I find the IRR of cash flows?
Does a project always have a unique IRR?
Are there conditions that guarantee a project will have a unique IRR?
If two projects each have a single IRR, how do I use the projects’ IRRs?
How can I find the IRR of irregularly-spaced cash flows?
What is the MIRR and how do I compute it?
The net present value (NPV) of a sequence of cash flows depends on the interest rate (r) used. For example, if we consider cash flows for Projects 1 and 2 (see the worksheet IRR in the file IRR.xlsx, shown in Figure 8-1), we find that for r=0.2, Project 2 has a larger NPV, and for r=0.01, Project 1 has a larger NPV. When we use NPV to rank investments, the outcome can depend on the interest rate. It ...
Get Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
