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
Apri schedaFunzioni Google Sheets
Una scheda strutturata per ogni funzione: sintassi, argomenti, esempi pratici, errori comuni, FAQ e collegamenti a formule correlate.
Digita almeno 2 lettere per vedere i suggerimenti.
ACCRINTM
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculates the accrued interest of a security that pays interest at maturity. Learn more
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.
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
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
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
Apri schedaCOUPNCD
COUPNCD(settlement, maturity, frequency, [day_count_convention])
Calculates next coupon, or interest payment, date after the settlement date. Learn more
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
Apri schedaCOUPPCD
COUPPCD(settlement, maturity, frequency, [day_count_convention])
Calculates last coupon, or interest payment, date before the settlement date. Learn more
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
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
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
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
Apri schedaDISC
DISC(settlement, maturity, price, redemption, [day_count_convention])
Calculates the discount rate of a security based on price. Learn more
Apri schedaDOLLARDE
DOLLARDE(fractional_price, unit)
Converts a price quotation given as a decimal fraction into a decimal value. Learn more
Apri schedaDOLLARFR
DOLLARFR(decimal_price, unit)
Converts a price quotation given as a decimal value into a decimal fraction. Learn more
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
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
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
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
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
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
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
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.
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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.
Apri schedaSLN
SLN(cost, salvage, life)
Calculates the depreciation of an asset for one period using the straight-line method. Learn more
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
Apri schedaTBILLEQ
TBILLEQ(settlement, maturity, discount)
Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more
Apri schedaTBILLPRICE
TBILLPRICE(settlement, maturity, discount)
Calculates the price of a US Treasury Bill based on discount rate. Learn more
Apri schedaTBILLYIELD
TBILLYIELD(settlement, maturity, price)
Calculates the yield of a US Treasury Bill based on price. Learn more
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.
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
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
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
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
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
Apri scheda