# Excel financial functions

> Financial functions answer loan and investment questions: what is the payment, what will this grow to, how long will it take, what rate am I really paying.

Source: https://spreadsheetpractice.com/functions/category/finance · Updated October 29, 2026

Financial functions answer loan and investment questions: what is the payment, what will this grow to, how long will it take, what rate am I really paying. Two habits prevent almost every wrong answer. Match the rate to the period (an annual rate divided by 12 for monthly payments), and keep signs consistent: money you pay out is negative, money you receive is positive.

## Which one to use

| You want to | Use | Why |
|---|---|---|
| Find the payment on a loan or mortgage | [PMT](https://spreadsheetpractice.com/functions/pmt) | Returns the fixed payment per period from the rate, number of payments and amount borrowed. |
| See what regular savings will grow to | [FV](https://spreadsheetpractice.com/functions/fv) | Compounds deposits and a starting balance forward to a future date. |
| Work out what a future amount is worth today | [PV](https://spreadsheetpractice.com/functions/pv) | Discounts future payments or a lump sum back to today. |
| Count how many payments it takes | [NPER](https://spreadsheetpractice.com/functions/nper) | Solves for the number of periods to pay off a debt or reach a goal. |
| Find the interest rate behind a deal | [RATE](https://spreadsheetpractice.com/functions/rate) | Solves for the rate per period when you know the payment and the amount. |
| Decide whether a project is worth it | [NPV](https://spreadsheetpractice.com/functions/npv) | Discounts a series of cash flows; pair it with IRR for the return. |

## All 7 financial functions

| Function | What it does | Available in |
|---|---|---|
| [FV](https://spreadsheetpractice.com/functions/fv) | FV calculates what an investment will be worth in the future, given regular deposits, a starting balance and a constant rate of return. | Every current version |
| [IRR](https://spreadsheetpractice.com/functions/irr) | IRR calculates the internal rate of return: the discount rate at which a series of cash flows has a net present value of zero. | Every current version |
| [NPER](https://spreadsheetpractice.com/functions/nper) | NPER calculates how many payment periods it takes to pay off a loan or reach a savings goal, at a fixed payment and interest rate. | Every current version |
| [NPV](https://spreadsheetpractice.com/functions/npv) | NPV discounts a series of future cash flows back to today at a given rate, so you can judge whether an investment beats your cost of capital. | Every current version |
| [PMT](https://spreadsheetpractice.com/functions/pmt) | PMT calculates the fixed payment for a loan or a savings plan, based on a constant interest rate and number of payments. | Every current version |
| [PV](https://spreadsheetpractice.com/functions/pv) | PV calculates what a series of future payments, or a single future amount, is worth today at a given interest rate. | Every current version |
| [RATE](https://spreadsheetpractice.com/functions/rate) | RATE works out the interest rate per period from the number of payments, the payment and the amount borrowed or invested. | Every current version |

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
