
Net Present Value And Internal Rate Of Return  Internal Rate Of Return
The internal rate of return (IRR) is frequently used by corporations to compare and decide between capital projects. The IRR is the interest rate (also known as the discount rate) that will bring a series of cash flows (positive and negative) to a net present value (NPV) of zero (or to the current value of cash invested). Using IRR to obtain net present value is known as the discounted cash flow method of financial analysis. (For more insight, read the Discounted Cash Flow Analysis tutorial.)
For example, a corporation will evaluate an investment in a new plant versus an extension of an existing plant based on the IRR of each project. In such a case, each new capital project must produce an IRR that is higher than the company's cost of capital. Once this hurdle is surpassed, the project with the highest IRR would be the wiser investment, all other factors (including risk) being equal.
Calculation Complexities
The IRR formula can be very complex depending on the timing and variances in cash flow amounts. Without a computer or financial calculator, IRR can only be computed by trial and error. One of the disadvantages of using IRR is that all cash flows are assumed to be reinvested at the same discount rate, although in the real world these rates will fluctuate, particularly with longer term projects. IRR can be useful, however, when comparing projects of equal risk, rather than as a fixed return projection.
Calculating IRR
Many accounting software programs now include an IRR calculator, as do Excel and other programs. A handy alternative for some is the good old HP 12c financial calculator, which will fit in a pocket or briefcase. (Check out the Investopedia Calculators.)
The simplest example of computing an IRR is a mortgage with even payments. Assume an initial mortgage amount of $200,000 and monthly payments of $1,050 for 30 years. The IRR (or implied interest rate) on this loan annually is 4.8%.
Because the stream of payments is equal and spaced at even intervals, an alternative approach is to discount these payments at a 4.8% interest rate, which will produce a net present value of $200,000. Alternatively, if the payments are raised to, say $1,100, the IRR of that loan will rise to 5.2%.
The formula for IRR, using this example, is as follows:
 Where the initial payment (CF_{1}) is $200,000 (a positive inflow)
 Subsequent cash flows (CF_{ 2}, CF_{ 3}, CF N) are negative $1,050 (negative because it is being paid out)
 Number of payments (N) is 30 years times 12 = 360 monthly payments
 Initial Investment is $200,000
 IRR is 4.8% divided by 12 (to equate to monthly payments) = 0.400%
Using the numbers from this example, the formula for calculating IRR is as follows:
IRR = .400% 
Power of Compounding
IRR is also useful in demonstrating the power of compounding. For example, if you invest $50 every month in the stock market over a 10year period, that money would turn into $7,764 at the end of the 10 years with a 5% IRR.
In other words, to get a future value of $7,764 with monthly payments of $50 per month for 10 years, the IRR that will bring that flow of payments to a net present value of zero is 5%.
Compare this investment strategy to investing a lumpsum amount; to get the same future value of $7,764 with an IRR of 5%, you would have to invest $4,714 today, in contrast to the $6,000 invested in the $50permonth plan. So, one way of comparing lumpsum investments versus payments over time is to use the IRR.
Other IRR Uses
Another common use of IRR is in the computation of portfolio, mutual fund or individual stock returns. In most cases, the advertised return will include the assumption that any cash dividends are reinvested in the portfolio or stock. Therefore, it is important to scrutinize the assumptions when comparing returns of various investments.
What if you don't want to reinvest dividends, but need them as income when paid? And if dividends are not assumed to be reinvested, are they paid out or are they left in cash? What is the assumed return on the cash? IRR and other assumptions are particularly important on instruments like whole life insurance policies and annuities, where the cash flows can become complex. Recognizing the differences in the assumptions is the only way to compare products accurately. (Learn more about life insurance in 5 Things You Didn't Know About Life Insurance and Does Spiderman Need Life Insurance?)
In capital budgeting, the IRR rule is as follows:
IRR > cost of capital = accept project
IRR < cost of capital = reject project
In the example below, the IRR is 15%. If the firm's actual discount rate for discounted cash flow models is less than 15%, the project should be accepted.
Investment 
Inflows 

Year 0 
Year 1 
Year 2 
Year 3 
Year 4 
Year 5 
1,000,000 
300,00 
300,000 
300,000 
300,000 
300,000 
The primary advantage of implementing the internal rate of return as a decisionmaking tool is that it provides a benchmark figure for every project that can be assessed in reference to a company's capital structure. The IRR will usually produce the same types of decisions as net present value models, and it allows firms to compare projects on the basis of returns on invested capital.
Although IRR is easy to compute with either a financial calculator or computer software, there are some downfalls to using this metric. Similar to the PB method, the IRR does not give a true sense of the value that a project will add to a firm  it simply provides a benchmark figure for what projects should be accepted based on the firm's cost of capital. The internal rate of return does not allow for an appropriate comparison of mutually exclusive projects; therefore managers might be able to determine that project A and project B are both beneficial to the firm, but they would not be able to decide which one is better if only one may be accepted.
Another error arising with the use of IRR analysis presents itself when the cash flow streams from a project are unconventional, meaning that there are additional cash outflows following the initial investment. Unconventional cash flows are common in capital budgeting since many projects require future capital outlays for maintenance and repairs. In such a scenario, an IRR might not exist, or there might be multiple internal rates of return. In the example below two IRRs exist  12.7% and 787.3%.
Investment 
Inflows 

Year 0 
Year 1 
Year 2 
Year 3 
Year 4 
Year 5 
1,000,000 
10,000,000 
10,000,000 
0 
0 
0 
The IRR is a useful valuation measure when analyzing individual capital budgeting projects, not those which are mutually exclusive. It provides a better valuation alternative to the PB method, yet falls short on several key requirements.
Advantages And Disadvantages Of NPV and IRR


Fundamental Analysis
Return on Investment (ROI) Vs. Internal Rate of Return (IRR)
Read about the similarities and differences between an investment's internal rate of return (IRR) and its return on investment (ROI). 
Fundamental Analysis
Calculating the Internal Rate of Return Using Excel
The internal rate of return on investments is explained and illustrated in different investment scenarios. 
Personal Finance
An Introduction To Capital Budgeting
We look at three widely used valuation methods and figure out how companies justify spending. 
Investing Basics
Capital Budgeting: Capital Budgeting Decision Tools
Once projects have been identified, management then begins the financial process of determining whether or not the project should be pursued. The three common capital budgeting decision tools ... 
Insurance
How to Compare Permanent Life Insurance Policies
How you can use the internal rate of return to compare and purchase a permanent life insurance policy. 
Professionals
10 Ways to Improve Cash Flow in Construction
Improving cash flow in construction requires some sectorspecific strategies. 
Fundamental Analysis
Guide To Excel For Finance: Valuation Methods
DCF There is not a specific function to run a full discounted cash flow model in Excel, but there are a number of tools to make the exercise much more straightforward. As touched upon in the ... 
Insurance
All About Impaired Risk Annuites and Insurance
What are impaired risk insurance products and understanding life insurance rate classes, table ratings and flat extra premiums. 
Fundamental Analysis
Analyze Cash Flow The Easy Way
Find out how to analyze the way a company spends its money to determine whether there will be any money left for investors. 
Personal Finance
Evaluating A Statement Of Cash Flows
The metrics for the Statement of Cash Flows is best viewed over time.

Internal Rate Of Return  IRR
A metric used in capital budgeting measuring the profitability ... 
IRR
The currency abbreviation or currency symbol for the Iranian ... 
The Net Internal Rate Of Return ...
A measure of a portfolio or fund's performance that is equal ... 
Modified Internal Rate Of Return ...
While the internal rate of return (IRR) assumes the cash flows ... 
Net Present Value  NPV
Net Present Value (NPV) is the difference between the present ... 
Unconventional Cash Flow
A series of inward and outward cash flows over time in which ...

What's the difference between weighted average cost of capital (WACC) and internal ...
Both weighted average cost of capital (WACC) and internal rate of return (IRR) are great measures for assessing value, but ... Read Answer >> 
Why is the Modified Internal Rate Of Return (MIRR) preferable to the regular internal ...
See why the modified internal rate of return is often a superior metric to the classic internal rate of return for assessing ... Read Answer >> 
What is the benefit of the Modified Internal Rate Of Return (MIRR)?
Find out why the modified internal rate of return metric tends to be more realistic than the classic internal rate of return ... Read Answer >> 
What are the main differences between compound annual growth rate (CAGR) and internal ...
The compound annual growth rate (CAGR), measures the return on an investment over a certain period of time. The internal ... Read Answer >> 
How much debt is too much when calculating capital budgeting?
Learn how companies determine how much debt is acceptable when funding a new project by using the net present value to estimate ... Read Answer >> 
How do you use discounted cash flow to calculate a capital budget?
Learn how discounted cash flows are used in creating capital budgets as a part of the net present value and internal rate ... Read Answer >>