Expression Editor Functions - Financial Category

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

Format: AccrIntM(issue, settlement, rate[, par[, basis]])

Where:

• Issue is the security's issue date.
• Maturity is the security's maturity date.
• Rate is the security's annual coupon rate.
• Par is the security's par value (with a default value of $1,000).

The basis can be one of the following calculation options:

• 0 (or omitted) uses US (NASD) 30 / 360.
• 1 uses Actual / Actual.
• 2 uses Actual / 360.
• 3 uses Actual / 365.
• 4 uses European 30 / 360.

Returns the compound amount, based on the principal and interest rate per period over the specified number of periods.

Format: Compound(principal, interest, periods)

Returns the number of days in the coupon period which contains the settlement date.

Format: CoupDays(settlement, maturity, frequency[, basis])

Where:

• Settlement is the security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
• Maturity is the security's maturity date. The maturity date is the date when the security expires.
• Frequency is the number of coupon payments per year. For annual payments, frequency = 1; for semi-annual, frequency = 2; for quarterly, frequency = 4.

Returns the number of days from the beginning of the coupon period to the settlement date.

Format: CoupDaysBS(settlement, maturity, frequency[, basis])

Returns the number of days from the settlement date to the next coupon date.

Format: CoupDaysNC(settlement, maturity, frequency[, basis])

Returns the next coupon date after the settlement date.

Format: CoupNCD(settlement, maturity, frequency[, basis])

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

Format: CoupNum(settlement, maturity, frequency[, basis])

Returns the previous coupon date before the settlement date.

Format: CoupPCD(settlement, maturity, frequency[, basis])

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

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

Where:

• Cost is the initial cost of the asset.
• Salvage is the value at the end of the depreciation.
• Life is the number of periods over which the asset is being depreciated.
• Period is the period for which you want to calculate the depreciation.
• Month is the number of months in the first year. If month is omitted, it is assumed to be 12.

Returns the discount rate for a security.

Format: Disc(settlement, maturity, price, redemption[, basis])

Where:

• Settlement is the security's settlement date.
• Maturity is the security's maturity date.
• Price is the security's price per $100 face value.
• Redemption is the security's redemption value per $100 face value.

Returns a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

Format: DollarDe(fractional_dollar, fraction)

Where:

• Fractional_dollar is a number expressed as a fraction.
• Fraction is the integer to use in the denominator of the fraction.

Example: Use DollarDe to convert fractional dollar numbers, such as securities prices, to decimal numbers.

Returns the effective annual interest rate.

Format: Effect(nominal_rate, npery)

Where:

• Nominal_rate is the nominal interest rate.
• Npery is the number of compounding periods per year.

Returns the future value of an annuity, based on the payments per period, interest rate period, and the number of periods.

Format: Fv(payment, rate, periods)

Where:

• Payment is the payment made each period. Payment must be constant over the life of the annuity.
• Rate is the interest rate per period.
• Periods is the total number of payment periods in an annuity.

Returns the interest rate for a fully invested security.

Format: IntRate(settlement, maturity, investment, redemption)

Returns the annual nominal interest rate.

Format: Nominal(effect_rate, npery)

Where:

• Effect_rate is the effective interest rate.
• Npery is the number of compounding periods per year.

Returns the amount of payment required to pay off a loan or mortgage at the given principal, interest rate per period, and number of periods.

Format: Pmp(principal, rate, periods)

Where:

• Payment is the present value, or the total amount that a series of future payments is worth now.
• Rate is the interest rate for the loan.
• Periods is the total number of payments for the loan.

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

Format: Price(settlement, maturity, rate, yield, redemption, frequency[, basis])

Where:

• Settlement is the security's settlement date.
• Maturity is the security's maturity date.
• Rate is the security's interest rate at date of issue.
• Yield is the security's annual yield.
• Redemption is the security's redemption value per $100 face value.
• Frequency is the number of coupon payments per year. For annual payments, frequency = 1; for semi-annual, frequency = 2; for quarterly, frequency = 4.

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

Format: PriceDisc(settlement, maturity, discount, redemption[, basis])

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

Format: PriceMat(settlement, maturity, discount, redemption[, basis])

Returns the present value of an annuity, based on the amount of the payment, the interest rate per period, and the number of periods.

Format: Pv(payment, rate, periods)

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

Format: Received(settlement, maturity, investment, discount[, basis])

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

Format: SYD(cost, salvage, life, per)

Where:

• Cost is the initial cost of the asset.
• Salvage is the value at the end of the depreciation.
• Life is the number of periods over which the asset is being depreciated.
• Per is the period and must use the same unit as life.

Returns the bond-equivalent yield for a treasury bill.

Format: TBillEQ(settlement, maturity, discount)

Where:

• Settlement is the treasury bill's settlement date. The security settlement date is the date after the issue date when the treasury bill is traded to the buyer.
• Maturity is the treasury bill's maturity date. The maturity date is the date when the treasury bill expires.
• Discount is the treasury bill's discount rate.

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

Format: TBillPrice(settlement, maturity, discount)

Returns the yield for a treasury bill.

Format: TBilYield(settlement, maturity, pr)

Where:

• Settlement is the treasury bill's settlement date.
• Maturity is the treasury bill's maturity date.
• Pr is the treasury bill’s price per $100 face value.