{"id":6378,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/interet-acc-mat\/"},"modified":"2021-02-26T08:01:34","modified_gmt":"2021-02-26T08:01:34","slug":"accrintm","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/accrintm\/","title":{"rendered":"INTERET.ACC.MAT"},"content":{"rendered":"

Description G\u00e9n\u00e9rale<\/h2>\n

La fonction ACCRINTM<\/strong> de Microsoft Excel et Google Sheets, connue sous le nom INTERET.ACC.MAT<\/strong> en fran\u00e7ais, est con\u00e7ue pour calculer les int\u00e9r\u00eats courus sur un instrument financier de la date d’\u00e9mission \u00e0 la date d’\u00e9ch\u00e9ance. Cette fonction s’av\u00e8re particuli\u00e8rement utile dans le domaine de la gestion financi\u00e8re pour \u00e9valuer les int\u00e9r\u00eats des obligations et autres formes de cr\u00e9ances.<\/p>\n

Syntaxe<\/h2>\n

Voici la syntaxe de la fonction INTERET.ACC.MAT<\/code> :<\/p>\n

=INTERET.ACC.MAT(date_\u00e9m; date_\u00e9ch\u00e9ance; taux; valeur_nominale; [base])<\/code><\/pre>\n
    \n
  • date_\u00e9m<\/strong> : La date \u00e0 laquelle le titre a \u00e9t\u00e9 \u00e9mis.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/strong> : La date \u00e0 laquelle le titre arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • taux<\/strong> : Le taux d’int\u00e9r\u00eat annuel de l’obligation.<\/li>\n
  • valeur_nominale<\/strong> : La valeur nominale de l’obligation.<\/li>\n
  • base<\/strong> (optionnel) : Le syst\u00e8me de comptage des jours utilis\u00e9 pour le calcul des int\u00e9r\u00eats. Si non sp\u00e9cifi\u00e9, la m\u00e9thode 30\/360 est utilis\u00e9e par d\u00e9faut dans Excel et Google Sheets.<\/li>\n<\/ul>\n
    Exemples Concrets<\/h2>\n\n\n\n
    Formule<\/th>\nDescription<\/th>\nR\u00e9sultat<\/th>\n<\/tr>\n
    =INTERET.ACC.MAT(\"01\/01\/2022\"; \"31\/12\/2022\"; 0.05; 1000)<\/code><\/td>\nCalcule les int\u00e9r\u00eats courus d’une obligation \u00e9mise le 1er janvier 2022, avec une date d’\u00e9ch\u00e9ance le 31 d\u00e9cembre 2022, un taux d’int\u00e9r\u00eat de 5% et une valeur nominale de 1000 euros.<\/td>\n50 euros<\/td>\n<\/tr>\n<\/table>\n
    Applications Pratiques<\/h2>\n
    La fonction INTERET.ACC.MAT<\/strong> est fr\u00e9quemment utilis\u00e9e pour :<\/p>\n
      \n
    • Calculer les int\u00e9r\u00eats courus sur les obligations avant leur maturit\u00e9.<\/li>\n
    • Estimer les co\u00fbts d’int\u00e9r\u00eats pour des rapports financiers ou des contr\u00f4les d’audit.<\/li>\n<\/ul>\n
      Probl\u00e8mes R\u00e9solus<\/h2>\n
      Imaginez que vous \u00eates gestionnaire de portefeuille et avez besoin de d\u00e9terminer les int\u00e9r\u00eats courus sur plusieurs obligations d\u00e9tenues par votre entreprise.<\/p>\n
      Probl\u00e8me 1<\/h2>\n
      Consid\u00e9rons une obligation avec les caract\u00e9ristiques suivantes :<\/p>\n
        \n
      • Date d’\u00e9mission : 01\/06\/2022<\/li>\n
      • Date d’\u00e9ch\u00e9ance : 01\/06\/2023<\/li>\n
      • Taux d’int\u00e9r\u00eat : 4%<\/li>\n
      • Valeur nominale : 2000\u20ac<\/li>\n<\/ul>\n
        La formule pour calculer les int\u00e9r\u00eats courus serait :<\/p>\n
        =INTERET.ACC.MAT(\"01\/06\/2022\"; \"01\/06\/2023\"; 0.04; 2000)<\/code><\/pre>\n
        Ceci donnerait un montant de 80\u20ac pour les int\u00e9r\u00eats courus sur un an \u00e0 un taux de 4% pour une obligation de 2000\u20ac.<\/p>\n
        Probl\u00e8me 2<\/h2>\n
        Calculons maintenant les int\u00e9r\u00eats courus pour une autre obligation poss\u00e9dant les caract\u00e9ristiques suivantes :<\/p>\n
          \n
        • Date d’\u00e9mission : 01\/04\/2022<\/li>\n
        • Date d’\u00e9ch\u00e9ance : 01\/10\/2023<\/li>\n
        • Taux d’int\u00e9r\u00eat : 3.5%<\/li>\n
        • Valeur nominale : 5000\u20ac<\/li>\n<\/ul>\n
          La formule \u00e0 utiliser serait :<\/p>\n
          =INTERET.ACC.MAT(\"01\/04\/2022\"; \"01\/10\/2023\"; 0.035; 5000)<\/code><\/pre>\n
          Le r\u00e9sultat indiquerait des int\u00e9r\u00eats courus de 175\u20ac, calcul\u00e9s \u00e0 un taux de 3.5% sur un montant de 5000\u20ac sur une p\u00e9riode d’environ un an et demi.<\/p>\n","protected":false},"excerpt":{"rendered":"
          Renvoie l\u2019int\u00e9R\u00eat couRu non \u00e9chu d\u2019un titRe dont l\u2019int\u00e9R\u00eat est peR\u00e7u \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-6378","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction ACCRINTM (INTERET.ACC.MAT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) 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\/accrintm\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ACCRINTM (INTERET.ACC.MAT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/accrintm\/\" \/>\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:01:34+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ACCRINTM (INTERET.ACC.MAT) 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\/accrintm\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/accrintm\/\",\"name\":\"Fonction ACCRINTM (INTERET.ACC.MAT) 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:01:34+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/accrintm\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/accrintm\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/accrintm\/#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\":\"INTERET.ACC.MAT\"}]},{\"@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 ACCRINTM (INTERET.ACC.MAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) 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\/accrintm\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ACCRINTM (INTERET.ACC.MAT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/accrintm\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:01:34+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ACCRINTM (INTERET.ACC.MAT) 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\/accrintm\/","url":"https:\/\/functiontranslator.com\/fr\/accrintm\/","name":"Fonction ACCRINTM (INTERET.ACC.MAT) 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:01:34+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ACCRINTM (INTERET.ACC.MAT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/accrintm\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/accrintm\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/accrintm\/#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":"INTERET.ACC.MAT"}]},{"@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\/6378","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=6378"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6378\/revisions"}],"predecessor-version":[{"id":29391,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6378\/revisions\/29391"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6378"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6378"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6378"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}