HP 19B Formulas



#4

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


#5

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

#6

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 728 10-07-2013, 08:25 PM
Last Post: CR Haeger
  Lost formulas David Goldstein 5 624 05-08-2013, 03:39 AM
Last Post: Katie Wasserman
  Formulae or formulas, that's the question (poll) Walter B 56 3,914 06-16-2012, 11:16 AM
Last Post: William L. Drylie
  Back with my DEG<->DMS formulas ! PGILLET 5 633 05-03-2012, 07:44 PM
Last Post: Bart (UK)
  Resurrecting a shattered HP 19B Neil Hamilton (Ottawa) 5 589 01-28-2012, 07:11 PM
Last Post: bill platt
  HP 19B Keith Midson 3 407 03-12-2010, 03:47 AM
Last Post: Keith Midson
  Kitchen timer on 17B/17BII/17BII+/19B/19BII/27S y.miyata 1 324 03-04-2010, 12:18 PM
Last Post: Martin Pinckney
  Which came first? 19B or 27S? Mark Edmonds 2 387 06-25-2009, 09:41 AM
Last Post: Mark Edmonds
  Formulas for ->HMS & ->HR Pekis 0 233 06-08-2008, 05:48 PM
Last Post: Pekis
  Finance Formulas Jeff Maloney 2 351 05-02-2008, 02:24 PM
Last Post: MacDonald Phillips

Forum Jump: