PRICEDISC

The PRICEDISC function in Google Sheets calculates the price of a discount (non-interest-bearing) security, based on expected yield.

Function Syntax and Parameters

Syntax: PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention])

Parameters:

• settlement: The security's settlement date, which is the date after the issue date when the security is traded to the buyer.
• maturity: The security's maturity date, which is the date when the security expires or the date of its redemption.
• discount: The discount rate of the security.
• redemption: The security's redemption value per $100 face value.
• day_count_convention: [Optional] The day count convention to use.

Please note that the day_count_convention parameter is optional and will default to the U.S. (NASD) 30/360 day count convention if not specified.

Step-by-Step Tutorial

Please note that for this particular function, a step-by-step tutorial is not applicable.

Use Cases and Scenarios

Some use cases and scenarios where the PRICEDISC function can be useful:

1. Financial Markets: Determine the price of discount securities in financial markets.
2. Investment Analysis: Calculate the price of non-interest-bearing securities for investment analysis.
3. Treasury Bills: Determine the price of treasury bills and other similar instruments.

Related Functions

• None

Related Articles

• None