Post Reply 
Looking for TVM formulas
04-01-2014, 10:40 AM (This post was last modified: 04-01-2014 11:57 AM by Jeff_Kearns.)
Post: #6
RE: Looking for TVM formulas

.doc  TVM_Equation.doc (Size: 52.5 KB / Downloads: 27) [/quote]
I can probably derive a symbolic equation from that program and algebra it into the other direct solutions I'm after
[/quote]

Here is the equation:

B*(1+i)^n + P*((1+i)^n-1)*(1/i+E) + F = 0

and make the following substitution for increased accuracy:
(1+i)^n = e^(n*ln(1+i)) = i'

where:
n-Number of compounding periods (n on HP-12C)
i=Periodic interest rate (i on HP-12C)
B=Initial Balance or Present Value (PV on HP-12C)
P=Periodic Payment (PMT on HP-12C)
F=Future Value (FV on HP-12C)
E=Begin/End mode (Begin = 1; End = 0)

Use convention that money in or received is positive and money paid out or deposited is negative.

Jeff Kearns
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
Looking for TVM formulas - Dave Britten - 03-31-2014, 11:21 PM
RE: Looking for TVM formulas - Jeff_Kearns - 04-01-2014 10:40 AM
RE: Looking for TVM formulas - Jeff_Kearns - 04-01-2014, 07:37 PM
RE: Looking for TVM formulas - Dieter - 04-02-2014, 12:21 PM
RE: Looking for TVM formulas - Dieter - 04-02-2014, 07:23 PM
RE: Looking for TVM formulas - Dieter - 04-06-2014, 07:46 PM
RE: Looking for TVM formulas - Dieter - 04-09-2014, 01:36 PM
RE: Looking for TVM formulas - Dieter - 04-02-2014, 07:40 PM
RE: Looking for TVM formulas - Dieter - 04-03-2014, 01:22 PM
RE: Looking for TVM formulas - Jeff_Kearns - 04-04-2014, 09:44 PM
RE: Looking for TVM formulas - Dieter - 04-05-2014, 09:58 PM



User(s) browsing this thread: 3 Guest(s)