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

YieldDisc

The function wizard for the YieldDisc function looks as follows:

Syntax

YieldDisc(Settlement, Maturity, Price, Redemption[, Basis])

Parameters

Settlement. Securities settlement date.

Maturity. The security's maturity date.

Price. The security's price per $100 face value. The Parameter value must be greater than zero.

Redemption. The security's redemption value per $100 face value. Parameter value must be greater than zero.

Basis. The day calculation method used. Select a value from 0 to 4:

Optional parameter.

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 annual yield of the securities, for which a discount is made.

Comments

The Settlement parameter value should not be less or equal to the Maturity parameter value.

Example

Formula Result Description
=YieldDisc("16.02.2008", "01.03.2008", 199, 200, 3) 0,131012 The annual yield for discounted securities, on the following conditions:
  • The security's settlement date is 16.02.2008.

  • The security's maturity date is 01.03.2008.

  • Securities price is 199.

  • The security's redemption value is 200.

  • The day calculation method - actual/365 days.

=YieldDisc(A11, A2, A3, 100, 2) 0,052823 The annual yield for discounted securities, on the following conditions:
  • The security's settlement date is specified in the cell A1, value is 16.02.2008.

  • The security's maturity date is specified in the A2 cell, value is 01.03.2008.

  • Securities price is specified in the cell A3, value is 99.795.

  • The security's redemption value is 100.

  • The day calculation method - actual.

See also:

Function WizardFinancial FunctionsIFinance.YieldDisc