MySQL Forums
Forum List  »  UDF

Internal Rate of Return Procedure for MySQL
Posted by: Deep Pancholi
Date: May 05, 2015 11:59AM

Hi,

I am looking for a stored procedure to compute the Internal Rate of Return (IRR) values given cahflows for multiple records. A sample of records is given below:

'0,-204.569
1,7.138
2,21.905
3,21.673
4,20.679
5,18.579
6,17.180
7,16.884
8,15.115
9,14.043
10,12.682
11,11.286
12,21.881'

Basically, I want to iterate over this cashflow and determine what my IRR value is. There is an Excel function that allows me to do this and looking up on google, I could find some SQL Server code that helps compute the value. I am fairly new to stored procedures and would really appreciate if someone could provide the IRR code.

Options: ReplyQuote


Subject
Views
Written By
Posted
Internal Rate of Return Procedure for MySQL
1705
May 05, 2015 11:59AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.