The Museum of HP Calculators

HP Forum Archive 14

 PMT function...Message #1 Posted by eclectic_echidna on 25 Mar 2004, 1:06 p.m. I would like to put a few excel functions into my 15C, but I do not know how they are derived. For example, the PMT function in excel will calculate "the payment for a loan based on constant payments and a constant interest rate". So my question for this group. Where on the net is a good place to see how the PMT function (and other 12C like function) were derived? When you Google for PMT and excel, you get dozens and dozens of "Excel for dummies" sites. I can't find any "the PMT function comes from this" sites. -- ee Do the 12C manuals on the Museum DVD have it? Hmm...

 Re: PMT function...Message #2 Posted by Miki Mihajlovic on 25 Mar 2004, 1:37 p.m.,in response to message #1 by eclectic_echidna You can look at the Warren's site, Library->Application Pacs->Standard Applications Pac Manual, images 18,19 and 20. Program is for 41C but it shouldn't be hard to get it to work on 15C. 1234

 Re: PMT function...Message #3 Posted by Bob Wang on 25 Mar 2004, 1:44 p.m.,in response to message #2 by Miki Mihajlovic ```This should help: ```

 Re: PMT function...Message #4 Posted by bill platt on 25 Mar 2004, 1:58 p.m.,in response to message #1 by eclectic_echidna Hi, You need to look at the Excel help for "PV" to see the formula they are using. An excerpt from Excel Help: [quote] PMT See Also Calculates the payment for a loan based on constant payments and a constant interest rate. Syntax PMT(rate,nper,pv,fv,type) For a more complete description of the arguments in PMT, see the PV function. [quote/] Best regards, Bill Edited: 25 Mar 2004, 1:59 p.m.

 Re: PMT function... HP15C Adv. Fcn. HandbookMessage #5 Posted by Vieira, Luiz C. (Brazil) on 25 Mar 2004, 2:57 p.m.,in response to message #1 by eclectic_echidna Hi, e._e. (may I?) There is an oustanding, original HP book for the HP15C named "HP15 Advanced Functions Handbook", that's also available as one of the e-books at the MoHPC CD pack. In this book, pages 26 to 44, one can find MANY examples of how to use the HP15C to solve Time-Value-of-Money problems and also discounted cash flow's Net-Present-Value and Internal-Rate-of-Return. It's worth taking a look at them. Hope this helps, too. Cheers. Luiz (Brazil) Edited: 25 Mar 2004, 3:00 p.m.

 Re: PMT function... also HP-34C HandbookMessage #6 Posted by Karl Schneider on 25 Mar 2004, 9:49 p.m.,in response to message #5 by Vieira, Luiz C. (Brazil) e-e: Luis is right, that the HP-15C Advanced Functions Handbook contains a documented Time Value of Money (TVM) program written expressly for the 15C. The MoHPC CD/DVD set is probably your best bet for getting this manual, which tends to be an expensive collector's item. Also available, in the HP-34C user's manual, is a documented program written for the 34C. The program is directly portable to the 15C. A hardcopy 34C manual should be cheaper to obtain, but it also is available as a scanned image on the MoHPC CD/DVD set. -- Karl S.

Go back to the main exhibit hall