Thread: XIRR FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynndale Lynndale is offline
external usenet poster
 
Posts: 4
Default XIRR FUNCTION

USING THE FINANCIAL FUNCTION i AM TRYING TO CALCULATE THE ANNUAL RATE OF
RETURN FOR THE LAST QUARTER FOR A FUND. FILLING IN THE ARGUMENTS FOR THE
FUNCTION i GET THE FOLLOWING
"=XIRR("-83948.81:84568.12",(4/1/6:2008/30/2008),0.1)" THE FIRST VALUE IS THE
BEGINNING MARKET VALUE AND THE SECOND VALUE IS THE ENDING MARKET VALUE WITH
THE CORRESPONDING DATES.

COULD SOMEONE SHOW WHAT I AM DOING WRONG?

tHANKS