Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmotewar
Yak Posting Veteran
62 Posts |
 Posted - 2009-05-18 : 07:23:45
|
| Hi all,i want to calculate the XIRR value. does any one have code or any one have idea how to calculate. XIRR function is used for financial purpose for returning annualized return.same function is available in excel also but i dont know how to calculate it.Pankaj |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-24 : 04:29:39
|
Excel uses an iterative technique for calculating XIRR. Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. If XIRR can't find a result that works after 100 tries, the #NUM! error value is returned. The rate is changed until:  http://office.microsoft.com/global/images/default.aspx?AssetID=ZA060512641033where:di = the ith, or last, payment date.d1 = the 0th payment date.Pi = the ith, or last, payment.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Help regarding XIRR Function.