Help with XIRR - getting #Num! error

peterkehle

New Member
Joined
Jun 1, 2007
Messages
2
My time frame is 48 months. I have entered the dates in column A rows 1 to 48 and the outflows and inflows in column B rows 1 to 48. There is an outflow in month 1 and month 6 all other months are either positive or are zero.

The dates have been entered as 7/1/2007 for July 1, 2007. Is this correct or a problem?

The cash flows have been entered as a negative number, positive number or zero.

The formula used is =XIRR(B1:B48,A1:A48)

What have I done wrong?

Thanks!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
According to the help file:

Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.

Also

If any number in dates precedes the starting date, XIRR returns the #NUM! error value.
If values and dates contain a different number of values, XIRR returns the #NUM! error value.

Good luck.
 
Upvote 0
Hi, please help I am trying to calculate the XIRR value but get the #NUM Error.

Here is the data:

03/07/2017-28
03/07/201728
03/07/201712,835
03/07/201712,835
01/08/201713,661
01/08/201713,661
23/08/201713,661
23/08/201713,661
11/10/201713,661
11/10/201713,661
11/10/201750
11/10/201750
13/10/201711
13/10/201711
13/10/201713
13/10/201713
24/10/201710
24/10/201710
24/10/201713,661
24/10/201713,661
22/11/2017109,492
22/11/2017109,492
22/11/2017110,679
22/11/2017110,679
22/11/2017114,717
22/11/2017114,717
22/11/2017116,124
22/11/2017116,124
22/11/2017116,833
22/11/2017116,833
22/11/2017118,093
22/11/2017118,093
22/11/2017482,694
22/11/2017482,694
22/11/2017487,911
22/11/2017487,911
22/11/2017505,753
22/11/2017505,753
22/11/2017511,940
22/11/2017511,940
22/11/2017515,039
22/11/2017515,039
22/11/2017520,577
22/11/2017520,577
23/11/201713,661
23/11/201713,661
19/12/201713,661
19/12/201713,661

<tbody>
</tbody><colgroup><col><col></colgroup>
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

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?

Disable AdBlock

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
Back
Top