Excel Function : PRICEMAT

Download now!

Excel Function : PRICEMAT

Category

Financial

Description

Returns the price per $100 face value of a security that pays interest at maturity

Microsoft Excel Reference Page

https://support.office.com/en-us/article/PRICEMAT-function-52c3b4da-bc7e-476a-989f-a95f675cae77

Syntax and Description of the PRICEMAT Excel Function

syntax.xlsx 2. Read the PRICEMAT syntax to better understand the syntax of the PRICEMAT function. 3. The inputs to the PRICEMAT function are: • Current Price – Price of the underlying asset at time of expiration. • Strike Price – Price of the underlying asset at which the option expires. • Interest Rate – Interest rate used to discount the option price. • Volatility – Volatility of the underlying asset. • Time to Expiration – Time until the option expires. 4. The outputs of the PRICEMAT function are: • Value of the call option – Value of the call option at time

About PRICEMAT Excel Function

The PRICEMAT function is used to calculate the price of a security with a given maturity date and yield. The function takes as inputs the security's maturity date, yield, and settlement date, and returns the price of the security.