Post Reply 
A formula for IRR
05-18-2015, 09:33 AM (This post was last modified: 05-18-2015 10:08 AM by salvomic.)
Post: #7
RE: A formula for IRR
(05-18-2015 09:20 AM)akmon Wrote:  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%.

good for you, akmon!
HP 12C confirms your example: IRR (TIR) = 5.96%

But I get warning: "evaluating invariable expression(value) like if expression was a function. You should write subst(48100/X^-1,X,0)"
then -1

I'm searching where is my error...

EDIT: I was in CAS...
In Home it works well!

So, now we must find a way to be able to use it also in CAS...
Then Eddie could add this to his nice program for NPV.

However I'm trying to port formula in an independent program IRR(lista), but it gives for now "Bad argument type" in Home, and a lot of warnings in CAS. Working in progress...

Salvo

∫aL√0mic (IT9CLU) :: HP Prime 50g 41CX 71b 42s 39s 35s 12C 15C - DM42, DM41X - WP34s Prime Soft. Lib
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


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 - 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)