Как пользоваться функцией ODDFPRICE в Excel

The ODDFPRICE function in Microsoft Excel and Google Sheets is used to calculate the bond redemption price when dealing with bonds that have an odd (irregular) interest accruing period. This function helps determine the bond’s price using specific values such as the time to maturity, coupon rate, face value, and the current net price.

Function Syntax:

ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yield, redemption, frequency, [basis])

Function Parameters:

• settlement — the settlement date on which the bond price is calculated.
• maturity — the maturity date or the date when the bond expires.
• issue — the issue date when the bond was initially issued.
• first_coupon — the date when the first coupon is paid.
• rate — the coupon rate of the bond.
• yield — the bond»s yield to maturity.
• redemption — the face value or the principal amount of the bond.
• frequency — the frequency of the coupon payments (1 for annual, 2 for semi-annual, etc.).
• basis — an optional parameter that specifies the day count basis to be used.

Example of Use:

Suppose we have a bond that was issued on January 1, 2020, and matures on January 1, 2025. The first coupon payment was made on July 1, 2020. The coupon rate is 5%, the face value of the bond is $1000, the current net price is $950, and coupons are paid semi-annually. We need to calculate the redemption price of this bond using the ODDFPRICE function.

Here’s the formula to calculate the redemption price of the bond:

=ODDFPRICE("01.09.2021", "01.01.2025", "01.01.2020", "01.07.2020", 0.05, 0.06, 1000, 2)

Upon executing this formula, we will obtain the redemption price of the bond.

The ODDFPRICE function is extremely useful for financial analysts, investors, and anyone involved in managing bonds and other financial instruments.

Больше информации: https://support.microsoft.com/ru-ru/office/ценапервнерег-функция-ценапервнерег-d7d664a8-34df-4233-8d2b-922bcf6a69e1