A formula for IRR
|
05-18-2015, 09:20 AM
(This post was last modified: 05-18-2015 09:23 AM by akmon.)
Post: #6
|
|||
|
|||
RE: A formula for IRR
Well it worked well for me in home mode Textbook format. Thank you Cyrille for the expression. Anyway I made two little changes:
fsolve(ΣLIST(MAKELIST((L1(I)/X^(I-1)),I,1,SIZE(L1))),X)-1 Example: L1= {-123400, 36200, 54800, 48100} TIR = 0,0596, or 5,96% (In spanish we call TIR -tasa interna de retorno- to IRR) Very useful for me, cause I work with financial analysis in public works concessions. I tried your example, Salvomic, and it nails it: 0,1306 or 13,06%. |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
A formula for IRR - salvomic - 05-17-2015, 08:47 PM
RE: A formula for IRR - Gene - 05-17-2015, 09:13 PM
RE: A formula for IRR - salvomic - 05-17-2015, 09:19 PM
RE: A formula for IRR - cyrille de brébisson - 05-18-2015, 05:47 AM
RE: A formula for IRR - salvomic - 05-18-2015, 08:03 AM
RE: A formula for IRR - akmon - 05-18-2015 09:20 AM
RE: A formula for IRR - salvomic - 05-18-2015, 09:33 AM
RE: A formula for IRR - salvomic - 05-18-2015, 06:01 PM
RE: A formula for IRR - salvomic - 05-18-2015, 10:27 AM
RE: A formula for IRR - DrD - 05-18-2015, 11:54 AM
RE: A formula for IRR - salvomic - 05-18-2015, 12:31 PM
RE: A formula for IRR - DrD - 05-18-2015, 01:47 PM
RE: A formula for IRR - salvomic - 05-18-2015, 02:08 PM
RE: A formula for IRR - DrD - 05-18-2015, 02:47 PM
RE: A formula for IRR - salvomic - 05-18-2015, 02:56 PM
RE: A formula for IRR - DrD - 05-18-2015, 03:32 PM
RE: A formula for IRR - salvomic - 05-18-2015, 03:45 PM
RE: A formula for IRR - DrD - 05-18-2015, 03:55 PM
RE: A formula for IRR - salvomic - 05-18-2015, 03:57 PM
RE: A formula for IRR - salvomic - 05-18-2015, 05:20 PM
RE: A formula for IRR - salvomic - 05-18-2015, 07:49 PM
RE: A formula for IRR - akmon - 05-18-2015, 07:51 PM
RE: A formula for IRR - salvomic - 05-18-2015, 07:55 PM
RE: A formula for IRR - akmon - 05-18-2015, 10:15 PM
RE: A formula for IRR - salvomic - 05-18-2015, 09:18 PM
RE: A formula for IRR - Alfon - 05-18-2015, 10:30 PM
RE: A formula for IRR - salvomic - 05-19-2015, 08:58 AM
RE: A formula for IRR - akmon - 05-19-2015, 10:32 AM
RE: A formula for IRR - akmon - 05-18-2015, 11:07 PM
RE: A formula for IRR - DrD - 05-19-2015, 11:28 AM
RE: A formula for IRR - Didier Lachieze - 05-19-2015, 11:43 AM
RE: A formula for IRR - DrD - 05-19-2015, 12:10 PM
RE: A formula for IRR - DrD - 05-19-2015, 12:05 PM
RE: A formula for IRR - akmon - 05-19-2015, 12:27 PM
RE: A formula for IRR - salvomic - 05-19-2015, 12:33 PM
RE: A formula for IRR - akmon - 05-19-2015, 12:45 PM
RE: A formula for IRR - DrD - 05-19-2015, 12:49 PM
RE: A formula for IRR - Didier Lachieze - 05-19-2015, 01:02 PM
RE: A formula for IRR - salvomic - 05-19-2015, 01:22 PM
RE: A formula for IRR - salvomic - 05-20-2015, 09:25 PM
RE: A formula for IRR - fhub - 05-20-2015, 10:40 PM
RE: A formula for IRR - salvomic - 05-20-2015, 10:48 PM
RE: A formula for IRR - salvomic - 05-21-2015, 06:20 PM
|
User(s) browsing this thread: 1 Guest(s)