The following warnings occurred:
Warning [2] Undefined array key 62730 - Line: 275 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php 275 errorHandler->error_callback
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined variable $thread - Line: 295 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php 295 errorHandler->error_callback
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Trying to access array offset on value of type null - Line: 295 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php 295 errorHandler->error_callback
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined variable $fid - Line: 295 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php 295 errorHandler->error_callback
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined array key 62730 - Line: 331 - File: inc/plugins/threaded_mode.php PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php 331 errorHandler->error_callback
/inc/plugins/threaded_mode.php 304 ThreadedMode::buildtree
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined variable $theme - Line: 3 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 3 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Trying to access array offset on value of type null - Line: 3 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 3 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined variable $theme - Line: 3 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 3 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Trying to access array offset on value of type null - Line: 3 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 3 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Undefined variable $lang - Line: 5 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 5 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks
Warning [2] Attempt to read property "messages_in_thread" on null - Line: 5 - File: inc/plugins/threaded_mode.php(305) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)
File Line Function
/inc/class_error.php 153 errorHandler->error
/inc/plugins/threaded_mode.php(305) : eval()'d code 5 errorHandler->error_callback
/inc/plugins/threaded_mode.php 305 eval
/inc/plugins/threaded_mode.php 23 ThreadedMode::showthread_threaded
/inc/class_plugins.php 142 threaded_mode_showthread_threaded
/showthread.php 918 pluginSystem->run_hooks





MIRR calculation on hp200lx hp17b hp19b



#2

How to calcultate MIRR with an hp solver?

* WHY

The MIRR or modified internal rate of return is useful when the project has multiple negative cash flows, and thus multiple IRRs. It prevents also from reinvesting the cash flows at the project internal rate of return.

Basically, the MIRR is equal to the future value of positive cash flows with a risky rate divided by the present value for negative cash flows with a safe rate, at the power one divided by the number of periods considered.

No MIRR calculation is provided on an hp17b, hp200lx or hp19b. But all include a powerful solver!


* WHAT

The following formula has been developed on an hp200lx and successfully used on an hp17b.


MIRR%/100+1=

(

-SIGMA(i;0;SIZEC(mirr);1;

SPFV(

Irisk%;SIGMA(j;i+1;SIZEC(trim);1;#T
(mirr;j))

)

*USFV(Irisk%;#T(mirr;i))

*IF(FLOW(mirr;i)>0;FLOW(mirr;i);0)

)/

SIGMA(i;0;SIZEC(mirr);1;

SPPV(

Isafe%;SIGMA(j;0;i-1;1;#T(mirr;j))-1*0

)

*USPV(Isafe%;#T(mirr;i))

*IF(FLOW(trim;i)<0;FLOW(mirr;i);0)

)

)

^

(

1/SIGMA(i;0;SIZEC(mirr);1;#T(mirr;i))

)

On an hp17b, SIGMA should be replaced by the special E and the separator [;] by [:].

Entering the formula on an hp17b is painful, but worth the patience. Be very cautious on the opening and closing brackets.

No problem should arise with an hp19b.


* VARIABLES

mirr is the NAME of the CFLO list (or the name of the file where the cash flows are saved on the hp200lx)

Isafe% is the rate to borrowing, or safe rate

Irisk% is the rate for re-investing, or risky rate

MIRR% is the modified rate of return, what we are looking for


* EXAMPLE

The example provided by hp is

-180, initial cash flow

100, 5 times

-100, 5 times

0, 9 times

200, 1 time


With Isafe%=8%/12, Irisk%=13/12, MIRR%=12.0/12 very close to 12.18%/12 but equal to 12.0%/12 given by Excel.

The example provided by hp is monthly based but the rates are year based, thus the conversions /12.


I hope this helps!


Possibly Related Threads…
Thread Author Replies Views Last Post
  HP35s Program Four Slings Lift Calculation Jean-Marc Biram (Australia) 2 2,130 12-16-2013, 07:21 PM
Last Post: Jean-Marc Biram (Australia)
  [HP-Prime] AMBIGUITY between Numerical Calculation (HOME) and Numerical/Symbolic Calculation (CAS mode) CompSystems 2 1,400 08-18-2013, 07:06 PM
Last Post: CompSystems
  slow calculation Bill Plaxton 3 1,541 08-15-2013, 11:57 AM
Last Post: Bill Plaxton
  hp 17bii+ dates calculation... JoePaul 6 2,339 07-14-2013, 11:32 AM
Last Post: Katie Wasserman
  HP35 Ad. from 1972 with calculation error reused in 2009? Michael Kathke 46 11,181 05-14-2013, 03:52 PM
Last Post: Dieter
  Good (simple?) calculation for benchmarking? Jedidiah Smith 28 7,041 03-01-2013, 05:13 PM
Last Post: Harald
  HP200LX Connectivity SW Luiz C. Vieira (Brazil) 6 2,057 11-07-2012, 04:07 PM
Last Post: Luiz C. Vieira (Brazil)
  Complex number calculation on wp34s wildpig 13 3,151 08-30-2012, 09:46 AM
Last Post: Ángel Martin
  running hp200lx solver on kindle fire william egan 4 1,803 03-10-2012, 07:25 PM
Last Post: Bill (Smithville, NJ)
  HP-10BII+ Price calculation bug? Thomas Radtke 0 935 02-15-2012, 06:53 AM
Last Post: Thomas Radtke

Forum Jump: