View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default The XIRR function in Excel

see Chip Pearson's explanation at

http://www.cpearson.com/Excel/rounding.htm

"MMM" wrote:

When I try to calculate an IRR with an initial outlay of -$100 on 1/1/07 and
an final amount of $112 on 1/1/08 does the IRR come to 11.99999988% instead
of 12% even?
--
Matt