PRICEMAT()
Syntax. PRICEMAT(Settlement,Maturity,Issue,Rate,Yield,Basis)
Definition. This function returns the price (as a percentage, that is, based on a nominal value) of a security that has a simple interest yield in arrears (no compound interest).
Arguments
Settlement (required) The date when the ownership of the security changes.
Maturity (required) The maturity date of the security.
Issue (required) The date of the emission of the security.
Rate (required) The agreed-upon nominal interest rate of the security based on an entire year.
Yield (required) The current market interest rate or the expected yield of the security (as an interest rate based on an entire year).
Basis (optional) The method you want to use for determining the days in the year ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
