HP 19B Formulas



#2

Hopefully someone can help me with a formula that appears to be reasonably simple to figure out, for any experienced HP user. I'm just not all that savvy when it comes to creating formulas.

Anyone familiar with the HP 19B calculator probably knows the formula below is the one used to solve for Present Value and loan calculations in leasing and loans.

ADV:PMT=(-PV-FV*(SPPV(I%YR/12:N)))/(USPV(I%YR/12:N-#ADV)+#ADV)

My goal is to simply add one simple step to the formula (or create another one if need be) to add "Annual Debt Service (ADS)calculation. In other words, once a payment is caluclated, I'd like to be able to have the calculator compute the payment AND multply by 12, which equals the ADS (Annual Debt Servive). This is a common component in real estate investment comparisions when analyzing the projected cash flow.

Thank you for your assistance.

Barry


#3

Barry:

Probably the easiest way is just to multiply by 12 to get ADS after you've calculated PMT. BUT you can save *2* keystrokes, i.e. RCL PMT, instead of *,1,2,= by using the following formula, solving for ADS, and recalling the PMT ;-)


ADV:12*L(PMT:(-PV-FV*(SPPV(I%YR/12:N)))/(USPV(I%YR/12:N-#ADV)+#ADV))-ADS+0*PMT


Bob

#4

Barry:


I thought a little more about your request, and here are 3 approaches. The first one is probably what you are looking for, but it comes with a BIG CAVEAT. You ABSOLUTELY, POSITIVELY MUST solve for PMT first, before pressing ADS. Otherwise, the ADS you get will be based on the old value stored in PMT. The other 2 alternatives will alert you with an error message:

Option 1: Enter all values, press MORE, PMT, *THEN* ADS:


ADV:IF(S(PMT):(-PV-FV*(SPPV(I%YR/12:N)))/(USPV(I%YR/12:N-#ADV)+#ADV)-PMT:12*PMT-ADS)

Option 2: Enter all values, press MORE, ADS, RCL PMT:


ADV:12*L(PMT:(-PV-FV*(SPPV(I%YR/12:N)))/(USPV(I%YR/12:N-#ADV)+#ADV))-ADS+0*PMT

Option 3: Enter all values, press MORE, PMT, RCL ADS:


ADV:L(ADS:12*(-PV-FV*(SPPV(I%YR/12:N)))/(USPV(I%YR/12:N-#ADV)+#ADV))/12-PMT+0*ADS


Hope this helps,

Bob


Possibly Related Threads...
Thread Author Replies Views Last Post
  HP Prime - Saved formulas, expressions CR Haeger 6 722 10-07-2013, 08:25 PM
Last Post: CR Haeger
  Lost formulas David Goldstein 5 611 05-08-2013, 03:39 AM
Last Post: Katie Wasserman
  Formulae or formulas, that's the question (poll) Walter B 56 3,880 06-16-2012, 11:16 AM
Last Post: William L. Drylie
  Back with my DEG<->DMS formulas ! PGILLET 5 629 05-03-2012, 07:44 PM
Last Post: Bart (UK)
  Resurrecting a shattered HP 19B Neil Hamilton (Ottawa) 5 578 01-28-2012, 07:11 PM
Last Post: bill platt
  HP 19B Keith Midson 3 399 03-12-2010, 03:47 AM
Last Post: Keith Midson
  Kitchen timer on 17B/17BII/17BII+/19B/19BII/27S y.miyata 1 320 03-04-2010, 12:18 PM
Last Post: Martin Pinckney
  Which came first? 19B or 27S? Mark Edmonds 2 378 06-25-2009, 09:41 AM
Last Post: Mark Edmonds
  Formulas for ->HMS & ->HR Pekis 0 228 06-08-2008, 05:48 PM
Last Post: Pekis
  Finance Formulas Jeff Maloney 2 349 05-02-2008, 02:24 PM
Last Post: MacDonald Phillips

Forum Jump: