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
- FVFuture value of an investment.
- IPMTInterest portion of a payment.
- IRRInternal rate of return.
- NPERNumber of payment periods.
- NPVNet present value of cash flows.
- PMTPeriodic payment of a loan (use rate/12 for monthly).
- PPMTPrincipal portion of a payment.
- PVPresent value of an investment.
- RATEInterest rate per period.
- XIRRInternal rate of return of irregular cash flows.
All functions
Future value of an investment.
=FV(rate, nper, pmt, [pv], [type])Interest portion of a payment.
=IPMT(rate, per, nper, pv, [fv], [type])Internal rate of return.
=IRR(values, [guess])Number of payment periods.
=NPER(rate, pmt, pv, [fv], [type])Net present value of cash flows.
=NPV(rate, value1, [value2], ...)Periodic payment of a loan (use rate/12 for monthly).
=PMT(rate, nper, pv, [fv], [type])Principal portion of a payment.
=PPMT(rate, per, nper, pv, [fv], [type])Present value of an investment.
=PV(rate, nper, pmt, [fv], [type])Interest rate per period.
=RATE(nper, pmt, pv, [fv], [type], [guess])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])
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