{"id":6727,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/prix-titre-echeance\/"},"modified":"2021-02-26T08:12:17","modified_gmt":"2021-02-26T08:12:17","slug":"pricemat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/pricemat\/","title":{"rendered":"PRIX.TITRE.ECHEANCE"},"content":{"rendered":"

La fonction PRICEMAT<\/strong> ou PRIX.TITRE.ECHEANCE<\/strong> dans Excel et Google Sheets est con\u00e7ue pour calculer le prix d’un titre financier avec int\u00e9r\u00eats payables \u00e0 l’\u00e9ch\u00e9ance. Elle est essentielle pour les analyses financi\u00e8res visant \u00e0 d\u00e9terminer la valeur de march\u00e9 des obligations avant leur date de maturit\u00e9. Explorons en d\u00e9tail son m\u00e9canisme, sa syntaxe et des exemples d’application.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction PRICEMAT est la suivante :<\/p>\n

PRICEMAT(date_\u00e9mission, date_\u00e9ch\u00e9ance, taux, rendement, valeur_nominale)<\/code><\/pre>\n
    \n
  • date_\u00e9mission<\/strong> : Date d’\u00e9mission du titre.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/strong> : Date \u00e0 laquelle le titre arrive \u00e0 maturit\u00e9.<\/li>\n
  • taux<\/strong> : Taux d’int\u00e9r\u00eat annuel fixe du titre.<\/li>\n
  • rendement<\/strong> : Rendement requis jusqu’\u00e0 l’\u00e9ch\u00e9ance du titre.<\/li>\n
  • valeur_nominale<\/strong> : Montant qui sera rembours\u00e9 au d\u00e9tenteur du titre \u00e0 l’\u00e9ch\u00e9ance.<\/li>\n<\/ul>\n
    Cas d’utilisation pratiques<\/h2>\n
    Voici quelques exemples illustrant l’utilit\u00e9 de cette fonction :<\/p>\n
    Exemple 1 : Calcul du prix d’une obligation<\/h2>\n
    Consid\u00e9rons une obligation \u00e9mise le 1er janvier 2020, avec une \u00e9ch\u00e9ance au 1er janvier 2025, un taux d’int\u00e9r\u00eat de 5%, un rendement d\u00e9sir\u00e9 de 6%, et une valeur nominale de 1000 \u20ac. Pour calculer le prix de cette obligation, utilisez la formule suivante :<\/p>\n
    =PRICEMAT(\"2020-01-01\", \"2025-01-01\", 5%, 6%, 1000)<\/code><\/pre>\n
    Cette formule permet d’estimer le prix actuel du titre en tenant compte des int\u00e9r\u00eats accumul\u00e9s \u00e0 payer \u00e0 l’\u00e9ch\u00e9ance.<\/p>\n
    Exemple 2 : Comparaison de titres avec diff\u00e9rentes \u00e9ch\u00e9ances<\/h2>\n
    Un investisseur souhaite \u00e9valuer le prix de deux titres de maturit\u00e9s diff\u00e9rentes, avec le premier titre offrant un taux d’int\u00e9r\u00eat de 3% pour une \u00e9ch\u00e9ance au 1er janvier 2025 et le second, un taux de 4% pour une \u00e9ch\u00e9ance au 1er janvier 2030. Les deux titres visent un rendement de 3,5% et une valeur nominale de 1000 \u20ac.<\/p>\n
    Pour le premier titre, la commande sera :<\/p>\n
    =PRICEMAT(\"2022-01-01\", \"2025-01-01\", 3%, 3.5%, 1000)<\/code><\/pre>\n
    Pour le deuxi\u00e8me titre, utilisez :<\/p>\n
    =PRICEMAT(\"2022-01-01\", \"2030-01-01\", 4%, 3.5%, 1000)<\/code><\/pre>\n
    Ce calcul aidera l’investisseur \u00e0 identifier l’option la plus avantageuse en fonction du contexte actuel du march\u00e9.<\/p>\n
    Gr\u00e2ce \u00e0 la fonction PRICEMAT, les investisseurs et les analystes financiers peuvent \u00e9valuer efficacement la valeur des titres \u00e0 revenu fixe, facilitant ainsi des prises de d\u00e9cision inform\u00e9es sur la base de valeurs actuelles calcul\u00e9es.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le pRix d\u2019un titRe dont la valeuR nominale est 100\u00a0euRos et qui RappoRte des int\u00e9R\u00eats \u00e0 l\u2019\u00e9ch\u00e9ance<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[311],"tags":[],"class_list":["post-6727","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/pricemat\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/pricemat\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:12:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/pricemat\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/pricemat\/\",\"name\":\"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:12:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/pricemat\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/pricemat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/pricemat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Finances\",\"item\":\"https:\/\/functiontranslator.com\/fr\/finances\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PRIX.TITRE.ECHEANCE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/pricemat\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/pricemat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/pricemat\/","url":"https:\/\/functiontranslator.com\/fr\/pricemat\/","name":"Fonction PRICEMAT (PRIX.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:12:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PRICEMAT (PRIX.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/pricemat\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/pricemat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/pricemat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Finances","item":"https:\/\/functiontranslator.com\/fr\/finances\/"},{"@type":"ListItem","position":3,"name":"PRIX.TITRE.ECHEANCE"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6727","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6727"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6727\/revisions"}],"predecessor-version":[{"id":29738,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6727\/revisions\/29738"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6727"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6727"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}