Functions
PRICE
Price per $100 face value
Try it
When to use it
When should I use PRICE?
Use PRICE to calculate the fair market price per $100 face value of a coupon-bearing bond given its yield — the standard formula for bond valuation and mark-to-market reporting.
Used in
Syntax
PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])Examples
=PRICE(DATE(2010,1,2),DATE(2039,12,31),0.03,1.2,100,2,0) // => 2.4964231392093046
=PRICE(DATE(2010,1,2),DATE(2039,12,31),0.03,1.2,100,2,1) // => 2.496442712917719