The Museum of HP Calculators

HP Forum Archive 18

 Finance FormulasMessage #1 Posted by Jeff Maloney on 28 Apr 2008, 12:29 a.m. 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

 Re: Finance FormulasMessage #2 Posted by Peter A. Gebhardt on 28 Apr 2008, 8:42 p.m.,in response to message #1 by Jeff Maloney 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.

 Re: Finance FormulasMessage #3 Posted by MacDonald Phillips on 2 May 2008, 2:24 p.m.,in response to message #1 by Jeff Maloney 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

Go back to the main exhibit hall