Excel Financial Functions List
Investment Value Functions
FV Calculates the future value of an investment with periodic constant payments and a constant interest rate
FVSCHEDULE Calculates the future value of an initial principal, after applying a series of compound interest rates
NPV Calculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and income
PV Calculates the present value of an investment (ie. the total amount that a series of future payments is worth now)
RECEIVED Calculates the amount received at maturity for a fully invested Security
XNPV Calculates the net present value for a schedule of cash flows
Payment Functions
CUMIPMT Calculates the cumulative interest paid between two specified periods
CUMPRINC Calculates the cumulative principal paid on a loan, between two specified periods
IPMT Calculates the interest payment for a given period of an investment, with periodic constant payments and a constant interest rate
ISPMT Returns the interest paid during a specified period of an investment
PMT Calculates the payments required to reduce a loan, from a supplied present value to a specified future value
PPMT Calculates the payment on the principal for a given investment, with periodic constant payments and a constant interest rate
Duration Functions
COUPDAYBS Calculates the number of days from the beginning of the coupon period to the settlement date
COUPDAYS Calculates the number of days in the coupon period that contains the settlement date
COUPDAYSNC Calculates the number of days from the settlement date to the next coupon date
COUPNCD Returns the next coupon date after the settlement date
COUPNUM Returns the number of coupons payable between the settlement date and maturity date
COUPPCD Returns the previous coupon date, before the settlement date
DURATION Calculates the Macauley duration of a security with an assumed par value of $100
MDURATION Calculates the...