PMT function... « Next Oldest | Next Newest »

 ▼ eclectic_echidna Junior Member Posts: 10 Threads: 5 Joined: Jan 1970 03-25-2004, 01:06 PM 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... ▼ Miki Mihajlovic Member Posts: 121 Threads: 26 Joined: Jul 2005 03-25-2004, 01:37 PM 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 ▼ Bob Wang Member Posts: 90 Threads: 22 Joined: Jun 2005 03-25-2004, 01:44 PM ```This should help: ``` bill platt Posting Freak Posts: 2,448 Threads: 90 Joined: Jul 2005 03-25-2004, 01:58 PM 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. Vieira, Luiz C. (Brazil) Posting Freak Posts: 4,027 Threads: 172 Joined: Aug 2005 03-25-2004, 02:57 PM 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. ▼ Karl Schneider Posting Freak Posts: 1,792 Threads: 62 Joined: Jan 2005 03-25-2004, 09:49 PM 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.

 Possibly Related Threads... Thread Author Replies Views Last Post HP50g: Writing a function that returns a function Chris de Castro 2 905 12-10-2013, 06:49 PM Last Post: Han 14b is not calculating PMT correctly Eric Peltier 11 1,167 12-21-2011, 11:04 AM Last Post: Neil Hamilton (Ottawa) x=4? Function Shawn 2 504 10-01-2002, 10:12 AM Last Post: Vieira, Luiz C. (Brazil) Implement 'AND' function with 'XOR' function. tal 4 634 12-13-2000, 05:55 AM Last Post: Steve (Australia)

Forum Jump: