HP 19B Formulas « Next Oldest | Next Newest »

 ▼ barry d. Junior Member Posts: 1 Threads: 1 Joined: Jan 1970 06-27-2005, 03:39 PM 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 ▼ Bob Wang Member Posts: 90 Threads: 22 Joined: Jun 2005 06-28-2005, 01:40 PM 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 Bob Wang Member Posts: 90 Threads: 22 Joined: Jun 2005 06-29-2005, 12:41 PM 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 776 10-07-2013, 08:25 PM Last Post: CR Haeger Lost formulas David Goldstein 5 688 05-08-2013, 03:39 AM Last Post: Katie Wasserman Formulae or formulas, that's the question (poll) Walter B 56 4,304 06-16-2012, 11:16 AM Last Post: William L. Drylie Back with my DEG<->DMS formulas ! PGILLET 5 680 05-03-2012, 07:44 PM Last Post: Bart (UK) Resurrecting a shattered HP 19B Neil Hamilton (Ottawa) 5 648 01-28-2012, 07:11 PM Last Post: bill platt HP 19B Keith Midson 3 434 03-12-2010, 03:47 AM Last Post: Keith Midson Kitchen timer on 17B/17BII/17BII+/19B/19BII/27S y.miyata 1 349 03-04-2010, 12:18 PM Last Post: Martin Pinckney Which came first? 19B or 27S? Mark Edmonds 2 423 06-25-2009, 09:41 AM Last Post: Mark Edmonds Formulas for ->HMS & ->HR Pekis 0 255 06-08-2008, 05:48 PM Last Post: Pekis Finance Formulas Jeff Maloney 2 388 05-02-2008, 02:24 PM Last Post: MacDonald Phillips

Forum Jump: