PRICE
Returns the price per $100 face value of a security that pays periodic interest.
FinancialFinance & Accounting
What it does
Calculates price of a bond paying periodic interest.
Syntax
PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.rate(number) — Coupon rate.yld(number) — Yield.redemption(number) — Redemption value.frequency(number) — Coupons per year.
Examples
Bond Price
Calculate price.
FORMULA
=PRICE(A2, B2, 0.06, 0.05, 100, 2)
RESULT
108.42
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2033-01-01 |