Financial Functions
Loan payments, future value, present value, NPV and IRR. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| PMT | Payment per period for a loan or savings plan | ✔ | ✔ | ≈ | ≈ |
| FV | Future value of regular payments and a starting balance | ✔ | ✔ | ≈ | ≈ |
| PV | Present value of a series of future payments | ✔ | ✔ | ≈ | ≈ |
| NPER | Number of periods to pay off a loan or reach a goal | ✔ | ✔ | ≈ | ≈ |
| RATE | Interest rate per period of a loan or investment | ✔ | ✔ | ✘ | ✘ |
| NPV | Net present value of a series of cash flows | ✔ | ✔ | ≈ | ≈ |
| IRR | Internal rate of return of a series of cash flows | ✔ | ✔ | ✘ | ✘ |
✔ built-in function ≈ works with a workaround formula ✘ not available