{"id":6468,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/date-coupon-prec\/"},"modified":"2021-02-26T08:03:51","modified_gmt":"2021-02-26T08:03:51","slug":"couppcd","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/couppcd\/","title":{"rendered":"DATE.COUPON.PREC"},"content":{"rendered":"

Description et syntaxe<\/h2>\n

La fonction COUPPCD<\/code> (DATE.COUPON.PREC) dans Excel et Google Sheets est une fonction financi\u00e8re qui permet de d\u00e9terminer la date de paiement du dernier coupon d\u2019un titre produisant des int\u00e9r\u00eats p\u00e9riodiques. Cette fonction est essentielle pour le calcul des paiements d\u2019int\u00e9r\u00eats pour des instruments financiers comme les obligations.<\/p>\n

Voici la syntaxe de la fonction dans Excel et Google Sheets :<\/p>\n

COUPPCD(date_\u00e9ch\u00e9ance, date_\u00e9mission, fr\u00e9quence, [base])<\/code><\/pre>\n
    \n
  • date_\u00e9ch\u00e9ance<\/strong> : Correspond \u00e0 la date d’expiration du titre.<\/li>\n
  • date_\u00e9mission<\/strong> : Indique la date \u00e0 laquelle le titre a \u00e9t\u00e9 \u00e9mis initialement.<\/li>\n
  • fr\u00e9quence<\/strong> : D\u00e9finit le nombre de paiements de coupon par an (annuel = 1, semi-annuel = 2, trimestriel = 4).<\/li>\n
  • base<\/strong> : (Facultatif) Sp\u00e9cifie la m\u00e9thode de comptage des jours utilis\u00e9e, par exemple 0 ou non sp\u00e9cifi\u00e9 pour le syst\u00e8me NASD (30\/360), 1 pour actual\/actual, etc.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Exemple 1 :<\/strong> Calcul de la date du dernier coupon pay\u00e9 pour une obligation \u00e9mise le 1er janvier 2020, arrivant \u00e0 \u00e9ch\u00e9ance le 1er janvier 2030, avec des paiements semestriels.<\/p>\n
    =COUPPCD(\"01\/01\/2030\", \"01\/01\/2020\", 2)<\/code><\/pre>\n
    Ce calcul d\u00e9termine la date du dernier coupon pay\u00e9 avant la date actuelle, \u00e0 condition que celle-ci soit post\u00e9rieure au 1er janvier 2020 et ant\u00e9rieure au 1er janvier 2030. Par exemple, si vous ex\u00e9cutez cette fonction le 15 ao\u00fbt 2023, le r\u00e9sultat serait \u00ab\u00a001\/07\/2023\u00a0\u00bb.<\/p>\n
    Exemple 2 :<\/strong> D\u00e9termination de la date du dernier paiement de coupon pour une obligation avec des paiements trimestriels.<\/p>\n
    =COUPPCD(\"01\/12\/2025\", \"01\/12\/2015\", 4)<\/code><\/pre>\n
    Dans ce sc\u00e9nario, l’obligation \u00e9met des coupons tous les trois mois depuis sa date d’\u00e9mission. Si ce calcul est effectu\u00e9 en mars 2023, il produira comme r\u00e9sultat \u00ab\u00a001\/12\/2022\u00a0\u00bb, soit la derni\u00e8re date \u00e0 laquelle un coupon a \u00e9t\u00e9 pay\u00e9 avant la date du calcul.<\/p>\n
    Applications pratiques<\/h2>\n
    L\u2019utilisation de la fonction COUPPCD<\/code> est extr\u00eamement b\u00e9n\u00e9fique dans plusieurs contextes financiers, comme :<\/p>\n
      \n
    • Analyse de portefeuille : Les investisseurs et gestionnaires de portefeuille peuvent se servir de cette fonction pour estimer les flux de tr\u00e9sorerie issus des paiements d\u2019int\u00e9r\u00eats sur les obligations.<\/li>\n
    • Planification fiscale : Elle aide les entreprises et les individus \u00e0 mieux pr\u00e9voir leurs engagements fiscaux en fonction des p\u00e9riodes de paiement des int\u00e9r\u00eats.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la date de coupon pR\u00e9c\u00e9dant la date de R\u00e8glement<\/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-6468","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction COUPPCD (DATE.COUPON.PREC) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) 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\/couppcd\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction COUPPCD (DATE.COUPON.PREC) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/couppcd\/\" \/>\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:03:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction COUPPCD (DATE.COUPON.PREC) 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\/couppcd\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/couppcd\/\",\"name\":\"Fonction COUPPCD (DATE.COUPON.PREC) 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:03:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/couppcd\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/couppcd\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/couppcd\/#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\":\"DATE.COUPON.PREC\"}]},{\"@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 COUPPCD (DATE.COUPON.PREC) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) 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\/couppcd\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction COUPPCD (DATE.COUPON.PREC) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/couppcd\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:03:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction COUPPCD (DATE.COUPON.PREC) 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\/couppcd\/","url":"https:\/\/functiontranslator.com\/fr\/couppcd\/","name":"Fonction COUPPCD (DATE.COUPON.PREC) 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:03:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction COUPPCD (DATE.COUPON.PREC) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/couppcd\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/couppcd\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/couppcd\/#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":"DATE.COUPON.PREC"}]},{"@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\/6468","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=6468"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6468\/revisions"}],"predecessor-version":[{"id":29480,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6468\/revisions\/29480"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}