Financial functions (reference) - Microsoft Support
List Financial functions, such as the DURATION, RATE, and PMT functions.
Using Excel formulas to figure out payments and savings
Managing personal finances can be a challenge, especially when trying to plan your payments and savings. Excel formulas and budgeting templates can help you calculate the future value …
PMT function - Microsoft Support
How to use the PMT function in Excel to calculate monthly loan payments based on constant payments and a constant interest rate.
Excel functions (by category) - Microsoft Support
Detect errors in formulas. Lists all Excel functions by their category, such as Logical functions or Text functions.
Go with the cash flow: Calculate NPV and IRR in Excel
There are five: NPV function, XNPV function, IRR function, XIRR function, and MIRR function. Which one you choose depends on the financial method that you prefer, whether cash flows …
RATE function - Microsoft Support
This article describes the formula syntax and usage of the RATE function in Microsoft Excel. Returns the interest rate per period of an annuity. RATE is calculated by iteration and can …
Examples of common formulas in lists - Microsoft Support
The following is an alphabetical list of links to functions available to SharePoint users. It includes trigonometric, statistical, and financial functions, as well as conditional, date, math, and text …
Financial functions (reference) - Microsoft Support
List Financial functions, such as the DURATION, RATE, and PMT functions.
Using Excel formulas to figure out payments and savings
Managing personal finances can be a challenge, especially when trying to plan your payments and savings. Excel formulas and budgeting templates can help you calculate the future value …
FV function - Microsoft Support
FV, one of the financial functions, calculates the future value of an investment based on a constant interest rate. You can use FV with either periodic, constant payments, or a single …
PV function - Microsoft Support
PV, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a …