Useful financial functions in Excel

PV
Present value of an annuity
NPV
Net present value of periodic cash flows
FV
Future value of an annuity
RATE
Rate of return of an annuity
IRR
Internal rate of return of periodic cash flows
PRICE
Price of a coupon bond
PRICEDISC
Price of a discount bond
TBILLPRICE
Price of T-bill (special case of PRICEDISC)
YIELD
Yield of coupon bond
YIELDDISC
Yield of discount bond
TBILLYIELD
Yield of T-bill
ACCRINT
Accrued interest
COUPNUM
Number of coupons remaining
COUPNCD
Next coupon date
COUPPCD
Previous coupon date
COUPDAYS
Number of days in current coupon period
COUPDAYBS
Number of days between previous coupon and settlement
COUPDAYSNC
Number of days between settlement and next coupon
DURATION
Duration of a coupon bond
MDURATION
Modified duration
EFFECT
Effective annual interest rate
TBILLEQ
Bond equivalent yield of a T-bill