Finance Formulas



#2

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


#3

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.

#4

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 897 10-07-2013, 08:25 PM
Last Post: CR Haeger
  Lost formulas David Goldstein 5 817 05-08-2013, 03:39 AM
Last Post: Katie Wasserman
  Formulae or formulas, that's the question (poll) Walter B 56 5,083 06-16-2012, 11:16 AM
Last Post: William L. Drylie
  Female Finance Reporters & Their Calcs John W Kercheval 0 311 05-15-2012, 02:23 PM
Last Post: John W Kercheval
  Back with my DEG<->DMS formulas ! PGILLET 5 752 05-03-2012, 07:44 PM
Last Post: Bart (UK)
  Hp 50g finance program peacecalc 0 315 01-01-2012, 10:22 AM
Last Post: peacecalc
  Updates and strange Finance module behaviour (with HEPAX/NoVRAM) Diego Diaz 14 1,660 09-25-2008, 06:04 PM
Last Post: Dan Grelinger
  Formulas for ->HMS & ->HR Pekis 0 291 06-08-2008, 05:48 PM
Last Post: Pekis
  HP 48 Finance Apps? Graphing? bink 2 437 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 387 07-24-2007, 12:44 PM
Last Post: Ed Look

Forum Jump: