{"id":6618,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/taux-interet\/"},"modified":"2021-02-26T08:08:44","modified_gmt":"2021-02-26T08:08:44","slug":"intrate","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/intrate\/","title":{"rendered":"TAUX.INTERET"},"content":{"rendered":"

La fonction TAUX.INTERET<\/strong> dans Microsoft Excel et Google Sheets est con\u00e7ue pour d\u00e9terminer le taux d’int\u00e9r\u00eat d’un investissement en se basant sur le prix courant, le prix nominal, et le nombre de jours restant jusqu’\u00e0 l’\u00e9ch\u00e9ance. Cette fonction s’av\u00e8re extr\u00eamement utile pour la gestion de portefeuilles financiers et l’analyse d’investissements.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

=TAUX.INTERET(date_\u00e9ch\u00e9ance, date_\u00e9mission, taux, prix, [base])<\/code><\/pre>\n
    \n
  • date_\u00e9ch\u00e9ance<\/strong> : La date \u00e0 laquelle l’investissement, tel qu’une obligation, atteint sa maturit\u00e9.<\/li>\n
  • date_\u00e9mission<\/strong> : La date de mise en circulation de l’investissement.<\/li>\n
  • taux<\/strong> : Le taux nominal annuel de l’investissement.<\/li>\n
  • prix<\/strong> : Le prix actuel de l’investissement.<\/li>\n
  • base<\/strong> (optionnel) : Le syst\u00e8me de comptage de jours utilis\u00e9 dans le calcul.<\/li>\n<\/ul>\n
    Les options pour le param\u00e8tre base<\/em> sont :<\/p>\n
      \n
    • 0 ou omis – Base am\u00e9ricaine (NASD), 30\/360<\/li>\n
    • 1 – R\u00e9el\/r\u00e9el<\/li>\n
    • 2 – R\u00e9el\/360<\/li>\n
    • 3 – R\u00e9el\/365<\/li>\n
    • 4 – Europ\u00e9en, 30\/360<\/li>\n<\/ul>\n
      Exemples concrets d’utilisation<\/h2>\n
      Illustrons l’utilisation de cette fonction \u00e0 travers des exemples pratiques.<\/p>\n
      Cas pratique 1 : Calcul du taux d’int\u00e9r\u00eat d’une obligation<\/h3>\n
      Imaginons que vous ayez achet\u00e9 une obligation \u00e9mise le 1er janvier 2023, qui arrive \u00e0 \u00e9ch\u00e9ance le 1er janvier 2024, avec un taux nominal annuel de 5%, et que le prix d’achat soit de 98. Voici comment calculer le taux d’int\u00e9r\u00eat effectif que vous obtiendrez :<\/p>\n
      =TAUX.INTERET(DATE(2024,1,1), DATE(2023,1,1), 0.05, 98)<\/code><\/pre>\n
      Cette formule d\u00e9terminera le taux d’int\u00e9r\u00eat en prenant en compte le taux nominal et le prix d’achat.<\/p>\n
      Cas pratique 2 : Impact du changement de base sur le calcul<\/h3>\n
      Reprenons le m\u00eame exemple mais modifions le syst\u00e8me de comptage des jours afin de voir quel effet cela a sur le taux d’int\u00e9r\u00eat calcul\u00e9 :<\/p>\n
      =TAUX.INTERET(DATE(2024,1,1), DATE(2023,1,1), 0.05, 98, 1)<\/code><\/pre>\n
      Ce calcul utilisera la base R\u00e9el\/r\u00e9el pour le comptage des jours, offrant ainsi une vue diff\u00e9rente sur la rentabilit\u00e9 de l’obligation.<\/p>\n
      Conclusion<\/h2>\n
      La fonction TAUX.INTERET<\/code> est essentielle pour les professionnels op\u00e9rant avec des investissements en obligations ou autres instruments financiers. Ma\u00eetriser les diff\u00e9rentes bases de comptage des jours est crucial pour affiner les calculs de rendement et optimiser la gestion des placements financiers.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Affiche le tAux d\u2019int\u00e9r\u00eat d\u2019un titre totAlement investi<\/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-6618","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction INTRATE (TAUX.INTERET) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) 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\/intrate\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction INTRATE (TAUX.INTERET) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/intrate\/\" \/>\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:08:44+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction INTRATE (TAUX.INTERET) 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\/intrate\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/intrate\/\",\"name\":\"Fonction INTRATE (TAUX.INTERET) 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:08:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/intrate\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/intrate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/intrate\/#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\":\"TAUX.INTERET\"}]},{\"@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 INTRATE (TAUX.INTERET) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) 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\/intrate\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction INTRATE (TAUX.INTERET) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/intrate\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction INTRATE (TAUX.INTERET) 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\/intrate\/","url":"https:\/\/functiontranslator.com\/fr\/intrate\/","name":"Fonction INTRATE (TAUX.INTERET) 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:08:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction INTRATE (TAUX.INTERET) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/intrate\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/intrate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/intrate\/#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":"TAUX.INTERET"}]},{"@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\/6618","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=6618"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6618\/revisions"}],"predecessor-version":[{"id":29629,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6618\/revisions\/29629"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}