TVM Finance Calculator

How TVM Finance Calculator Works

FV = PV x (1+r)^n + PMT x [(1+r)^n - 1]/r

PV

Present Value — The current value of a cash flow or investment. Cash outflows are entered as negative numbers (standard financial sign convention used by HP 12C and Excel).

FV

Future Value — The value of a cash flow at the end of the investment horizon. Zero for fully amortizing loans; positive for savings goals.

PMT

Payment — The constant periodic payment amount. Negative for payments made (outflows like mortgage payments), positive for payments received (inflows like annuity income).

r

Rate per Period — The interest rate for each compounding period. For monthly periods, divide the annual rate by 12. Rate-solving uses Newton-Raphson numerical iteration with up to 200 iterations for convergence.

n

Number of Periods — The total number of payment or compounding periods. For a 30-year monthly mortgage, n = 360. Fractional periods are supported (e.g., 57.68 months).

Source: The TVM equation is derived from the compound interest formula extended with a series of uniform payments (annuity). The Newton-Raphson method for solving the rate is the standard numerical approach used in financial calculators and spreadsheet software including Excel's RATE function.

How to Use

1. Select what you want to solve for in the "Solve For" dropdown.
2. Fill in the four known variables (leave the solved-for field blank or at 0).
3. Use financial sign convention: cash you pay out is negative, cash you receive is positive. For a mortgage: PV is positive (you receive the loan), PMT is negative (you make payments).
4. For monthly mortgage: PV = loan amount (positive), PMT = monthly payment (negative), FV = 0, n = months, rate = annual rate / 12.
5. Select Annuity Due for lease/rent scenarios where payment occurs at the beginning of each period.

Quick Reference

Common Uses

• •Solve for any unknown variable in a loan, investment, or annuity using the five-variable time value of money framework.
• •Calculate the monthly payment on a mortgage by providing the loan amount, term, and interest rate as PV, N, and I/Y.
• •Determine the future value of regular savings contributions or the present value of a future lump sum needed for retirement planning.

Understanding the Result

Worked Examples

Frequently Asked Questions

What is the difference between an ordinary annuity and annuity due?

An ordinary annuity (End of Period) assumes payments occur at the end of each period — this is standard for loans and mortgages. An annuity due (Beginning of Period) assumes payments occur at the start — typical for leases and rent payments. Annuity due values are always slightly higher because payments are made sooner, giving them less time to discount (PV) or more time to compound (FV). For example, a $250,000 mortgage at 6% for 30 years: ordinary PMT = -$1,498.88, annuity due PMT = -$1,491.40.

Why do I enter the loan amount as a positive number for PV?

Financial sign convention: money flowing TO you is positive (you received the loan), money flowing FROM you is negative (you make payments). So a $250,000 mortgage has PV = +250,000 and PMT = -1,498. This convention is universal across all financial calculators (HP 12C, Excel, etc.). If you reverse the signs, you will get the same magnitude but the sign on your result will be flipped.

How do I calculate a mortgage payment?

Solve For: PMT. PV = loan amount (positive). FV = 0. N = years x 12. Rate = annual rate / 12. Timing = End of Period. Example: $300,000 loan at 7% for 30 years: N=360, Rate=7/12=0.5833%, PV=300000, FV=0 yields PMT = -$1,995.91.

How do I calculate how many months to pay off a loan?

Solve For: N. PV = current balance (positive). PMT = monthly payment (negative). FV = 0. Rate = monthly rate. The result is the number of periods (months). Example: $10,000 balance, paying $200/month at 6% APR (0.5%/month): N = ln(200/(200-10000 x 0.005)) / ln(1.005) = 57.68 months, or about 4 years and 10 months.

Why does the rate solver sometimes show "Cannot solve"?

The rate solver uses Newton-Raphson iteration which can fail when: (1) the payment is less than the interest-only payment, causing the balance to grow instead of shrink, (2) the inputs produce no mathematically valid rate, or (3) the initial guess of 10% is too far from the true rate for convergence. Try adjusting your inputs to ensure the payment covers at least the interest on the balance.

Pro Tips

• →Use negative PV for investments (money going out) and positive FV for what you get back — matching the HP 12C sign convention gives you consistent results across all financial tools.
• →For car leases, always use Annuity Due (beginning of period) — lease payments occur at the start of each month, not the end. This slightly increases the effective cost.
• →When solving for rate on a complex cash flow, use a rough guess first (e.g., 10% annually converts to ~0.83% monthly) — the Newton-Raphson solver converges faster when the initial guess is near the true rate.
• →The TVM framework is universal: the same five-variable equation models mortgages, car loans, student loans, savings plans, retirement withdrawals, bond pricing, and lease calculations.
• →To check your result: solve for the same variable using Excel or Google Sheets TVM functions (=PMT, =FV, =PV, =NPER, =RATE) — they use the same sign convention.

Limitations to Know

• •All payments are assumed equal and made at regular intervals — this calculator cannot model irregular cash flows, balloon payments, or graduated-payment mortgages.
• •The interest rate is assumed constant for all periods — it cannot model adjustable-rate products or rate changes over time.
• •Fractional period results (e.g., 57.68 months) are mathematically exact but real-world loans use whole periods — round up to determine the actual number of payments needed.
• •The rate solver uses numerical iteration (Newton-Raphson) which may fail to converge for extreme inputs or when the function is nearly flat near the solution.

Sources

• US Securities and Exchange Commission
• Investopedia — Time Value of Money
• HP 12C Financial Calculator Manual