View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith
 
Posts: n/a
Default tir... is the same as xirr??

Most people put in 0.1 (10%) for a guess. It almost always works.

However, you need the dates on which the values occurred in order to use XIRR.
If you don't have dates, you can't use XIRR.

If the values occurred at regular intervals (eg, monthly, quarterly, annually),
you can use IRR to calculate the return.

--
Regards,
Fred


"Daniela Gutierrez" wrote in
message ...
Hello

i need to get the xirr

i have this values

-12120
3000
8000
11000

=xirr(all the values, ???)

i dont know what to put in guess and dates,

please help me