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
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 |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 3 Guest(s)