Finance Formulas



#4

Geetings all,
I have been using this formula to calculate payments for our finance packages: PMT=(COST-FVx(SPPV(I%YR÷12:N)))÷(USPV(I%YR÷12:N-#ADV)+#ADV)

What I need is a formula that gives me step payments and deferred payments on loans. All help is greatly appreciated. I use a 17bII.

Jeff Maloney
maloney1@pacbell.net


#5

Jeff,

You'll find a (the needed?) program applicable for your 17bII on p.372 ff. of "An Easy Course in Using the HP 19BII", 1991, Grapevine Publications by Chris Coffin.

Pls. understand that I won't post the code here due to my respect for the author & the copyright regulations.

The book/solution should be still available thru Amazon or eventually as part of a newer book by Chris.

Pls. visit his website http://www.read-gpi.com/

Best regards

Peter A. Gebhardt

Edited: 29 Apr 2008, 5:22 a.m.

#6

Jeff,

I can help with the deferred payments loan. The basic formula is very simple. On my 17BII I entered it as:

PV+PMT(USPV(I%:N+M)-USPV(I%:M))+FV*SPPV(I%:N+M)=0

where N is the actual number of payments made and M is the number of periods the payments are deferred. (Cash flow sign conventions are observed.)

As for step payment loans, there are so many ways to structure those that you almost have to take them on a case by case basis.

Don


Possibly Related Threads...
Thread Author Replies Views Last Post
  HP Prime - Saved formulas, expressions CR Haeger 6 720 10-07-2013, 08:25 PM
Last Post: CR Haeger
  Lost formulas David Goldstein 5 610 05-08-2013, 03:39 AM
Last Post: Katie Wasserman
  Formulae or formulas, that's the question (poll) Walter B 56 3,873 06-16-2012, 11:16 AM
Last Post: William L. Drylie
  Female Finance Reporters & Their Calcs John W Kercheval 0 239 05-15-2012, 02:23 PM
Last Post: John W Kercheval
  Back with my DEG<->DMS formulas ! PGILLET 5 627 05-03-2012, 07:44 PM
Last Post: Bart (UK)
  Hp 50g finance program peacecalc 0 236 01-01-2012, 10:22 AM
Last Post: peacecalc
  Updates and strange Finance module behaviour (with HEPAX/NoVRAM) Diego Diaz 14 1,352 09-25-2008, 06:04 PM
Last Post: Dan Grelinger
  Formulas for ->HMS & ->HR Pekis 0 225 06-08-2008, 05:48 PM
Last Post: Pekis
  HP 48 Finance Apps? Graphing? bink 2 349 09-07-2007, 02:50 PM
Last Post: bink
  Where to find Optical Physics and laser dynamics/properties formulas for the 50G Scott Blakely 1 298 07-24-2007, 12:44 PM
Last Post: Ed Look

Forum Jump: