Skip to content

Excel functions · 51 functions

Excel financial functions

Loan payments, interest and principal parts, future and present value, net present value, internal rate of return, depreciation and bond calculations.

Functions explained in full

All functions

  • FVGDFull page

    Future value of an investment.

    =FV(rate, nper, pmt, [pv], [type])
  • IPMTFAİZTUTARIFull page

    Interest portion of a payment.

    =IPMT(rate, per, nper, pv, [fv], [type])
  • IRRİÇ_VERİM_ORANIFull page

    Internal rate of return.

    =IRR(values, [guess])
  • NPERTAKSİT_SAYISIFull page

    Number of payment periods.

    =NPER(rate, pmt, pv, [fv], [type])
  • NPVNBDFull page

    Net present value of cash flows.

    =NPV(rate, value1, [value2], ...)
  • PMTDEVRESEL_ÖDEMEFull page

    Periodic payment of a loan (use rate/12 for monthly).

    =PMT(rate, nper, pv, [fv], [type])
  • PPMTANA_PARA_ÖDEMESİFull page

    Principal portion of a payment.

    =PPMT(rate, per, nper, pv, [fv], [type])
  • PVBDFull page

    Present value of an investment.

    =PV(rate, nper, pmt, [fv], [type])
  • RATEFAİZ_ORANIFull page

    Interest rate per period.

    =RATE(nper, pmt, pv, [fv], [type], [guess])
  • XIRRAİÇVERİMORANIFull page

    Internal rate of return of irregular cash flows.

    =XIRR(values, dates, [guess])
  • ACCRINTGERÇEKFAİZ

    Accrued interest for a security that pays periodic interest.

    =ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
  • ACCRINTMGERÇEKFAİZV

    Accrued interest paid at maturity.

    =ACCRINTM(issue, settlement, rate, [par], [basis])
  • AMORDEGRC

    Degressive depreciation for each accounting period (French system).

    =AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
  • AMORLINC

    Linear depreciation for each accounting period (French system).

    =AMORLINC(cost, date_purchased, first_period, salvage, period, rate, [basis])
  • COUPDAYBSKUPONGÜNBD

    Days from the beginning of the coupon period to settlement.

    =COUPDAYBS(settlement, maturity, frequency, [basis])
  • COUPDAYSKUPONGÜN

    Days in the coupon period containing settlement.

    =COUPDAYS(settlement, maturity, frequency, [basis])
  • COUPDAYSNCKUPONGÜNDSK

    Days from settlement to the next coupon date.

    =COUPDAYSNC(settlement, maturity, frequency, [basis])
  • COUPNCDKUPONGÜNSKT

    Next coupon date after settlement.

    =COUPNCD(settlement, maturity, frequency, [basis])
  • COUPNUMKUPONSAYI

    Number of coupons between settlement and maturity.

    =COUPNUM(settlement, maturity, frequency, [basis])
  • COUPPCDKUPONGÜNÖKT

    Previous coupon date before settlement.

    =COUPPCD(settlement, maturity, frequency, [basis])
  • CUMIPMTTOPÖDENENFAİZ

    Cumulative interest paid between two periods.

    =CUMIPMT(rate, nper, pv, start_period, end_period, type)
  • CUMPRINCTOPANAPARA

    Cumulative principal paid between two periods.

    =CUMPRINC(rate, nper, pv, start_period, end_period, type)
  • DBAZALANBAKİYE

    Fixed-declining balance depreciation.

    =DB(cost, salvage, life, period, [month])
  • DDBÇİFTAZALANBAKİYE

    Double-declining balance depreciation.

    =DDB(cost, salvage, life, period, [factor])
  • DISCİNDİRİM

    Discount rate for a security.

    =DISC(settlement, maturity, pr, redemption, [basis])
  • DOLLARDELİRAON

    Converts a fractional price to a decimal.

    =DOLLARDE(fractional_dollar, fraction)
  • DOLLARFRLİRAKES

    Converts a decimal price to a fraction.

    =DOLLARFR(decimal_dollar, fraction)
  • DURATIONSÜRE

    Macaulay duration of a security.

    =DURATION(settlement, maturity, coupon, yld, frequency, [basis])
  • EFFECTETKİN

    Effective annual interest rate.

    =EFFECT(nominal_rate, npery)
  • FVSCHEDULEGDPROGRAM

    Future value with a schedule of rates.

    =FVSCHEDULE(principal, schedule)
  • INTRATEFAİZORANI

    Interest rate for a fully invested security.

    =INTRATE(settlement, maturity, investment, redemption, [basis])
  • ISPMT

    Interest paid in a period (even principal).

    =ISPMT(rate, per, nper, pv)
  • MDURATIONMSÜRE

    Modified Macaulay duration.

    =MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
  • MIRRD_İÇ_VERİM_ORANI

    Modified internal rate of return.

    =MIRR(values, finance_rate, reinvest_rate)
  • NOMINALNOMİNAL

    Nominal annual interest rate.

    =NOMINAL(effect_rate, npery)
  • PDURATIONPSÜRE

    Periods required to reach a value.

    =PDURATION(rate, pv, fv)
  • PRICEDEĞER

    Price per 100 of a security that pays periodic interest.

    =PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
  • PRICEDISCDEĞERİND

    Price per 100 of a discounted security.

    =PRICEDISC(settlement, maturity, discount, redemption, [basis])
  • PRICEMATDEĞERVADE

    Price per 100 of a security that pays interest at maturity.

    =PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
  • RECEIVEDGETİRİ

    Amount received at maturity.

    =RECEIVED(settlement, maturity, investment, discount, [basis])
  • RRIGERÇEKLEŞENYATIRIMGETİRİSİ

    Equivalent interest rate for growth.

    =RRI(nper, pv, fv)
  • SLNDA

    Straight-line depreciation.

    =SLN(cost, salvage, life)
  • SYDYAT

    Sum-of-years' digits depreciation.

    =SYD(cost, salvage, life, per)
  • TBILLEQHTAHEŞ

    Bond-equivalent yield of a Treasury bill.

    =TBILLEQ(settlement, maturity, discount)
  • TBILLPRICEHTAHDEĞER

    Price per 100 of a Treasury bill.

    =TBILLPRICE(settlement, maturity, discount)
  • TBILLYIELDHTAHÖDEME

    Yield of a Treasury bill.

    =TBILLYIELD(settlement, maturity, pr)
  • VDBDAB

    Variable declining balance depreciation.

    =VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
  • XNPVANBD

    Net present value of irregular cash flows.

    =XNPV(rate, values, dates)
  • YIELDÖDEME

    Yield on a security that pays periodic interest.

    =YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
  • YIELDDISCÖDEMEİND

    Annual yield of a discounted security.

    =YIELDDISC(settlement, maturity, pr, redemption, [basis])
  • YIELDMATÖDEMEVADE

    Annual yield of a security that pays interest at maturity.

    =YIELDMAT(settlement, maturity, issue, rate, pr, [basis])

Excel functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free