Microsoft Office Tutorials and References

In Depth Information

**Syntax**

return after 5 years. If you want to figure out the internal rate of return,

use the IRR function.

Note

IRR fails to take into account that the money earned in Year 1 could

start generating interest if invested in a CD. To calculate a rate of

return including the reinvestment of profits, use MIRR, which is de-

scribed in the following section.

One critical difference exists between IRR and NPV: In the NPV function, the

initial investment in the business is notincluded in the list of arguments. In

the IRR function, the initial investment in the business needs to be included as

the first cash flow. Because this is money paid for the business, it should

be negative.

Caution

The algorithm behind the IRR function is new and more accurate in Excel

2013. Be aware that Excel 2007 and Excel 2013 might produce different

results for some uses of IRR.

Syntax

IRR(values,guess)

The IRR function returns the internal rate of return for a series of cash

flows, represented by the numbers in values. These cash flows do not have

to be even, as they would be for an annuity. However, the cash flows must

occur at regular intervals, such as monthly or annually. The internal rate

of return is the interest rate received for an investment, consisting of pay-

ments (negative values) and income (positive values) that occur at regular

periods.

The IRR function takes the following arguments:

•
values

values
—
This is an array or a reference to cells that contain num-

bers for which you want to calculate the internal rate of return.

valuesmust contain at least one positive value and one negative

value to calculate the internal rate of return. IRR uses the order of