< Go Back

Microsoft Excel IRR function

The Microsoft Excel IRR function is categorized under Financial functions. It is used to calculate the internal rate of return for a series of cash flows, i.e., the initial capital value and the subsequent net income values. It is frequently used by businesses to estimate the profitability of potential investments.

General Formula

=IRR (values, [guess])

Example

Figure 1.Calculating internal rate of return using the IRR function

Explanation

values – the range of cells that contain values.
guess – setting this parameter is optional. It is the estimated value for the expected IRR. If left blank, the function will take a default value of 0.1 (=10%).

How to use the function

IRR is the rate of interest returned for a given cash flow (payments and income occurring at regular intervals, e.g., monthly or annually). Payments are indicated with a minus (negative) sign, and net income is represented with a plus sign (positive values). Amounts can be different, but intervals need to be consistent. The first value carries a negative sign it represents the initial investment or outlay.

Notes

  • #NUM! Error is shown if an accurate IRR value cannot be calculated using the default guess. This error can be corrected by adjusting the guess.

  • The array must show that at least one payment (negative value) is made and must also show at least one net income (positive value) from the outlay to return the IRR.

The Internal Rate of Return function follows the order of the values to calculate cash flows. This makes it necessary to enter the outlay and income values sequentially.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar