## Excel YIELDDISC function

The YIELDDISC function returns the annual yield for a discounted security.

#### Syntax

YIELDDISC(settlement, maturity, pr, redemption, [basis])

#### Arguments

• Settlement (required): The settlement date of the security. It is the date after the issue date when the security is purchased;
• Maturity (required): The maturity date of the security. It is the date on which the security expires;
• Pr (required): The security’s price per \$100 face value;
• Redemption (required): The security’s redemption value per \$100 face value;
• Basis (optional): An integer number (0, 1, 2, 3 or 4) specifying the day basis to be used. Default is 0.
 Basis Date System o or omitted US (NASD) 30/360 1 Actual/actual 2 Actual/360 3 Actual/365 4 European 30/360

#### Remarks

1. In Excel, dates can be used in calculations as they are stored as sequential numbers. By default, 1/1/1900 is serial number 1, so 12/1/2021 is serial number 40877 because it is 40876 days after 1/1/1900;
2. Dates provided for “settlement” and “maturity” should be entered:
-- As references to cells containing dates;
-- By using the DATE function;
-- As results returned from other formulas.
3. If settlement, maturity, frequency, and basis contain decimal, they will be truncated to integers;
4. The #NUM! error occurs when either of the following conditions is met:
-- The settlement date is greater than or equal to the maturity date;
-- Any of the supplied arguments “rate”, “pr”, “redemption”, “frequency” or “basis” is an invalid number.
Such as: "rate" < 0; "pr" ≤ 0; "redemption" ≤ 0; "frequency" is not equal to 1, 2 or 4; or [basis] is any number other than 0, 1, 2, 3 or 4.
5. The #VALUE! error occurs when either of the following conditions is met:
-- “Settlement” and “maturity” dates are invalid;
-- Any of the supplied arguments are non-numeric.

#### Return Value

It returns a numeric value.

#### Example

As shown in the screenshot below, a security is purchased on January 15, 2021 for \$98.00 per \$100 face value, and it will expire on December 1, 2021. The security’s redemption value is \$100. To calculate the annual yield for this discounted security using the actual/actual day count basis (basis=1), you can do as follows.

1. Select a blank cell (here I select F5), enter the following formula and press Enter to get the result.

=YIELDDISC(C5,C6,C7,C8,C9)

2. Then change the cell format to percentage according to your needs.

#### Related Functions

Excel YIELD function
The YIELD function returns the annual yield for a discounted security.

Excel YIELDMAT function
The YIELDMAT function returns the annual yield of a security that pays interest at maturity.

### The Best Office Productivity Tools

#### Kutools for Excel - Helps You To Stand Out From Crowd

 🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions… Popular Features: Find, Highlight or Identify Duplicates  |  Delete Blank Rows  |  Combine Columns or Cells without Losing Data  |  Round without Formula ... Super VLookup: Multiple Criteria  |  Multiple Value  |  Across Multi-Sheets  |  Fuzzy Lookup... Adv. Drop-down List: Easy Drop Down List  |  Dependent Drop Down List  |  Multi-select Drop Down List... Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Columns to Select Same & Different Cells ... Featured Features: Grid Focus  |  Design View  |  Big Formula Bar  |  Workbook & Sheet Manager | Resource Library (Auto Text)  |  Date Picker  |  Combine Worksheets  |  Encrypt/Decrypt Cells  |  Send Emails by List  |  Super Filter  |  Special Filter (filter bold/italic/strikethrough...) ... Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters ...)  |  50+ Chart Types (Gantt Chart ...)  |  40+ Practical Formulas (Calculate age based on birthday ...)  |  19 Insertion Tools (Insert QR Code, Insert Picture from Path ...)  |  12 Conversion Tools (Numbers to Words, Currency Conversion ...)  |  7 Merge & Split Tools (Advanced Combine Rows, Split Excel Cells ...)  |  ... and more

Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...

#### Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

• One second to switch between dozens of open documents!
• Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
• Increases your productivity by 50% when viewing and editing multiple documents.
• Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.