Functions
PRICEMAT
Price at maturity
Try it
When to use it
When should I use PRICEMAT?
Use PRICEMAT to calculate the price per $100 face value of a security that pays interest at maturity — useful for pricing zero-coupon or maturity-interest bonds where no periodic coupon is paid.
Used in
Syntax
PRICEMAT(settlement, maturity, issue, rate, yld, [basis])Examples
=PRICEMAT(DATE(2010,1,2),DATE(2039,12,31),DATE(2010,1,1),0.03,1.2) // => 5.127264468270414
=PRICEMAT(DATE(2010,1,2),DATE(2039,12,31),DATE(2010,1,1),0.03,1.2,1) // => 5.127606514747337