{"id":6755,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/taux-int-equiv\/"},"modified":"2021-02-26T08:13:11","modified_gmt":"2021-02-26T08:13:11","slug":"rri","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/rri\/","title":{"rendered":"TAUX.INT.EQUIV"},"content":{"rendered":"

La fonction TAUX.INT.EQUIV, connue en anglais sous le nom de RRI, est primordiale dans le secteur financier, notamment pour calculer le taux de rendement \u00e9quivalent annuel sur des investissements affichant une croissance exponentielle sur une p\u00e9riode d\u00e9finie. Elle s’av\u00e8re particuli\u00e8rement pr\u00e9cieuse pour l’analyse de la rentabilit\u00e9 de divers placements.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction TAUX.INT.EQUIV :<\/p>\n

=TAUX.INT.EQUIV(nper; va; vc)<\/code><\/pre>\n
    \n
  • nper<\/strong> : le nombre total de p\u00e9riodes d’investissement.<\/li>\n
  • va<\/strong> : la valeur actuelle ou le montant investi initialement.<\/li>\n
  • vc<\/strong> : la valeur future ou montant estim\u00e9 \u00e0 la fin des p\u00e9riodes nper<\/em>.<\/li>\n<\/ul>\n
    Exemple :<\/p>\n
    =TAUX.INT.EQUIV(5; 1000; 1610.51)<\/code><\/pre>\n
    Cet exemple calcule le taux de rendement annuel pour un investissement initial de 1000 unit\u00e9s qui atteint une valeur de 1610.51 apr\u00e8s 5 ans.<\/p>\n
    Exemples pratiques d’utilisation<\/h2>\n
    (1) Estimation du taux de rendement annuel d’un plan de retraite :<\/p>\n\n\n\n
    Ann\u00e9e<\/th>\nValeur initiale (\u20ac)<\/th>\nValeur finale (\u20ac)<\/th>\nR\u00e9sultat attendu<\/th>\n<\/tr>\n
    10<\/td>\n15,000<\/td>\n24,450<\/td>\n=TAUX.INT.EQUIV(10; 15000; 24450)<\/code><\/td>\n<\/tr>\n<\/table>\n
    Cet exemple aide une personne \u00e0 \u00e9valuer la performance d’un plan de retraite sur dix ans, permettant ainsi de v\u00e9rifier si les objectifs financiers sont atteints.<\/p>\n
    (2) \u00c9valuation de diff\u00e9rents produits d’investissement :<\/p>\n
      \n
    • Un investisseur d\u00e9cide de comparer les performances de trois fonds mutuels sur une p\u00e9riode de cinq ans :<\/li>\n<\/ul>\n
      =TAUX.INT.EQUIV(5; 5000; 7500) \/\/ Fond A =TAUX.INT.EQUIV(5; 5000; 7000) \/\/ Fond B =TAUX.INT.EQUIV(5; 5000; 6500) \/\/ Fond C<\/code><\/pre>\n
      Cette m\u00e9thode lui permet d’analyser et de comparer directement le rendement potentiel des diff\u00e9rents fonds sur une m\u00eame dur\u00e9e, en se basant uniquement sur l’investissement initial et la valeur finale.<\/p>\n
      En r\u00e9sum\u00e9, la fonction TAUX.INT.EQUIV est un outil indispensable pour tout investisseur d\u00e9sireux de d\u00e9terminer le taux de croissance annuel compos\u00e9 d’un placement. Elle offre une base solide pour prendre des d\u00e9cisions \u00e9clair\u00e9es gr\u00e2ce \u00e0 des estimations pr\u00e9cises et objectives.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie un taux d\u2019int\u00e9r\u00eat \u00e9quivalent pour la croissance d\u2019un investissement<\/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-6755","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction RRI (TAUX.INT.EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) 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\/rri\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RRI (TAUX.INT.EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rri\/\" \/>\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:13:11+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction RRI (TAUX.INT.EQUIV) 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\/rri\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rri\/\",\"name\":\"Fonction RRI (TAUX.INT.EQUIV) 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:13:11+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rri\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rri\/#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.INT.EQUIV\"}]},{\"@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 RRI (TAUX.INT.EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) 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\/rri\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RRI (TAUX.INT.EQUIV) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rri\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:11+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction RRI (TAUX.INT.EQUIV) 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\/rri\/","url":"https:\/\/functiontranslator.com\/fr\/rri\/","name":"Fonction RRI (TAUX.INT.EQUIV) 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:13:11+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction RRI (TAUX.INT.EQUIV) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rri\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rri\/#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.INT.EQUIV"}]},{"@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\/6755","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=6755"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6755\/revisions"}],"predecessor-version":[{"id":29766,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6755\/revisions\/29766"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}