PMT function...



#7

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...


#8

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


#9

This should help:


HP-15C Time Value of Money

#10

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.

#11

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.


#12

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 907 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 635 12-13-2000, 05:55 AM
Last Post: Steve (Australia)

Forum Jump: