tir... is the same as xirr??

  • Thread starter Daniela Gutierrez
  • Start date
D

Daniela Gutierrez

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
 
D

Daniel CHEN

Suppose you have values in column A and dates in Column B, then

=XIRR(A1:A10,B1:B10,0.1)

0.1 is the estimated rate.


--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
 
F

Fred Smith

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.
 
Top