Spreadsheet formulas explained, side by side

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.

FunctionWhat it doesExcelGoogle SheetsAirtableNotion
PMTPayment per period for a loan or savings plan✔✔≈≈
FVFuture value of regular payments and a starting balance✔✔≈≈
PVPresent value of a series of future payments✔✔≈≈
NPERNumber of periods to pay off a loan or reach a goal✔✔≈≈
RATEInterest rate per period of a loan or investment✔✔✘✘
NPVNet present value of a series of cash flows✔✔≈≈
IRRInternal rate of return of a series of cash flows✔✔✘✘

✔ built-in function   ≈ works with a workaround formula   ✘ not available