The following warnings occurred:
Warning [2] Undefined array key 132055 - 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 array key 132056 - 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 array key 132063 - 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 array key 132120 - 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 132056 - 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 332 ThreadedMode::buildtree
/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 array key 132120 - 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 332 ThreadedMode::buildtree
/inc/plugins/threaded_mode.php 332 ThreadedMode::buildtree
/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





Money Weighted Return with HP 12C



#5

Is there a way to use the HP 12C to calculate a Money Weighted Return with multiple cash flows?

Sample Situation:

1st of the Month Account Value = 1,000,000

5th Day of the Month: Addition to Account: $30,000

16th Day of Month: Addition to Account: $20,000

30th Day of Month (end of month): Value of Account = 1,080,000

How do you calculate the Money Weighted Return with the HP12C


I know the actual formula, and the results, which are:

1,080,000 = 1,000,000*(1+R))^30 + 30,000*(1+R)^25 + 20,000*(1+R)^14

R = .0009536

So, the monthly return = (1+.0009536)^30 - 1 = 2.90%


Just looking for a quicker easier way to do it with the calculator..

Thanks for any help


#6

Do you have the manual?

That would be the place to start.

#7

Clear your registers before beginning.

Set your calc to begin mode. To do this press blue key and Beg

key in -1000000 into CF0. To do this press 1000000 and press CHS (changes sign to minus) Press blue key and then CF0.

key in 0 into CFj. To do this press 0 and press blue key and press CFj.

key in 4 into Nj. To do this press 4 and press blue key and press Nj (this puts a value of 0 into cash flow 1 through 4).

key in -30000 into CFj. To do this press 30000 and press CHS (changes sign to minus) Press blue key and then press CFj

key in 0 into CFj. To do this press 0 and press blue key and press CFj.

key in 10 into Nj. To do this press 10 and press blue key and press Nj. (this puts a value of 0 into cash flow 6 through 15)

key in -20000 into CFj. To do this press 20000 and press CHS (changes sign to minus) Press blue key and then press CFj

key in 0 into CFj. To do this press 0 and press blue key and press CFj.

key in 13 into Nj. To do this press 13 and press blue key and press Nj. (this puts a value of 0 into cash flow 17 through 29)

key in 1080000 into CFj. To do this press 1080000 (do NOT change the sign) Press blue key and CFj.

Press gold key and irr. Multiply the answer by either 365 or 360 depending on whether you use a 360 or 365 day year.

I don't know if this is what you are looking for. Numerous web sites as well as the 12C owners manual give good explanations. Page 71 through 75 gives a pretty good explanation.

Best wishes

Don


#8

perfect... thanks..

i wasn't sure how to let the calculator know when the deposits occured and that it was a 30 day month...

though, since I was looking for the monthly performance, I took the resulting IRR .09536 and applied the following:

(1+.0009536)^30 = 2.90%

Dave


Possibly Related Threads…
Thread Author Replies Views Last Post
  HP Prime - GETPIX_P Return? Thomas Chrapkiewicz 7 2,350 11-25-2013, 08:54 AM
Last Post: Thomas Chrapkiewicz
  HP PRIME: Hide return value from program and swap Edit with Run vrrr 2 1,505 11-09-2013, 04:04 PM
Last Post: vrrr
  HP Prime Programming Tutorial #1: LOCAL, RETURN Eddie W. Shore 6 2,945 10-26-2013, 08:42 PM
Last Post: Miguel Toro
  WP-34S return to HP-30B Mike Wilson 14 3,476 09-13-2012, 10:19 PM
Last Post: Tim Wessman
  Return of the HP 50g RS-232 serial cables Eric Rechlin 3 1,479 03-09-2012, 06:16 PM
Last Post: Andres Capdevila
  After Cuts, HP Labs Vows Return to Glory Days Kerem Kapkin (Silicon Valley, CA) 1 1,058 02-15-2012, 09:47 PM
Last Post: Howard Owen
  Return of the 15C with Bad Zebra? aj04062 3 1,440 12-23-2011, 01:52 PM
Last Post: uhmgawa
  Hey, the forum got mentioned on cnn's money website! Gene Wright 3 1,364 08-30-2011, 11:22 PM
Last Post: Graham D. Wilson
  OT:A HP-01 for a person like me with no money :-) robertoataulfo 1 930 08-16-2011, 02:00 AM
Last Post: Johnny Bjoern Rasmussen
  HP 12C, 12C Platinum & 15C iOS App Walter Lam 2 1,368 06-02-2011, 01:25 PM
Last Post: Andrés C. Rodríguez (Argentina)

Forum Jump: