HP Forum Archive 18

[ Return to Index | Top of Index ]

Finance Formulas Message #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 Formulas Message #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 Formulas Message #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

[ Return to Index | Top of Index ]

Go back to the main exhibit hall