CalcTrace

Finance Calculator

A time value of money solver that works like the TVM keys on a financial calculator. Pick which of N, I/Y, PV, PMT or FV you want to find, enter the other four, and say whether each amount is money you receive or money you pay.

Last updated .

Time value of money

Solve for

Interest compounds once per period, so the rate per period is I/Y ÷ P/Y. N counts periods, not years: 4 years of monthly payments is N = 48.

Payments are made at the

Sign convention: money coming to you is positive, money leaving you is negative. A loan you take out is a positive PV with negative payments.

Result

PMT: payment each period

–

–Rate per period
–Effective annual rate
–Total of all payments
–Interest

The cash flows, from your side

WhenAmountDirection

Show the working

    The time value of money equation

    A dollar today is worth more than a dollar later, because today’s dollar can earn interest in the meantime. Every loan, lease, savings plan and annuity is the same statement about that idea, written with five variables. Know any four and the fifth is fixed.

    PV × (1 + i)N + PMT × (1 + i × b) × ((1 + i)N − 1) ÷ i + FV = 0

    When the rate is zero the equation collapses to PV + PMT × N + FV = 0. There are tidy rearrangements for PV, PMT, FV and N. There is none for the interest rate, so the calculator finds I/Y by trial: it searches for the rate at which the left-hand side changes sign and narrows in on it.

    The cash-flow sign convention

    The equation adds everything up to zero, which only works if money in and money out carry opposite signs. Take your own point of view and stick to it: money you receive is positive, money you pay is negative. This calculator asks for the direction of each amount so you do not have to type minus signs, and shows the signed figures in the result.

    If every amount has the same sign there is no solution for N or I/Y, because no rate of interest can turn money that only ever flows one way into a balanced deal. This is the most common reason a financial calculator reports an error.

    Worked examples

    Solve for PMT: a $20,000 loan at 6% over 4 years

    1. Set up. N = 48, I/Y = 6, P/Y = 12, PV = +20,000, FV = 0, payments at the end.
    2. Rate per period. i = 6 ÷ 12 ÷ 100 = 0.005.
    3. Growth factor. 1.00548 = 1.270489.
    4. Payment factor. (1.270489 − 1) ÷ 0.005 = 54.0978.
    5. Rearrange for PMT. PMT = −(PV × 1.270489 + FV) ÷ 54.0978 = −(25,409.78 + 0) ÷ 54.0978 = −$469.70.

    The answer is negative because it is money you pay. Before any rounding to whole cents, the 48 payments total $22,545.63, so the interest is $2,545.63.

    Solve for FV: $5,000 now plus $100 a month for 10 years at 6%

    1. Set up. N = 120, I/Y = 6, P/Y = 12, PV = −5,000, PMT = −100.
    2. Factors. 1.005120 = 1.81939673, and (1.81939673 − 1) ÷ 0.005 = 163.879346.
    3. Rearrange for FV. FV = −(−5,000 × 1.81939673 + −100 × 163.879346) = 9,096.984 + 16,387.935 = 25,484.919, which rounds to +$25,484.92.

    Switch the payments to the beginning of each month and each one earns an extra month of interest: the payment term is multiplied by 1.005 and FV becomes $25,566.86.

    Solve for N and I/Y

    A $5,000 card balance at 18% a year, repaid at $200 a month, has i = 0.015 and solves to N = 31.57. A fractional N means 31 full payments and a smaller final one. Drop the payment to $75 and there is no solution: the first month’s interest is $5,000 × 0.015 = $75, so the balance never falls. For a rate, pay $20,000 today and receive $40,000 in 10 years with P/Y = 1 and no payments: I/Y solves to 7.18%.

    Common mistakes

    N in years. N is periods. With monthly payments a 30-year loan is N = 360, not 30. A monthly rate in I/Y. I/Y is the yearly nominal rate; the calculator divides it by P/Y for you. The wrong payment timing. Loan repayments normally fall at the end of each period, while rent and lease payments are typically made at the beginning. Ignoring a leftover value. If something remains at the end, such as a balloon payment or a residual, it belongs in FV with the right direction.

    Limits of the method

    The equation assumes a constant rate, equal payments, and interest that compounds once per payment period. It does not include fees, and it cannot handle payments that change over time. If a rate is quoted with a compounding frequency that differs from the payment frequency, convert it to the equivalent rate for the payment period first.