Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XIRR function breaking down (#NUM)
Hi guys,
Know this is a forum for VBA questions and I have done quite a bit of programming so that I will shoot this by the pros here :) I have the following data: Date* Value 31-Dec-06 -353,727,346 30-Nov-07 -70,866,490 31-Dec-07 333,502,702 31-Jan-08 507,604 29-Feb-08 -1,841,266 31-Mar-08 -1,125,842 30-Apr-08 -950,991 31-May-08 -193,437 30-Jun-08 -444,026 31-Jul-08 -962,122 31-Aug-08 -2,059,591 30-Sep-08 58,164 31-Oct-08 -1,040,522 30-Nov-08 -2,766,378 31-Dec-08 -46,006,913 For some reason my XIRR function will not work (even if I provide a negative guess). I have calculated the TSR on a yearly basis which is approx -24% and the total drop over the two years is approx -42%. Anyone have a clue why my Excel only gives me #Num. Using VBA I have sorted the data in terms of first date and then amount. Still have the error... Any help would be truly appreciated! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XIRR function breaking down (#NUM)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XIRR FUNCTION | Excel Worksheet Functions | |||
Please help for FV and XIRR function. | Excel Worksheet Functions | |||
xirr function | Excel Worksheet Functions | |||
Using XIRR function in VBA ? | Excel Programming | |||
XIRR function | Excel Worksheet Functions |