Excel Financial Formulas
Financial functions for investment calculations, loans, depreciation, and profitability analysis.
55 formulas
0 Beginner
19 Intermediate
36 Advanced
PMT
Intermediate
=PMT(rate, nper, pv, [fv], [type])PPMT
Intermediate
=PPMT(rate, per, nper, pv, [fv], [type])IPMT
Intermediate
=IPMT(rate, per, nper, pv, [fv], [type])PV
Intermediate
=PV(rate, nper, pmt, [fv], [type])FV
Intermediate
=FV(rate, nper, pmt, [pv], [type])NPER
Intermediate
=NPER(rate, pmt, pv, [fv], [type])RATE
Intermediate
=RATE(nper, pmt, pv, [fv], [type], [guess])NPV
Advanced
=NPV(rate, value1, [value2], ...)XNPV
Advanced
=XNPV(rate, values, dates)IRR
Advanced
=IRR(values, [guess])XIRR
Advanced
=XIRR(values, dates, [guess])MIRR
Advanced
=MIRR(values, finance_rate, reinvest_rate)SLN
Intermediate
=SLN(cost, salvage, life)DB
Intermediate
=DB(cost, salvage, life, period, [month])DDB
Intermediate
=DDB(cost, salvage, life, period, [factor])SYD
Intermediate
=SYD(cost, salvage, life, per)CUMIPMT
Advanced
=CUMIPMT(rate, nper, pv, start_period, end_period, type)CUMPRINC
Advanced
=CUMPRINC(rate, nper, pv, start_period, end_period, type)EFFECT
Intermediate
=EFFECT(nominal_rate, npery)NOMINAL
Intermediate
=NOMINAL(effect_rate, npery)FVSCHEDULE
Intermediate
=FVSCHEDULE(principal, schedule)PDURATION
Intermediate
=PDURATION(rate, pv, fv)RRI
Intermediate
=RRI(nper, pv, fv)ACCRINT
Advanced
=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])ACCRINTM
Advanced
=ACCRINTM(issue, settlement, rate, par, [basis])AMORDEGRC
Advanced
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])AMORLINC
Advanced
=AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])COUPDAYBS
Advanced
=COUPDAYBS(settlement, maturity, frequency, [basis])COUPDAYS
Advanced
=COUPDAYS(settlement, maturity, frequency, [basis])COUPDAYSNC
Advanced
=COUPDAYSNC(settlement, maturity, frequency, [basis])COUPNCD
Advanced
=COUPNCD(settlement, maturity, frequency, [basis])COUPNUM
Advanced
=COUPNUM(settlement, maturity, frequency, [basis])COUPPCD
Advanced
=COUPPCD(settlement, maturity, frequency, [basis])DISC
Advanced
=DISC(settlement, maturity, pr, redemption, [basis])DOLLARDE
Intermediate
=DOLLARDE(fractional_dollar, fraction)DOLLARFR
Intermediate
=DOLLARFR(decimal_dollar, fraction)DURATION
Advanced
=DURATION(settlement, maturity, coupon, yld, frequency, [basis])INTRATE
Advanced
=INTRATE(settlement, maturity, investment, redemption, [basis])MDURATION
Advanced
=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])ODDFPRICE
Advanced
=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])ODDFYIELD
Advanced
=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])ODDLPRICE
Advanced
=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])ODDLYIELD
Advanced
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])PRICE
Advanced
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])PRICEDISC
Advanced
=PRICEDISC(settlement, maturity, discount, redemption, [basis])PRICEMAT
Advanced
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])RECEIVED
Advanced
=RECEIVED(settlement, maturity, investment, discount, [basis])TBILLEQ
Advanced
=TBILLEQ(settlement, maturity, discount)TBILLPRICE
Advanced
=TBILLPRICE(settlement, maturity, discount)TBILLYIELD
Advanced
=TBILLYIELD(settlement, maturity, pr)VDB
Advanced
=VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])YIELD
Advanced
=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])YIELDDISC
Advanced
=YIELDDISC(settlement, maturity, pr, redemption, [basis])YIELDMAT
Advanced
=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])ISPMT
Intermediate
=ISPMT(rate, per, nper, pv)