# irr vs. xirr

#### mattajanke

##### New Member
Can anyone tell me the difference between the two?

for the irr formula we use irr=(Value range, .25/12 )*12
for the xirr formula we just use the standard formula.

Does anyone know why we would get two different answers?

Thanks for your help!

### Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
The difference is that IRR expects the payments to be periodic, whereas XIRR accepts a series of dates that are not necessarily periodic. In the example below the answers are similar:
Book8
ABCD
1ValuesDates
2(70,000)01-Jan-08
312,00001-Feb-08
415,00001-Mar-08
518,00001-Apr-08
621,00001-May-08
726,00001-Jun-08
8
9171.77%XIRR
10171.01%IRR
Sheet1

Replies
6
Views
891
Replies
1
Views
533
Replies
3
Views
2K
Replies
1
Views
1K
Replies
1
Views
533

1,219,972
Messages
6,151,224
Members
451,018
Latest member
dids86

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back