formula



#6

Would someone show me the formula(s) for these financial calculations so I can put them in a math program!

Such as.. how to solve for each one of these given the value of the others

Present Value =

Future Value =

Interest Rate =

Term =

Payment =


Thanks in advance :)


#7

May I recommend that you google present value formula first. There are plenty of articles with these formulas already posted, all of them are very easy to find, no need to re-type them all here or ask for help.


Edited: 21 Oct 2007, 2:03 a.m.

#8

You need the manual for the HP-12C. It answers all your questions. The manual has an appendix containing all the financial formulas regarding present value, future values, periodic payments, and so on.

Namir

#9

Quote:
Would someone show me the formula(s) for these financial calculations so I can put them in a math program!

Such as.. how to solve for each one of these given the value of the others : Present Value, Future Value, Interest Rate, Term, Payment

Thanks in advance :)




I've had this program sitting in my HP15C for a long time now. I've also used close relatives on the HP11C and HP33S. Not as fancy as some of the TVM programs people use, but nice to have ready when trying to talk turkey at a car dealership!


Time Value of Money Calculations for HP-15C

Chris McCormack - 21 Oct 2007

These routine perform loan calculations using the present value
annuity factor, or PVAF. This relates the present value (loan amount)
to the periodic payments necessary to pay it off.

PVAF(r,N) = (1/r)[1-1/(1+r)^N]

In this equation, r is the decimal interest per payment period
(.01 would represent a monthly loan with a 12% rate) and N in the
number of payments (48 would work for a four-year car loan).

Note - Labels 9 and 6 were used because 9 is next to the divide key
(breaking the loan down into payments) and 6 is next to the multiply
key (building up the total loan amount).


Memory Usage: 21 steps

Register usage: R0 = interest rate per period
R1 = number of periods

Label Usage: LBL 9 : calculate payment for a given amount borrowed
LBL 6 : calculate amount borrowed for a given payment
LBL.9 : (internal) determine PVAF


001 LBL 9 // ( LoanAmt -- Payment )
002 GSB .9 / // divide PV by PVAF
004 RTN

005 LBL 6 // ( Payment -- LoanAmt )
006 GSB .9 * // multiply payment by PVAF
008 RTN

009 LBL .9 // ( -- PFAV )
010 RCL 0 1 + // R0 holds interest per period
013 RCL 1 CHS y^x // R1 holds number of periods
016 1 x<>y -
019 RCL 0 /
021 RTN


Sample calculations:

$5000 borrowed at 10% with 36 monthly payments
--> $161.34 / month

$1500/month on a 30 year mortgage at 7.5%
--> $215,526.44 borrowed

#10

Here's the one I have memorized. The first part is the compound interest formula; the second is an ordinary annuity formula. Usually you set them equal to each other for annuities, loan payments, sinking funds, etc. Taking the difference gives you the balance on a loan, or set it to 0 for the above calculations.

                               nt
nt (1 + r/n) - 1
P(1 + r/n) - Pmt -------------- = bal
r/n
P = principal
n = compoundings (or payments) per year
t = time in years
r = annual interest rates
pmt = periodic payment
bal = balance

This formula resides in most of my HP's.


Possibly Related Threads...
Thread Author Replies Views Last Post
  how to manage formula in prime fabrice48 5 1,707 12-05-2013, 01:09 PM
Last Post: Steve Simpkin
  Fast Quadratic Formula for the HP-41C Gerson W. Barbosa 21 4,288 07-18-2012, 08:53 AM
Last Post: Gerson W. Barbosa
  Cubic Formula: HP 71B Eddie W. Shore 8 2,020 07-03-2012, 11:14 PM
Last Post: Eddie W. Shore
  Quadratic formula program help Chris C 18 3,453 06-16-2012, 12:14 AM
Last Post: Matt Agajanian
  Which quadratic formula is use? Michel Beaulieu 7 1,667 09-29-2011, 10:17 PM
Last Post: Jeff O.
  Re: The lost formula Csaba Tizedes (Hungary) 5 1,286 01-26-2011, 05:59 AM
Last Post: Csaba Tizedes (Hungary)
  Re: The lost formula John B. Smitherman 11 2,061 01-18-2011, 08:47 PM
Last Post: Dan W
  The lost formula designnut 5 1,466 01-17-2011, 02:05 AM
Last Post: Walter B
  How to use a formula in a post Thomas Klemm 4 1,159 11-09-2010, 10:17 AM
Last Post: Egan Ford
  HP17bII+ Solver - Payback Period formula RMIER 6 1,397 08-02-2009, 05:36 PM
Last Post: Peter A. Gebhardt

Forum Jump: