To work with the tool in Foresight Analytics Platform 10, use the new interface.

RedemptionYield

The function wizard for the RedemptionYield function looks as follows:

Syntax

RedemptionYield(Price, AccumulatedIncome, CouponsDates, Coupons, PaymentDates, Payments, Settlement)

Parameters

Price. Value of security. Parameter value must be greater than zero.

AccumulatedIncome. Accumulated income. Parameter value must be greater than or equal to zero.

CouponsDates. Coupon payments dates.

Coupons. Coupon interest rates. Parameter value must be greater than zero.

PaymentDates. Payment dates.

Payments. Payments values. Parameter value must be greater than or equal to zero.

Settlement. The payment day on securities.

NOTE. To determine the parameter, it is available to specify either the parameter value or the cell address where it is located.

Description

It returns yield to maturity with odd payment periods.

Comments

The RedemptionYield method is an effective redemption yield.

Example

Formula Result Description
=RedemptionYield(1150, 40, A1:A5, A6:A10, A11:A12, A13:A14, A15) 18,03% Effective redemption yield, at the following conditions:
  • The security value is 1150.

  • The accumulated income is 40.

  • Coupon payments dates are specified in the A1:A5 cell range, values: 01.01.2006, 01.04.2006, 01.07.2006, 01.10.2006, 01.01.2007.

  • Coupon interest rates are specified in the range A6:A10, all cells in the range contain identical values equal to 80.

  • Payment dates are specified in the range A11:A12, values: 01.01.2007, 01.04.2007.

  • Payment values are specified in the range A13:A14, all cells in the range contain the same value equal to 500.

  • The security's settlement date is specified in the cell A15, value is 15.12.2005.

See also:

Function WizardFinancial FunctionsIFinance.RedemptionYield