Numerical Methods at work

Disclaimer:
Permission to use, copy, and distribute this software, and It’s documentation for any non-commercial purpose is hereby granted without fee, provided: THE SOFTWARE IS PROVIDED "AS-IS" AND WITHOUT WARRANTY OF ANY KIND, EXPRESS, IMPLIED OR OTHERWISE, INCLUDING WITHOUT LIMITATION, ANY WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL Henrik Vestermark, BE LIABLE FOR ANY SPECIAL, INCIDENTAL, INDIRECT OR CONSEQUENTIAL DAMAGES OF ANY KIND, OR ANY DAMAGES WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER ADVISED OF THE POSSIBILITY OF DAMAGE, AND ON ANY THEORY OF LIABILITY, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.

Web-based Financial calculator: Time Value of Money

This Financial calculator uses the general financial formula: (PV+PMT(1+iX)/i)((1+i)NP-1)+PV+FV=0 to calculate one of the 5 parameters when 4 parameters are known.

Notice: the i in the financial formula is the effective interest rate per period. A negative value for owed balance and money paid to the account, a positive value for balances in your favor, and withdrawal from the account.


Financial Calculator vs. 2.12
Parameters




Options



Compounding & Payment Options

Display Options

  • Result
  • Help

Time Value of Money.

See the corresponding paper under the Papers link in the left sidebar or click on this link: Download paper

Notice: Negative value for owed balance and money paid to the account, positive value for balances in your favor, and withdrawal from the account. This is very important to notice. In the default example where PV=100,000 this indicates a loan from the bank of $100,000, since the bank is given you the money the value is positive, consequently, any period payment is negative since you are paying off the loan by paying back the bank the PMT value, which in this case is -$5783.01. The FV is in this example $0 since you continue PMT until the loan is paid off. However, if we assume that you only pay e.g. -$5000 per PMT then pressing Calc FV gives a balloon payment of -$43,915.06 as the final payment. As you can see the value is negative indicating that you owed the bank that amount. Remember, always know how to interpret positive and negative values.

Basic financial formulas: CF=Compound frequency, PF=payment frequency, X=1 for beginning of period payment otherwise 0, i=effective interest
Financial equation: (General)
 (1): (PV+PMT(1+iX)/i)((1+i)NP-1)+PV+FV=0
by using:
 (2): A=(1+i)NP-1
 (3): B=(1+iX)/i
you get:
 (4): (PV+PMT*B)*A+PV+FV=0
which solved for the other variable gives:
 (5): NP=log((PMT*B-FV)/(PMT*B+PV))/log(1+i)
 (6): PV=-(FV+A*PMT*B)/(A+1)
 (7): PMT=-(FV+PV(A+1))/(A*B)
 (8): FV=-(PV+A(PV+PMT*B)).
 (9): IR solved by iteration

Please email me if you encounter any problems at hve@hvks.com


Rate this page

Click on the stars below to rate this page

Low
a Star
a Star
a Star
a Star
a Star
High


Corrections:
23-Feb-2022vs 2.12Fix an issue calculating IR when compounding was monthly. The result was 12 times less
16-Feb-2022vs 2.11Fix an issue calculating IR when PMT was 0 and also fix some incorrect display text
15-Aug-2020vs 2.10Fix an issue with printing on some browsers
24-Apr-2020vs 2.9Added total payment and total interest for annuities display
7-Nov-2019vs 2.8Redesign GUI
20-May-2018vs 2.6Fixed an issue with the interest iteration
23-Apr-2018vs 2.5Added new history retrieve for PV, FV, PMT, NP, and IR
27-Sep-2016vs 2.4Bugs fixed.
18-Sep-2016vs 2.3Rewrote the iteration for interest. Now it is faster and more robust.
14-Sep-2014vs 2.2Fixed a reported bug in the calculation of the interest rate.
12-Oct-2011vs 2.0Fixed several bugs thanks to Franz Huber's input, including a bug with interest calculation and other used formulas.
9-Oct-2011vs 1.8 Fixed a bug with the beginning and end of the period calculation.
9-Oct-2011vs 1.7Fixed a bug in the FV formula.