{"id":6846,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/tri-paiements\/"},"modified":"2021-02-26T08:16:25","modified_gmt":"2021-02-26T08:16:25","slug":"xirr","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/xirr\/","title":{"rendered":"TRI.PAIEMENTS"},"content":{"rendered":"

Description de la fonction<\/h2>\n

La fonction TRI.PAIEMENTS dans Excel (appel\u00e9e XIRR dans la version anglaise) calcule le taux de rentabilit\u00e9 interne (TRI) pour une s\u00e9rie de flux mon\u00e9taires irr\u00e9guliers sur des p\u00e9riodes vari\u00e9es. Cette fonction est essentielle pour l’analyse financi\u00e8re, permettant d’\u00e9valuer la performance d’investissements avec des entr\u00e9es et sorties de capitaux non p\u00e9riodiques.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction TRI.PAIEMENTS :<\/p>\n

=TRI.PAIEMENTS(valeurs; dates; [estimation])<\/code><\/pre>\n
    \n
  • valeurs<\/strong> : Un ensemble de nombres repr\u00e9sentant les flux de paiements et de recettes, o\u00f9 les paiements sont exprim\u00e9s par des nombres n\u00e9gatifs et les recettes par des nombres positifs.<\/li>\n
  • dates<\/strong> : Un ensemble de dates correspondant \u00e0 chaque flux financier indiqu\u00e9 dans vos valeurs. Chaque date doit co\u00efncider avec un paiement ou un encaissement sp\u00e9cifique.<\/li>\n
  • estimation<\/strong> (facultatif) : Un taux de rendement pr\u00e9visionnel. En absence de cette valeur, Excel utilise le taux par d\u00e9faut de 0,1 (10%).<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Exemple 1 : Calcul du TRI pour un projet d’investissement<\/h3>\n
    Consid\u00e9rons un investisseur avec les flux de tr\u00e9sorerie suivants :<\/p>\n
      \n
    • -10 000 \u20ac le 01\/01\/2021 (d\u00e9pense initiale),<\/li>\n
    • 3 000 \u20ac le 01\/07\/2021 (revenu),<\/li>\n
    • 5 000 \u20ac le 01\/12\/2021 (revenu),<\/li>\n
    • 2 000 \u20ac le 01\/07\/2022 (revenu).<\/li>\n<\/ul>\n
      Pour trouver le TRI de ces transactions, la formule dans Excel serait :<\/p>\n
      =TRI.PAIEMENTS({-10000; 3000; 5000; 2000}; {\"01\/01\/2021\"; \"01\/07\/2021\"; \"01\/12\/2021\"; \"01\/07\/2022\"})<\/code><\/pre>\n
      Ceci fournira le taux ajust\u00e9 de la rentabilit\u00e9 interne en prenant en compte l’irr\u00e9gularit\u00e9 des flux de paiements.<\/p>\n
      Exemple 2 : \u00c9valuation d’une s\u00e9rie de pr\u00eats<\/h3>\n
      Imaginons une entreprise ayant contract\u00e9 diff\u00e9rents pr\u00eats, souhaitant calculer le TRI global bas\u00e9 sur des dates r\u00e9elles de remboursement et des montants respectifs :<\/p>\n\n\n\n\n\n\n
      Date<\/th>\nMontant (\u20ac)<\/th>\n<\/tr>\n
      10\/03\/2021<\/td>\n-5000<\/td>\n<\/tr>\n
      15\/09\/2021<\/td>\n2000<\/td>\n<\/tr>\n
      20\/12\/2021<\/td>\n1500<\/td>\n<\/tr>\n
      30\/06\/2022<\/td>\n2000<\/td>\n<\/tr>\n<\/table>\n
      Pour calculer le TRI, utilisez la formule :<\/p>\n
      =TRI.PAIEMENTS({-5000; 2000; 1500; 2000}; {\"10\/03\/2021\"; \"15\/09\/2021\"; \"20\/12\/2021\"; \"30\/06\/2022\"})<\/code><\/pre>\n
      Cette formule permettra au responsable financier de d\u00e9terminer le co\u00fbt r\u00e9el des pr\u00eats sur la p\u00e9riode donn\u00e9e.<\/p>\n","protected":false},"excerpt":{"rendered":"
      CalCule le taux de rentabilit\u00e9 interne d\u2019un ensemble de paiements non p\u00e9riodiques<\/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-6846","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction XIRR (TRI.PAIEMENTS) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) 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\/xirr\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction XIRR (TRI.PAIEMENTS) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/xirr\/\" \/>\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:16:25+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction XIRR (TRI.PAIEMENTS) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/xirr\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/xirr\/\",\"name\":\"Fonction XIRR (TRI.PAIEMENTS) 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:16:25+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/xirr\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/xirr\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/xirr\/#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.PAIEMENTS\"}]},{\"@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 XIRR (TRI.PAIEMENTS) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) 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\/xirr\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction XIRR (TRI.PAIEMENTS) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/xirr\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:25+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction XIRR (TRI.PAIEMENTS) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/xirr\/","url":"https:\/\/functiontranslator.com\/fr\/xirr\/","name":"Fonction XIRR (TRI.PAIEMENTS) 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:16:25+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction XIRR (TRI.PAIEMENTS) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/xirr\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/xirr\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/xirr\/#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.PAIEMENTS"}]},{"@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\/6846","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=6846"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6846\/revisions"}],"predecessor-version":[{"id":29855,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6846\/revisions\/29855"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6846"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6846"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6846"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}