Also see the attached file.
From article below answer the following question:
Internal rate of return (IRR) is the flip side of net present value (NPV) and is based on the same principles and the same math. NPV shows the value of a stream of future cash flows discounted back to the present by some percentage that represents the minimum desired rate of return, often a company's cost of capital. IRR, on the other hand, computes a break-even rate of return. It shows the discount rate below which an investment results in a positive NPV and above which an investment results in a negative NPV. It is the breakeven discount rate, the rate at which the value of cash outflows equals the value of cash inflows.
IRR is the flip side of net present value (NPV) and is based on the same principles and the same math. NPV shows the value of a stream of future cash flows discounted back to the present by some percentage that represents the minimum desired rate of return, often your company's cost of capital.
IRR, on the other hand, computes a break-even rate of return. It shows the discount rate below which an investment results in a positive NPV (and should be made) and above which an investment results in a negative NPV (and should be avoided). It's the breakeven discount rate, the rate at which the value of cash outflows equals the value of cash inflows.
Consider the three scenarios shown here (see table), each involving an initial investment of $1 million. The investment returns $300,000 (undiscounted) per year in each of the five years after the initial investment, for a net return of $500,000.
A company evaluating this investment using cash flow discounted at 10% would compute an NPV of $137,000, a decent but not spectacular result. But if the company evaluates the same investment at 15%, the project has a present value of only $6,000, essentially just breaking even, and at 20% the project's present value is negative. The IRR is a fraction of a percentage point above 15%; at that discount percentage, the investment's NPV is zero.
IRR is often used as a hurdle rate, a sort of go/no-go investment threshold. Gaylord Entertainment Co. in Nashville, for example, has computed its weighted average cost of capital -- a percentage that it won't disclose -- and a "hurdle" percentage rate a few points higher. An investment's IRR must generally equal or exceed the hurdle rate to be approved by management, says CIO Kent Fourman.
"We calculate the IRR and then compare that to our hurdle rate," Fourman says. "And we compare that IRR against every other [project's] IRR, because you always have limited cash."
But the IRR cutoff isn't an absolute test, he says. For example, management's subjective assessment of risk may influence an investment decision, he says. "But if you can't show that IRR exceeds our hurdle rate, then you'll have to have a lot of the soft justifications to get it approved," Fourman says.
Not everyone is as enthusiastic about IRR. Like NPV, it doesn't measure the absolute size of the investment or its return. And because of the way the math works, the timing of periods of negative cash flow can affect the value of IRR without accurately reflecting the underlying performance of the investment.
IRR can also produce misleading results because, as classically defined, it assumes that the cash returned from an investment is reinvested at the same percentage rate, which may not be realistic. That error is magnified when comparing two investments of different durations. Some software, such as Microsoft Excel, will compute an optional "modified IRR" that allows the user to specify a different reinvestment rate.
IRR becomes increasingly misleading the more it diverges from the cost of capital, says Ian Campbell, chief research officer at Nucleus Research Inc. in Wellesley, Mass. "IRR is a terrible metric, and it should never be used," he asserts.
The key metric for IT projects, Campbell says, is payback period, because it favors short-term, and hence less risky. projects that IT should be doing
Net Present Value (NPV) method:
Net present Value is the present value of all the cash flows discounted at the cost of Capital or rate of return. Generally, a project is acceptable if the Net present value is positive. This method considers the time value of money but is based on certain assumptions like the discount rate, receiving the cash flows etc. Some other versions of the Net present Value are the use of Annualized NPV and the Modified NPV which are used in different circumstances.
Internal Rate of Return (IRR) Method:
Internal Rate of Return is the discounting rate at which the Net present value is equal to zero. A project is acceptable when the internal ...
**Attached is the answer**