(Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR%
02-09-2022, 04:28 PM
Post: #13
 Thomas Okken Senior Member Posts: 1,894 Joined: Feb 2014
RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR%
(02-09-2022 02:36 PM)Werner Wrote:  but how then to both use direct solving and your preferred order of variables (eg in the much larger CFA equation, where only IRR% needs to be solved iteratively)? I will probably have to choose ;-)

Not at all, the best of both worlds can be had. Specify a parameter list after the equation name, et voilĂ .

Code:
FOO(X:Y:Z):<function using X, Y, Z, and maybe other variables as well>

The named parameters will be shown first in the VARMENU, in the order in which they appear in the parameter list; any remaining referenced variables will show up in the order in which they are found in the equation, and shown in black on white to set them apart.

Note that a named equation with parameter list, as above, may not have a top-level = sign, so if you have a =0, just leave it off, and otherwise, change it to a subtraction.
 « Next Oldest | Next Newest »

 Messages In This Thread (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-06-2022, 10:59 AM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - rprosperi - 02-06-2022, 01:37 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Didier Lachieze - 02-06-2022, 02:13 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-06-2022, 02:26 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Thomas Okken - 02-06-2022, 05:37 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-08-2022, 05:08 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - rprosperi - 02-09-2022, 03:39 AM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Steve Simpkin - 02-09-2022, 10:01 AM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-09-2022, 06:32 AM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-09-2022, 10:54 AM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Thomas Okken - 02-09-2022, 01:04 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-09-2022, 02:36 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Thomas Okken - 02-09-2022 04:28 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-09-2022, 04:51 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-17-2022, 12:41 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - rprosperi - 02-17-2022, 01:19 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Vincent Weber - 02-17-2022, 01:22 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Werner - 02-17-2022, 02:40 PM RE: (Plus42) Cash Flow Analysis: NPV, IRR%, MIR%, FMR% - Vincent Weber - 02-17-2022, 03:56 PM

User(s) browsing this thread: 1 Guest(s)