Financial Calculator
0.00
Enter four of the five values and press CPT next to the one you want. Money you pay out is negative, money you receive is positive.
Uses the TVM worksheet. Choose the first and last payment (P1 and P2) to see how much of each payment is interest and how much repays the loan.
| Interest | — |
|---|---|
| Principal | — |
| Balance after P2 | — |
One cash flow per line, starting with today's (CF0). Write "amount × count" for a flow that repeats. Money paid out is negative.
| NPV | — |
|---|---|
| IRR | — |
Convert between a nominal annual rate compounded C/Y times a year and the effective annual rate.
For education and planning only, not financial advice. Lenders may round or count days differently.
This financial calculator solves the problems a business-school calculator solves: how big a loan payment is, how long it takes to reach a savings goal, what rate a deal really earns, how much of each payment is interest, and whether a project is worth more than it costs. It uses the same equation and sign convention as financial calculators and spreadsheet functions, so you can check every result against your course or your spreadsheet.
- Time value of money: solve N, I/Y, PV, PMT or FV
- Payments at the end or the beginning of each period, any payment and compounding frequency
- Amortization schedule with interest, principal and balance, exported as CSV
- Net present value and internal rate of return of uneven cash flows
- Nominal and effective interest rate conversion
- Decimal arithmetic checked against the spreadsheet documentation examples
This calculator is an educational tool. It shows what the standard formulas give for the numbers you enter; it is not financial, tax or investment advice. Real loans and deposits can differ because of fees, day-count rules, rounding of each payment and changing rates, so check the figures your lender or bank quotes.
How to use the financial calculator
- Open the TVM tab and set P/Y (payments a year) and C/Y (compounding periods a year), for example 12 and 12 for a monthly loan. Choose END for ordinary payments or BGN for payments at the start of each period, like rent.
- Enter four of N, I/Y, PV, PMT and FV, then press CPT next to the fifth. Money you pay out is negative and money you receive is positive.
- For a loan schedule, open Amortization, choose payments P1 to P2 and press Show schedule. Export CSV saves every row for a spreadsheet.
- For an investment, open Cash flows, write one cash flow per line starting with today's, enter a discount rate and press NPV, or press IRR.
- Your worksheets are saved in this browser only. The calculator never sends them anywhere.
Signs: money in and money out
Every value is a cash flow from your point of view. Borrowing 200,000 is money you receive, so PV is +200,000 and the monthly payment comes out negative, because you pay it. Saving works the other way round: deposits are negative and the balance you get back at the end, FV, is positive.
If a computation says there is no solution, the signs are usually the cause: a loan where both PV and PMT are positive can never be repaid. Change the sign of one value and compute again.
The time value of money equation
All five TVM values are tied by one equation, where i is the interest rate per payment period and S is 1 for payments at the beginning of a period (BGN) and 0 at the end (END):
When payments and compounding happen at different frequencies, the annual rate is first turned into an equivalent rate per payment period. With monthly payments and semi-annual compounding, common for Canadian mortgages, C/Y is 2 and P/Y is 12:
Worked example: a 30-year mortgage
You borrow 200,000 at 6 % a year for 30 years, repaid monthly at the end of each month. Enter N = 360, I/Y = 6, PV = 200000, FV = 0, P/Y = C/Y = 12, then compute PMT.
- The monthly rate and the number of payments:
- Solving the equation for the payment:
- In the first month, interest is the balance times the monthly rate, and the rest of the payment repays the loan:
- Over the whole loan you pay this much interest:
The calculator shows PMT = −1,199.10, and the Amortization tab shows interest −1,000.00, principal −199.10 and balance 199,800.90 for the first payment, ending at a balance of 0.00 after payment 360.
Net present value and internal rate of return
Net present value adds up a series of cash flows after discounting each one to today at the rate r. A positive NPV means the investment earns more than r. The first cash flow, CF0, happens today and is not discounted, as on financial calculators; a spreadsheet's NPV function starts discounting at the first value, so add CF0 to its result.
The internal rate of return is the rate at which the NPV is exactly zero. When the cash flows change sign more than once, there can be several such rates or none; the calculator warns you and you should compare projects with NPV instead.
Nominal and effective interest rates
A nominal rate of 12 % compounded monthly is not 12 % a year: interest is added every month and earns interest itself. The effective annual rate shows what you really earn or pay over a year:
How exact are the results?
Every number is read exactly as typed and the calculator works in decimal arithmetic with 50 significant digits (bignumber.js), including powers with fractional exponents and logarithms. Amounts are shown rounded to cents, rates to four decimals, but the full value is kept for the next computation, so solving back and forth returns exactly what you started with.
Accuracy and test cases
Every function on this page is checked automatically before each release against 36 test cases, including the worked examples of the spreadsheet documentation for PMT, PV, FV, NPER, RATE, NPV, IRR, EFFECT and NOMINAL. The table shows a selection; run all of them in your own browser to see the same engine you are using pass.
| Inputs | Reference | Calculator shows | Plain floating point | Check |
|---|---|---|---|---|
| Time value of money Results as printed in the spreadsheet documentation, rounded to the decimals shown there. | ||||
| Source: Microsoft Excel PMT documentation example | −1037.03 | — | — | |
| Source: Microsoft Excel PMT documentation example | −129.08 | — | — | |
| Source: Microsoft Excel FV documentation example | — | 2581.40 | — | — |
| Source: Microsoft Excel PV documentation example | — | −59777.15 | — | — |
| Source: Microsoft Excel NPER documentation example | — | 59.67 | — | — |
| Source: Microsoft Excel RATE documentation example | 0.77 | — | — | |
| — | −1199.10 | — | — | |
| −1919.42 | — | — | ||
| — | 0.70 | 0.7000000000000001 | — | |
| There is no solution for these values. Check the signs: money paid out is negative. | — | — | ||
| — | There is no solution for these values. Check the signs: money paid out is negative. | — | — | |
| Amortization First and last payment of the 30-year example; signs as on financial calculators. | ||||
| −1000.00 | — | — | ||
| — | 199800.90 | — | — | |
| — | 0.00 | — | — | |
| Cash flows: NPV and IRR CF0 is today's flow and is not discounted. | ||||
| Source: Microsoft Excel NPV documentation example | — | 1188.44 | — | — |
| Source: Microsoft Excel NPV documentation example | — | 1922.06 | — | — |
| Source: Microsoft Excel IRR documentation example | — | 8.66 | — | — |
| — | There is no solution for these values. Check the signs: money paid out is negative. | — | — | |
| Interest rate conversion Nominal and effective annual rates. | ||||
| Source: Microsoft Excel EFFECT documentation example | 5.3543 | — | — | |
Show every test case
Related calculators
For a single question with a guided form, try these calculators.
Frequently asked questions
Why is my payment negative?
Because it is money you pay out. The calculator uses the cash-flow sign convention of financial calculators and spreadsheets: money received is positive, money paid is negative. A loan has a positive PV and a negative PMT.
What are P/Y and C/Y?
P/Y is the number of payments a year and C/Y the number of times interest is compounded a year. For most loans both are 12. If they differ, the calculator converts the annual rate into the right rate per payment.
When should I use BGN?
Use BGN when payments are made at the start of each period, as with rent, leases or a savings plan paid on the first of the month. Ordinary loans are paid at the end of the period, so leave END selected.
Why does my bank quote a slightly different payment?
Banks may round each payment, charge fees, count interest by days rather than months, or adjust the last payment. The calculator shows the exact result of the standard formula, which is the best starting point for comparing offers.
How is IRR calculated?
It finds the rate at which the net present value of the cash flows is zero, first with a search in ordinary precision and then refined with 50-digit decimal arithmetic. If the flows never change sign there is no IRR; if they change sign several times there may be more than one.
Why does a spreadsheet's NPV give a different number?
A spreadsheet's NPV function discounts its first value by one period. This calculator, like financial calculators, treats the first line as today's cash flow. Add the initial outlay separately to the spreadsheet's NPV and the results match.
Is this financial advice?
No. It is an educational tool that applies the standard formulas to the numbers you enter. Decisions about loans and investments should consider fees, taxes and your own situation, ideally with a qualified adviser.