13- 17 May, 2013

# IRR Calculator in Excel

How to use the IRR Calculator available on this site to obtain the IRR of a series of cash flows

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

## IRR Calculator in Excel

Lets just show you quickly how to use the IRR calculator. If you go a little bit down, you will see there is a section here in white and this is where you are allowed to put inputs. As you can see I’ve already put some inputs in . In this example what we’ve got is that on the 1st of January 2009, and this is where we enter the dates of cash flow events , \$100 was put into this investment lets say. At the end of that same year \$9 was received out of it, another \$9 a year later, and so on, until 2013, at which time we get our \$9 back plus the original amount. The IRR Calculator tells you that that is an IRR of 9%. On the side here you will see that this automatically adds up the cash outflows and inflows. So this flow of cash results in an IRR of 9%.

Now lets try another set of numbers. So I’m going to still say we’ve made an investment of \$100, but I’m going to remove this and what I’m going to say is we receive nothing in these years , however, at 31 December 2013, we receive \$183.86 and when you click you will see that this profile also gives you 9%. So this is the equivalent of a 9% IRR. Now in this calculator you don’t need to capture these items all you need to do is put the correct date and when the outflow foes and you could then put the final date and inflow and it will give you the same answer.

Just one more example. Again we have \$100 leaving us, lets delete those, and now what we have is at the end of year 1 we do not get anything back, at the end of year 2 we get \$50 back, year 3 nothing, year 4 nothing and then we get \$89.11 in year 5. Guess what, that profile also generates a 9% IRR.

So you can see how different profiles can result in the same IRR and you can use this IRR calculator whether to make an investment or not and whether loans are costing you too much or too little

## Showing zeros in Excel

Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically … Continue reading

## Separating Lines within a cell

If IĀ understandĀ the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading

AuditExcel (aka Miricle Solutions) provided the Sasol Chlor Vinyls financial team with professional excel training whilst fully understanding the accounting landscape which is highly recommend.

– Sasol Polymers

## 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