Returns the price per $100 face value of a security that pays periodic interest.
Söz dizimi
PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])Bağımsız değişkenler
settlementzorunlu
The security's settlement date.
maturityzorunlu
The security's maturity date.
ratezorunlu
The security's annual coupon rate.
yldzorunlu
The security's annual yield.
redemptionzorunlu
The security's redemption value per $100 face value.
frequencyzorunlu
The number of coupon payments per year (1, 2, or 4).
basisisteğe bağlı
The type of day count basis to use.
The PRICE function calculates the market price of a bond based on its yield, maturity date, and coupon rate. It is commonly used to determine the present value of a security that pays interest at regular intervals.
=PRICE("2023-01-01", "2033-01-01", 0.05, 0.04, 100, 2)→108.17Calculates the price of a bond with a 5% coupon and 4% yield, maturing in 10 years.
Input bond details
Ensure your settlement and maturity dates are entered in a format Excel recognizes.
Apply the formula
Enter the PRICE function with the required financial parameters to calculate the bond price.
The function will return a #NUM! error.