Title: Theory / Unimportant / CS / Softw / Website / Google / Sheets / Financial
On every note of this deck, unless a note says otherwise:
Page: https://support.google.com/docs/table/25273?hl=en
Language: Sheets
Context: Financial

Instruction: ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])
Returns: Calculates the accrued interest of a security that has periodic payments. Learn more

Instruction: ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Returns: Calculates the accrued interest of a security that pays interest at maturity. Learn more

Instruction: AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis])
Returns: Returns the depreciation for an accounting period, or the prorated depreciation if the asset was purchased in the middle of a period. Learn more.

Instruction: COUPDAYBS(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates the number of days from the first coupon, or interest payment, until settlement. Learn more

Instruction: COUPDAYS(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates the number of days in the coupon, or interest payment, period that contains the specified settlement date. Learn more

Instruction: COUPDAYSNC(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates the number of days from the settlement date until the next coupon, or interest payment. Learn more

Instruction: COUPNCD(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates next coupon, or interest payment, date after the settlement date. Learn more

Instruction: COUPNUM(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates the number of coupons, or interest payments, between the settlement date and the maturity date of the investment. Learn more

Instruction: COUPPCD(settlement, maturity, frequency, [day_count_convention])
Returns: Calculates last coupon, or interest payment, date before the settlement date. Learn more

Instruction: CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Returns: 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

Instruction: CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning)
Returns: 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

Instruction: DB(cost, salvage, life, period, [month])
Returns: Calculates the depreciation of an asset for a specified period using the arithmetic declining balance method. Learn more

Instruction: DDB(cost, salvage, life, period, [factor])
Returns: Calculates the depreciation of an asset for a specified period using the double-declining balance method. Learn more

Instruction: DISC(settlement, maturity, price, redemption, [day_count_convention])
Returns: Calculates the discount rate of a security based on price. Learn more

Instruction: DOLLARDE(fractional_price, unit)
Returns: Converts a price quotation given as a decimal fraction into a decimal value. Learn more

Instruction: DOLLARFR(decimal_price, unit)
Returns: Converts a price quotation given as a decimal value into a decimal fraction. Learn more

Instruction: DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .
Returns: 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

Instruction: EFFECT(nominal_rate, periods_per_year)
Returns: Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year. Learn more

Instruction: FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
Returns: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: FVSCHEDULE(principal, rate_schedule)
Returns: Calculates the future value of some principal based on a specified series of potentially varying interest rates. Learn more

Instruction: INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])
Returns: 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

Instruction: IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Returns: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: IRR(cashflow_amounts, [rate_guess])
Returns: Calculates the internal rate of return on an investment based on a series of periodic cash flows. Learn more

Instruction: ISPMT(rate, period, number_of_periods, present_value)
Returns: The ISPMT function calculates the interest paid during a particular period of an investment. Learn more.

Instruction: MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])
Returns: Calculates the modified Macaulay duration of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more

Instruction: MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate)
Returns: 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

Instruction: NOMINAL(effective_rate, periods_per_year)
Returns: Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year. Learn more

Instruction: NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning])
Returns: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: NPV(discount, cashflow1, [cashflow2, ...])
Returns: Calculates the net present value of an investment based on a series of periodic cash flows and a discount rate. Learn more

Instruction: PDURATION(rate, present_value, future_value)
Returns: Returns the number of periods for an investment to reach a specific value at a given rate. Learn more.

Instruction: PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning])
Returns: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])
Returns: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Returns: Calculates the price of a security paying periodic interest, such as a US Treasury Bond, based on expected yield. Learn more

Instruction: PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])
Returns: Calculates the price of a discount (non-interest-bearing) security, based on expected yield. Learn more

Instruction: PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention])
Returns: Calculates the price of a security paying interest at maturity, based on expected yield. Learn more

Instruction: PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning])
Returns: Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate. Learn more

Instruction: RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess])
Returns: Calculates the interest rate of an annuity investment based on constant-amount periodic payments and the assumption of a constant interest rate. Learn more

Instruction: RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
Returns: Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more

Instruction: RRI(number_of_periods, present_value, future_value)
Returns: Returns the interest rate needed for an investment to reach a specific value within a given number of periods. Learn more.

Instruction: SLN(cost, salvage, life)
Returns: Calculates the depreciation of an asset for one period using the straight-line method. Learn more

Instruction: SYD(cost, salvage, life, period)
Returns: Calculates the depreciation of an asset for a specified period using the sum of years digits method. Learn more

Instruction: TBILLEQ(settlement, maturity, discount)
Returns: Calculates the equivalent annualized rate of return of a US Treasury Bill based on discount rate. Learn more

Instruction: TBILLPRICE(settlement, maturity, discount)
Returns: Calculates the price of a US Treasury Bill based on discount rate. Learn more

Instruction: TBILLYIELD(settlement, maturity, price)
Returns: Calculates the yield of a US Treasury Bill based on price. Learn more

Instruction: VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
Returns: Returns the depreciation of an asset for a particular period (or partial period). Learn more.

Instruction: XIRR(cashflow_amounts, cashflow_dates, [rate_guess])
Returns: Calculates the internal rate of return of an investment based on a specified series of potentially irregularly spaced cash flows. Learn more

Instruction: XNPV(discount, cashflow_amounts, cashflow_dates)
Returns: 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

Instruction: YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention])
Returns: Calculates the annual yield of a security paying periodic interest, such as a US Treasury Bond, based on price. Learn more

Instruction: YIELDDISC(settlement, maturity, price, redemption, [day_count_convention])
Returns: Calculates the annual yield of a discount (non-interest-bearing) security, based on price. Learn more

Instruction: YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention])
Returns: Calculates the annual yield of a security paying interest at maturity, based on price. Learn more