ACCRINT
ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Calculates the accrued interest of a security that has periodic payments. Learn more
Finance
Apri schedaFormula reference avanzata
Cerca per funzione o sintassi, filtra i casi d’uso e passa direttamente agli strumenti operativi senza onboarding.
Digita almeno 2 lettere per vedere i suggerimenti.
50 formule trovate
Non sai da dove partire?
Percorsi per livello e use case
Base
Intermedio
Avanzato
Use case
Sfida del giorno
ACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
Finance
Apri schedaAMORLINC
AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more.
Finance
Apri schedaCOUPDAYBS
COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more
Finance
Apri schedaCOUPDAYS
COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more
Finance
Apri schedaCOUPDAYSNC
COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more
Finance
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
Finance
Apri schedaCOUPNUM
COUPNUM(settlement, maturity, frequency, [day_count_convention])
Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more
Finance
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
Finance
Apri schedaCUMIPMT
CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative interest over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaCUMPRINC
CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Calculates the cumulative principal paid over a range of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaDB
DB(cost, salvage, life, period, [month])
Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more
Finance
Apri schedaDDB
DDB(cost, salvage, life, period, [factor])
Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more
Finance
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Finance
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Finance
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
Finance
Apri schedaDURATION
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value. Learn more
Finance
Apri schedaEFFECT
EFFECT(nominal_rate, periods_per_year)
Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more
Finance
Apri schedaFV
FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaFVSCHEDULE
FVSCHEDULE(principal, rate_schedule)
Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more
Finance
Apri schedaINTRATE
INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])
Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself. Learn more
Finance
Apri schedaIPMT
IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaIRR
IRR(cashflow_amounts, [rate_guess])
Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more
Finance
Apri schedaISPMT
ISPMT(rate, period, number_of_periods, present_value)
The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.
Finance
Apri schedaMDURATION
MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])
Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaMIRR
MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Calculates the modified internal rate of return on an investment based on a series of periodic cash flows and the difference between the interest rate paid on financing versus the return received on reinvested income. Learn more
Finance
Apri schedaNOMINAL
NOMINAL(effective_rate, periods_per_year)
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more
Finance
Apri schedaNPER
NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaNPV
NPV(discount, cashflow1, [cashflow2, ...])
Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more
Finance
Apri schedaPDURATION
PDURATION(rate, present_value, future_value)
Returns the number of periods for an investment to reach a specific value at a given rate. Learn more.
Finance
Apri schedaPMT
PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPPMT
PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaPRICE
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more
Finance
Apri schedaPRICEDISC
PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more
Finance
Apri schedaPRICEMAT
PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
Calculates the price of a security paying interest at maturity, based on expected yield. Learn more
Finance
Apri schedaPV
PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more
Finance
Apri schedaRATE
RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more
Finance
Apri schedaRECEIVED
RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more
Finance
Apri schedaRRI
RRI(number_of_periods, present_value, future_value)
Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more.
Finance
Apri schedaSLN
SLN(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
Finance
Apri schedaSYD
SYD(cost, salvage, life, period)
Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more
Finance
Apri schedaTBILLEQ
TBILLEQ(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLPRICE
TBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Finance
Apri schedaTBILLYIELD
TBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
Finance
Apri schedaVDB
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Returns the depreciation of an asset for a particular period (or partial period). Learn more.
Finance
Apri schedaXIRR
XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more
Finance
Apri schedaXNPV
XNPV(discount, cashflow_amounts, cashflow_dates)
Calculates the net present value of an investment based on a specified series of potentially irregularly spaced cash flows and a discount rate. Learn more
Finance
Apri schedaYIELD
YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more
Finance
Apri schedaYIELDDISC
YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more
Finance
Apri schedaYIELDMAT
YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Calculates the annual yield of a security paying interest at maturity, based on price. Learn more
Finance
Apri scheda