Finansal Fonksiyonlar

Top  Previous  Next

Name

Description

Syntax

ACCRINTM

 

 

Returns the accrued interest for a security that pays interest at maturity.

ACCRINTM(issue, settlement, rate, par, [basis])

COUPDAYBS

 

Returns the number of days from the beginning of a coupon period until its settlement date.

COUPDAYBS(settlement, maturity, frequency, [basis])

COUPNCD

 

Returns the next coupon date after the settlement date.

COUPNCD(settlement, maturity, frequency, [basis])

COUPNUM

 

Returns the number of coupons payable between the settlement date and maturity date.

COUPNUM(settlement, maturity, frequency, [basis])

COUPPCD

 

Returns the previous coupon date before the settlement date.

COUPPCD(settlement, maturity, frequency, [basis])

CUMIPMT

 

Returns the cumulative interest paid on a loan between two periods.

CUMIPMT(rate, nper, pv, start_period, end_period, type)

CUMPRINC

 

Returns the cumulative principal paid on a loan between two periods.

CUMPRINC(rate, nper, pv, start_period, end_period, type)

DB

 

Returns the depreciation of an asset for a specified period using the fixed-declining balance method.

DB(cost, salvage, life, period, [month])

DDB

 

Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.

DDB(cost, salvage, life, period, [factor])

DISC

 

Returns the discount rate for a security.

DISC(settlement, maturity, pr, redemption, [basis])

DOLLARDE

 

Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.

DOLLARDE(fractional_dollar, fraction)

DOLLARFR

 

Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.

DOLLARFR(decimal_dollar, fraction)

FVSCHEDULE

 

Returns the future value of an initial principal after applying a series of compound interest rates.

FVSCHEDULE(principal, schedule)

EFFECT

 

Returns the effective annual interest rate.

EFFECT(nominal_rate, npery)

FV

 

Calculates the future value of an investment based on a constant interest rate.

FV(rate,nper,pmt,[pv],[type])

INTRATE

 

Returns the interest rate for a fully invested security.

INTRATE(settlement, maturity, investment, redemption, [basis])

IPMT

 

Returns the interest payment for a given period for an investment based on periodic constant payments and a constant interest rate.

IPMT(rate, per, nper, pv, [fv], [type])

IRR

 

Calculates the internal rate of return for a series of cash flows.

IRR(values, [guess])

ISPMT

 

Calculates the interest paid during a specific period of a loan (or investment).

ISPMT(rate, per, nper, pv)

MIRR

 

Returns the modified internal rate of return for a series of periodic cash flows.

MIRR(values, finance_rate, reinvest_rate)

NOMINAL

 

Returns the annual nominal interest rate.

NOMINAL(effect_rate, npery)

NPER

 

Returns the number of periods for an investment based on periodic constant payments and a constant interest rate.

NPER(rate,pmt,pv,[fv],[type])

NPV

 

Calculates the net present value of an investment based on a discount rate and a series of future payments and income.

NPV(rate,value1,[value2],…)

PDURATION

 

Returns the number of periods required by an investment to reach a specified value.

PDURATION(rate, pv, fv)

PMT

 

Calculates the payment for a loan based on constant payments and a constant interest rate.

PMT(rate, nper, pv, [fv], [type])

PPMT

 

Returns the payment on the principal for a given period for an investment based on periodic constant payments and a constant interest rate.

PPMT(rate, per, nper, pv, [fv], [type])

PRICE

 

Returns the price per $100 face value of a security that pays periodic interest.

PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])

PRICEDISC

 

Returns the price per $100 face value of a discounted security.

PRICEDISC(settlement, maturity, discount, redemption, [basis])

PV

 

Calculates the present value of a loan or an investment based on a constant interest rate.

PV(rate, nper, pmt, [fv], [type])

RATE

 

Returns the interest rate per period of an annuity.

RATE(nper, pmt, pv, [fv], [type], [guess])

RECEIVED

 

Returns the amount received at maturity for a fully invested security.

RECEIVED(settlement, maturity, investment, discount, [basis])

RRI

 

Returns an equivalent interest rate for the growth of an investment.

RRI(nper, pv, fv)

SLN

 

Returns the straight-line depreciation of an asset for one period.

SLN(cost, salvage, life)

SYD

 

Returns the sum-of-years’ digits depreciation of an asset for a specified period.

SYD(cost, salvage, life, per)

TBILLEQ

 

Returns the bond-equivalent yield for a Treasury bill.

TBILLEQ(settlement, maturity, discount)

TBILLPRICE

 

Returns the price per $100 face value for a Treasury bill.

TBILLPRICE(settlement, maturity, discount)

TBILLYIELD

 

Returns the yield for a Treasury bill.

TBILLYIELD(settlement, maturity, pr)

VDB

 

Returns the depreciation of an asset for a specified or partial period using a declining balance method.

VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]).

XIRR

 

Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic.

XIRR(values, dates, [guess])

XNPV

 

Returns the net present value for a schedule of cash flows that is not necessarily periodic.

XNPV(rate, values, dates)

YIELD

 

Returns the yield on a security that pays periodic interest.

YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])

YIELDDISC

 

Returns the annual yield for a discounted security.

YIELDDISC(settlement, maturity, pr, redemption, [basis])