{"id":6620,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/tri\/"},"modified":"2021-02-26T08:08:46","modified_gmt":"2021-02-26T08:08:46","slug":"irr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/irr\/","title":{"rendered":"TRI"},"content":{"rendered":"<h2>D\u00e9finition et Syntaxe de la Fonction<\/h2>\n<p>La fonction <strong>IRR<\/strong> (Internal Rate of Return ou Taux de Rentabilit\u00e9 Interne, TRI) est utilis\u00e9e dans Excel et Google Sheets pour d\u00e9terminer le taux de rendement financier de s\u00e9ries de flux de tr\u00e9sorerie sur une p\u00e9riode donn\u00e9e. Elle est essentielle pour \u00e9valuer la profitabilit\u00e9 de projets d&rsquo;investissement.<\/p>\n<p><strong>Syntaxe :<\/strong><\/p>\n<pre><code>=IRR(values, [guess])<\/code><\/pre>\n<ul>\n<li><strong>values<\/strong> : une plage de cellules contenant les flux de tr\u00e9sorerie, o\u00f9 le premier montant est g\u00e9n\u00e9ralement n\u00e9gatif, repr\u00e9sentant un investissement initial.<\/li>\n<li><strong>[guess]<\/strong> : une estimation initiale du TRI, qui acc\u00e9l\u00e8re le processus de calcul. La valeur par d\u00e9faut est 0,1 (10 %).<\/li>\n<\/ul>\n<h2>Exemples d&rsquo;application<\/h2>\n<p>Voici des exemples pour illustrer l&rsquo;utilisation de la fonction IRR.<\/p>\n<h3>Exemple 1 : \u00c9valuation d&rsquo;un projet d&rsquo;investissement<\/h3>\n<p>Consid\u00e9rons une entreprise projetant un investissement initial de 100 000 \u20ac, avec des retours annuels estim\u00e9s pour les quatre ann\u00e9es suivantes \u00e0 30 000 \u20ac, 35 000 \u20ac, 40 000 \u20ac, et 45 000 \u20ac. Pour \u00e9valuer la viabilit\u00e9 financi\u00e8re de ce projet, on peut utiliser la fonction IRR.<\/p>\n<pre><code>Flux de tr\u00e9sorerie : -100000, 30000, 35000, 40000, 45000 Formule Excel : =IRR(A1:E1) Formule Google Sheets : =IRR(A1:E1) <\/code><\/pre>\n<p>Si le TRI calcul\u00e9 est sup\u00e9rieur au co\u00fbt du capital de l\u2019entreprise, le projet est consid\u00e9r\u00e9 comme rentable. Le r\u00e9sultat repr\u00e9sente le taux de retour annuel en fonction des flux pr\u00e9vus.<\/p>\n<h3>Exemple 2 : Comparaison de deux projets d&rsquo;investissement<\/h3>\n<p>Une entreprise a le choix entre deux projets d&rsquo;investissement avec les flux de tr\u00e9sorerie suivants :<\/p>\n<pre><code>Projet A : -50000, 20000, 20000, 15000 Projet B : -40000, 15000, 18000, 22000 <\/code><\/pre>\n<p>La fonction IRR permet de comparer les taux de rendement des deux projets pour choisir celui offrant le meilleur potentiel.<\/p>\n<pre><code>Formule pour le Projet A : =IRR(A1:D1) Formule pour le Projet B : =IRR(E1:H1) <\/code><\/pre>\n<p>Le projet avec le TRI le plus \u00e9lev\u00e9 est le plus attrayant financi\u00e8rement, dans des conditions \u00e9quivalentes.<\/p>\n<h2>Tableau r\u00e9capitulatif avec IRR<\/h2>\n<p>Voici un tableau des flux de tr\u00e9sorerie des deux projets et leur TRI calcul\u00e9 :<\/p>\n<table border=\"1\">\n<tr>\n<th>Projet<\/th>\n<th>Ann\u00e9e 0<\/th>\n<th>Ann\u00e9e 1<\/th>\n<th>Ann\u00e9e 2<\/th>\n<th>Ann\u00e9e 3<\/th>\n<th>TRI<\/th>\n<\/tr>\n<tr>\n<td>A<\/td>\n<td>-50000<\/td>\n<td>20000<\/td>\n<td>20000<\/td>\n<td>15000<\/td>\n<td>=IRR(A2:D2)<\/td>\n<\/tr>\n<tr>\n<td>B<\/td>\n<td>-40000<\/td>\n<td>15000<\/td>\n<td>18000<\/td>\n<td>22000<\/td>\n<td>=IRR(E2:H2)<\/td>\n<\/tr>\n<\/table>\n<p>En int\u00e9grant les formules IRR directement dans Excel ou Google Sheets, le calcul des TRI pour chaque projet est simplifi\u00e9, facilitant ainsi les d\u00e9cisions d&rsquo;investissement.<\/p>\n<p>La fonction IRR est extr\u00eamement pr\u00e9cieuse pour les analyses de rentabilit\u00e9 et les d\u00e9cisions de financement, en offrant un aper\u00e7u clair des rendements pr\u00e9vus bas\u00e9s sur les flux de tr\u00e9sorerie.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CalCule le taux de rentabilit\u00e9 interne d\u2019un investissement pour une suCCession de tr\u00e9soreries<\/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-6620","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Fonction IRR (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IRR (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;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\/irr\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IRR (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IRR (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d&#039;utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/irr\/\" \/>\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:46+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IRR (TRI) 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\/irr\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/irr\/\",\"name\":\"Fonction IRR (TRI) 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:46+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IRR (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/irr\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/irr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/irr\/#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\":\"TRI\"}]},{\"@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 IRR (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IRR (TRI) 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\/irr\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IRR (TRI) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IRR (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/irr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:46+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IRR (TRI) 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\/irr\/","url":"https:\/\/functiontranslator.com\/fr\/irr\/","name":"Fonction IRR (TRI) 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:46+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IRR (TRI) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/irr\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/irr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/irr\/#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":"TRI"}]},{"@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\/6620","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=6620"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6620\/revisions"}],"predecessor-version":[{"id":29631,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6620\/revisions\/29631"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6620"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6620"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6620"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}