Function library
Every Excel function
All 521 functions from Microsoft’s list, grouped the way Excel groups them. 500 run right here in the practice sheet; the rest come with step-by-step guides for desktop Excel.
Financial
Loans, investments, depreciation and bonds: PMT, FV, NPV, IRR, XIRR.
56 functions
ACCRINTAccrued interest of a periodic-interest securityACCRINTMAccrued interest paid at maturityAMORDEGRCFrench declining-balance depreciationAMORLINCFrench straight-line depreciationCOUPDAYBSDays from coupon start to settlementCOUPDAYSDays in the coupon periodCOUPDAYSNCDays from settlement to next couponCOUPNCDNext coupon date after settlementCOUPNUMNumber of coupons leftCOUPPCDCoupon date before settlementCUMIPMTInterest paid between two periodsCUMPRINCPrincipal paid between two periodsDBFixed-declining balance depreciationDDBDouble-declining balance depreciationDISCDiscount rate of a securityDOLLARDEFraction price to a decimalDOLLARFRDecimal price to a fractionDURATIONMacaulay duration of a bondEFFECTEffective annual interest rateEUROCONVERTConverts between euro-zone currenciesFVFuture value of an investmentFVSCHEDULEFuture value with changing ratesINTRATEInterest rate of a fully invested securityIPMTInterest part of a paymentIRRInternal rate of returnISPMTInterest paid in a period (straight-line loan)MDURATIONModified duration of a bondMIRRModified internal rate of returnNOMINALNominal annual interest rateNPERNumber of payment periodsNPVNet present valueODDFPRICEPrice of a bond with an odd first periodODDFYIELDYield of a bond with an odd first periodODDLPRICEPrice of a bond with an odd last periodODDLYIELDYield of a bond with an odd last periodPDURATIONPeriods to reach a valuePMTPayment for a loanPPMTPrincipal part of a paymentPRICEPrice per $100 of a bondPRICEDISCPrice of a discounted securityPRICEMATPrice of a security that pays interest at maturityPVPresent value of an investmentRATEInterest rate per periodRECEIVEDAmount received at maturityRRIEquivalent interest rate for growthSLNStraight-line depreciationSYDSum-of-years’ digits depreciationTBILLEQBond-equivalent yield of a Treasury billTBILLPRICEPrice of a Treasury billTBILLYIELDYield of a Treasury billVDBDeclining balance depreciation for any periodXIRRInternal rate of return for irregular datesXNPVNet present value of irregular cash flowsYIELDYield of a bondYIELDDISCYield of a discounted securityYIELDMATYield of a security that pays interest at maturity