13- 17 May, 2013

Excel IRR function

How to use the Excel IRR function to determine the Internal Rate of Return for a series of cash flows.

• 1:54
• Skill Level:
• What's my skill level

Excel IRR function

In this example we have a series of cash flows starting with an Initial investment, a negative number in Period 0, and then a whole bunch of cash inflows over the next five years. We’d like to work out what the internal rate of return of these cash flows are. For this we can use the Excel IRR function;

• If we click in the cell where we want the result
• and activate the Function Wizard
• we can go to the Financial category,
• we go to IRR
• and when we say ok, we are asked for these arguments
• the first one is the Values, which is basically an array of reference to cells that contain the numbers for which we want to calculate the IRR, so in that case it would be this list here,
•  and then you are asked for a Guess, and in some cases the IRR cannot come up with a number, you need to put in a guess, and generally I put in .1 or 10%
• and when you click ok
• You will see that the IRR is calculated.

In order for the IRR to work you have to understand two issues. The first is that your series of cash flows must contain at least one negative number, and at least one positive number in order for it to work, otherwise it’ll deliver an error message. The second issue is that unlike the NPV function, the IRR function assumes that the first value it is given occurs in period 0 and after that it goes to Period1,2; whereas the NPV function assumes that the first number it is given occurs at the end of Period 1. This is extremely important especially if you are trying to reconcile your NPV’s to your IRR numbers.

Handy Tips & Tricks

Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading

Creating a Waterfall Chart in Excel the easy way

A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading

We have used Audit Excel/Miracle Solutions for all our Excel training requirements for the past 18 months, the assessment is a good tool to determine that the trainee is allocated to the correct training.

– KRONES Lifecycle Service Center Africa

View Entire Video Gallery ››

• 03:14
• Skill Level:
• What's my skill level

• 00:42
• Skill Level:
• What's my skill level

Waterfall chart using stock charts

• 07:11
• Skill Level:
• What's my skill level

Absolute and Relative cell references

• 06:34
• Skill Level:
• What's my skill level