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 employs the general financial formula: (PV + PMT(1 + c·IR)/IR)((1 + IR)NP - 1) + PV + FV = 0, to calculate one of the 5 parameters when 4 parameters are known.

Notice: the IR 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, or withdrawal from the account.


Financial Calculator vs. 3.2
Money Manager
Parameters




Options



Compounding & Payment Options

Display Options

  • Result
  • Plot Overview
  • Plot Payment Schedule
  • Help
  • Help: Sign Convention

Time Value of Money

See the corresponding paper under the Papers link in the left sidebar or download the paper directly.

Important Notice: Sign Conventions

Negative values: Owed balance and money paid to the account
Positive values: Balances in your favor and withdrawals from the account

Understanding these conventions is critical for accurate calculations.

Example: Loan Payment

In the default example where PV = $100,000:

  • PV = $100,000 (positive) indicates a loan from the bank to you
  • PMT = -$5,783.01 (negative) represents your periodic payment back to the bank
  • FV = $0 means the loan is fully paid off after all payments
Alternative Scenario: Balloon Payment

If you only pay PMT = -$5,000 per period and calculate FV, the result is a balloon payment of -$43,915.06. The negative value indicates you still owe this amount to the bank.

Basic Financial Formulas

CF: Compound frequency
PF: Payment frequency
c: 1 for beginning of period payment, otherwise 0
i: Effective interest rate
NP: Number of periods

Financial Equations (General)

(1) General equation:
(PV + PMT(1 + c·i)/i)((1 + i)NP − 1) + PV + FV = 0

Using the substitutions:
(2) A = (1 + i)NP − 1
(3) B = (1 + c·i)/i

Simplified form:
(4) (PV + PMT × B) × A + PV + FV = 0

Solved for Each Variable:
(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: hve@hvks.com

Understanding Sign Conventions in Financial Calculations

Financial calculators use positive (+) and negative (−) signs to represent the direction of cash flow, not simply whether something is good or bad. Understanding this convention is essential for getting correct results.

KEY RULE: Signs represent the direction money flows FROM YOUR PERSPECTIVE

  • Positive (+) = Money flowing TO you (money you receive)
  • Negative (−) = Money flowing FROM you (money you pay out)

The Most Important Principle: Consistency

This calculator accepts either sign convention as long as you are consistent. You can think of it from the borrower's perspective OR the lender's perspective — just don't mix them!

Scenario Borrower View Lender View
Initial loan amount (PV) Positive (you receive) Negative (you give)
Regular payments (PMT) Negative (you pay) Positive (you receive)
Final balance (FV) Usually 0 or negative (owe) Usually 0 or positive (receive)

Example 1: Home Mortgage (Borrower's Perspective)

You borrow $200,000 for a home at 6% annual interest for 30 years

Bank → You: Receive $200,000
PV = +200,000 (positive because money flows TO you)

You → Bank: Pay monthly
PMT = −1,199.10 (negative because money flows FROM you)

FV = 0 (loan fully paid off at the end)
NP = 360 (30 years × 12 months)
Interest Rate = 6% annual

Example 2: Same Mortgage (Lender's Perspective)

Same $200,000 mortgage, but from the bank's viewpoint

PV = −200,000 (negative because bank gives you money)
PMT = +1,199.10 (positive because bank receives your payments)
FV = 0 (loan fully paid off)
NP = 360 months
Interest Rate = 6% annual (same result!)

Pro Tip: Notice that both perspectives give the same interest rate! You can use either convention — just be consistent.

Example 3: Investment/Savings Account

You invest $10,000 today and add $500 monthly for 20 years

PV = −10,000 (negative because you pay this out to invest)
PMT = −500 (negative because you pay this monthly)
FV = ? (what you want to calculate — will be positive)
NP = 240 (20 years × 12 months)
Interest Rate = 7% annual

Result: FV = +262,481 (positive because you receive this at the end)

Example 4: Loan with Balloon Payment

$200,000 loan at 6% for 20 years with reduced payments and balloon payment

PV = +200,000 (you receive the loan)
PMT = −1,300 (reduced monthly payment)
FV = ? (balloon payment to calculate)
NP = 240 (20 years × 12 months)
Interest Rate = 6% annual

Result: FV = −61,388 (negative because you still owe this at the end)

Common Mistakes to Avoid

WRONG — Mixing Perspectives:
For a mortgage, using:

  • PV = −200,000 (thinking "I owe money, so negative")
  • PMT = −1,199 (thinking "I pay out, so negative")

This is inconsistent! Both can't be negative if one is money you receive and the other is money you pay back.

WRONG — All Same Sign:
Typically, cash flows in opposite directions at different times. If PV, PMT, and FV all have the same sign, something is probably wrong (unless one of them is zero).

Quick Reference Guide

I am... PV Sign PMT Sign FV Sign
Borrowing money (mortgage, car loan) Positive Negative Usually 0
Investing/Saving money Negative Negative Positive
Receiving payments (annuity, pension) Negative Positive 0 or positive
Lending money to someone Negative Positive 0 or positive

When in Doubt:

  1. Draw a timeline showing when money moves
  2. Mark arrows showing direction (to you or from you)
  3. Money coming TO you = positive, money leaving FROM you = negative
  4. Stay consistent throughout your calculation

Still Confused?

Think of it like your bank account:

  • Deposits (+) increase your balance (money flows IN)
  • Withdrawals (−) decrease your balance (money flows OUT)

The same logic applies to all financial calculations. The sign tells you which direction the money is moving relative to you.


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:
10-Oct-2025vs 3.2Improved the help tab and added an extra tab for help in regards to the sign convention
4-Oct-2024vs 3.1Change the IR calculation trhough iteration to a more stable iteration
15-May-2024vs 3.0Completely rewritten and expanded internally with the use of the new Financial object library, plus added the Plot overview and Plot of payment schedule. The textual table with breakdown of each period has been beautified
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.