Problem with MVAR on HP42S
|
06-10-2020, 08:58 AM
Post: #5
|
|||
|
|||
RE: Problem with MVAR on HP42S
Hello,
Thanks for your answers. All I wanted to do was a solver program to solve internal rate of return (IRR) of a cash flow set (including frequency for each cash flow). I was rusty and this is how it ended up: CF = Preexisting Cash flow matrix (amount in column 1, frequency in column 2, CF(1,1) < 0) Use Solver with NPV to find IRR (Enter guess for interest rate "IR" (e.g. use 0.1 for 10%)) XEQ NPV alone calculates Net Present Value for the CF cash flow set (with "IR" value) R03: Intermediary future value R04: Intermediary total number of cash flows R05: Current cash flow amount R06: Current cash flow frequency Code:
Thanks ! |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
Problem with MVAR on HP42S - Pekis - 06-07-2020, 08:09 PM
RE: Problem with MVAR on HP42S - grsbanks - 06-07-2020, 08:41 PM
RE: Problem with MVAR on HP42S - GreyUser - 06-09-2020, 01:24 AM
RE: Problem with MVAR on HP42S - Valentin Albillo - 06-09-2020, 04:27 AM
RE: Problem with MVAR on HP42S - Pekis - 06-10-2020 08:58 AM
RE: Problem with MVAR on HP42S - Werner - 06-12-2020, 08:59 AM
|
User(s) browsing this thread: 3 Guest(s)