tir... is the same as xirr??
 

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

tir... is the same as xirr??
 

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
==================================
"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

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