View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pykl
 
Posts: n/a
Default xirr - hi! i need some urgent help

you need dates for each period so it can calculate rate of return, were these
monthly or annual reports etc. Guess is your estimate of return, if blank it
uses the default of 0.1 or 10%.

"Daniela Gutierrez" wrote:

Hello

My problem is that im given
period 1 -12120
period 2 3000
period 3 8000
period 4 11000

now im supposed to get the XIRR, but i dont know what to put in "dates" and
"Guess"

thank you for your help