HP Forum Archive 15

[ Return to Index | Top of Index ]

HP 19B Formulas Message #1 Posted by barry d. on 27 June 2005, 3:39 p.m. 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

Re: HP 19B Formulas Message #2 Posted by Bob Wang on 28 June 2005, 1:40 p.m., in response to message #1 by barry d. 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

19B Lease with Advance Payments Annual Debt Service Message #3 Posted by Bob Wang on 29 June 2005, 12:41 p.m., in response to message #1 by barry d. 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

[ Return to Index | Top of Index ]

Go back to the main exhibit hall