{"id":6801,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/taux-escompte-r\/"},"modified":"2021-02-26T08:14:54","modified_gmt":"2021-02-26T08:14:54","slug":"tbilleq","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/tbilleq\/","title":{"rendered":"TAUX.ESCOMPTE.R"},"content":{"rendered":"

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

La fonction TBILLEQ<\/code> (TAUX.ESCOMPTE.R) dans Excel et Google Sheets est utilis\u00e9e pour calculer le rendement \u00e9quivalent d’une obligation du Tr\u00e9sor \u00e0 escompte. Elle permet de comparer efficacement les rendements annuels de diff\u00e9rentes obligations du Tr\u00e9sor, ind\u00e9pendamment de leurs \u00e9ch\u00e9ances respectives.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe pour la fonction TBILLEQ<\/code> est la suivante :<\/p>\n

TBILLEQ(date_\u00e9ch\u00e9ance, date_\u00e9mission, taux)<\/code><\/pre>\n
    \n
  • date_\u00e9ch\u00e9ance<\/strong> : Date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance. Elle doit \u00eatre post\u00e9rieure \u00e0 la date d’\u00e9mission.<\/li>\n
  • date_\u00e9mission<\/strong> : Date de l’\u00e9mission de l’obligation.<\/li>\n
  • taux<\/strong> : Taux d’escompte appliqu\u00e9 \u00e0 l’obligation du Tr\u00e9sor.<\/li>\n<\/ul>\n
    Exemples de calcul<\/h2>\n
    Voici un exemple de calcul du rendement \u00e9quivalent pour une obligation.<\/p>\n
    =TBILLEQ(\"31\/12\/2023\", \"01\/01\/2023\", 0.05)<\/code><\/pre>\n
    Cette formule calcule le rendement \u00e9quivalent d’une obligation \u00e9mise le 1er janvier 2023 avec une \u00e9ch\u00e9ance le 31 d\u00e9cembre 2023 et un taux d\u2019escompte de 5%.<\/p>\n
    Applications pratiques<\/h2>\n
    La fonction TBILLEQ<\/code> est particuli\u00e8rement utile dans les sc\u00e9narios suivants :<\/p>\n
    Comparaison de diff\u00e9rentes obligations<\/h2>\n
    Imaginez que vous poss\u00e9dez plusieurs obligations du Tr\u00e9sor avec diff\u00e9rentes dates d’\u00e9ch\u00e9ance et taux d\u2019escompte, et que vous d\u00e9sirez \u00e9valuer leur rendement annuel \u00e9quivalent pour choisir le meilleur investissement.<\/p>\n\n\n\n\n
    Obligation<\/th>\nDate d’\u00e9mission<\/th>\nDate d’\u00e9ch\u00e9ance<\/th>\nTaux d’escompte<\/th>\nRendement \u00e9quivalent<\/th>\n<\/tr>\n
    Obligation A<\/td>\n01\/01\/2023<\/td>\n30\/06\/2023<\/td>\n0.04<\/td>\n=TBILLEQ(\u00ab\u00a030\/06\/2023\u00a0\u00bb, \u00ab\u00a001\/01\/2023\u00a0\u00bb, 0.04)<\/td>\n<\/tr>\n
    Obligation B<\/td>\n01\/01\/2023<\/td>\n31\/12\/2023<\/td>\n0.05<\/td>\n=TBILLEQ(\u00ab\u00a031\/12\/2023\u00a0\u00bb, \u00ab\u00a001\/01\/2023\u00a0\u00bb, 0.05)<\/td>\n<\/tr>\n<\/table>\n
    Cette fonction permet de d\u00e9terminer facilement et de comparer rapidement le rendement des obligations.<\/p>\n
    Optimisation du portefeuille d’investissement<\/h2>\n
    Pour un investisseur, optimiser le rendement est essentiel. Il est souvent n\u00e9cessaire de r\u00e9\u00e9valuer les obligations du Tr\u00e9sor dans votre portefeuille pour s’assurer qu’elles fournissent le meilleur rendement. L’usage de TBILLEQ<\/code> permet de mesurer le rendement actuel bas\u00e9 sur les taux d\u2019escompte actuels et d’effectuer des choix \u00e9clair\u00e9s concernant l’achat ou la vente d’obligations.<\/p>\n
    En r\u00e9\u00e9valuant p\u00e9riodiquement les rendements \u00e9quivalents des obligations et en les comparant \u00e0 d’autres opportunit\u00e9s, vous pouvez affiner strat\u00e9giquement vos choix d’investissement et maximiser leur potentiel de rendement.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le taux d\u2019escompte Rationnel d\u2019un bon du TR\u00e9soR<\/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-6801","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction TBILLEQ (TAUX.ESCOMPTE.R) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) 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\/tbilleq\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TBILLEQ (TAUX.ESCOMPTE.R) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/tbilleq\/\" \/>\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:14:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TBILLEQ (TAUX.ESCOMPTE.R) 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\/tbilleq\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/tbilleq\/\",\"name\":\"Fonction TBILLEQ (TAUX.ESCOMPTE.R) 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:14:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbilleq\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/tbilleq\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbilleq\/#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.ESCOMPTE.R\"}]},{\"@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 TBILLEQ (TAUX.ESCOMPTE.R) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) 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\/tbilleq\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TBILLEQ (TAUX.ESCOMPTE.R) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/tbilleq\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TBILLEQ (TAUX.ESCOMPTE.R) 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\/tbilleq\/","url":"https:\/\/functiontranslator.com\/fr\/tbilleq\/","name":"Fonction TBILLEQ (TAUX.ESCOMPTE.R) 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:14:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TBILLEQ (TAUX.ESCOMPTE.R) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/tbilleq\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/tbilleq\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/tbilleq\/#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.ESCOMPTE.R"}]},{"@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\/6801","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=6801"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6801\/revisions"}],"predecessor-version":[{"id":29810,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6801\/revisions\/29810"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6801"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6801"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6801"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}