The most comprehensive educational resources for finance

Annuity Functions in Excel

Microsoft Excel provides various functions to perform constant annuity calculations. These functions can be used for both loans and investments. Constant annuities are streams of equal cash flows occurring at equal intervals. All annuities are governed by a set of variables. Excel provides functions for all these variables. These variables are: Rate: The interest rate