{"id":6803,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rendement-bon-tresor\/"},"modified":"2021-02-26T08:14:59","modified_gmt":"2021-02-26T08:14:59","slug":"tbillyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/tbillyield\/","title":{"rendered":"RENDEMENT.BON.TRESOR"},"content":{"rendered":"

La fonction RENDEMENT.BON.TRESOR<\/strong> dans Excel et Google Sheets permet de calculer le rendement d’un bon du Tr\u00e9sor am\u00e9ricain en fonction de son prix par rapport \u00e0 sa valeur nominale. Elle est particuli\u00e8rement pr\u00e9cieuse pour les analystes financiers qui \u00e9valuent le rendement des instruments du march\u00e9 mon\u00e9taire.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe pour utiliser la fonction RENDEMENT.BON.TRESOR<\/code> est :<\/p>\n

RENDEMENT.BON.TRESOR(date_\u00e9ch\u00e9ance, date_r\u00e8glement, prix)<\/code><\/pre>\n
    \n
  • date_\u00e9ch\u00e9ance<\/strong> : Date \u00e0 laquelle le bon du Tr\u00e9sor arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • date_r\u00e8glement<\/strong> : Date d’acquisition du bon du Tr\u00e9sor.<\/li>\n
  • prix<\/strong> : Prix d’achat du bon du Tr\u00e9sor pour 100 \u20ac de valeur nominale.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Voici quelques situations pratiques o\u00f9 utiliser la fonction RENDEMENT.BON.TRESOR<\/code> :<\/p>\n
    Calcul du rendement d’un bon du Tr\u00e9sor<\/h2>\n
    Par exemple, pour un bon du Tr\u00e9sor achet\u00e9 le 1er janvier 2022, arrivant \u00e0 \u00e9ch\u00e9ance le 1er juillet 2022, et acquis \u00e0 98,5 \u20ac pour 100 \u20ac de valeur nominale, la formule serait :<\/p>\n
    =RENDEMENT.BON.TRESOR(\"2022-07-01\", \"2022-01-01\", 98.5)<\/code><\/pre>\n
    Cette formule retournera le rendement annuel de ce bon du Tr\u00e9sor, en tenant compte de sa date d’\u00e9ch\u00e9ance au 1er juillet 2022, de la date de r\u00e8glement au 1er janvier 2022, et du prix d’achat de 98,5.<\/p>\n
    Comparaison de rendements pour des d\u00e9cisions d’investissement<\/h2>\n
    Un investisseur h\u00e9sitant entre deux bons du Tr\u00e9sor peut utiliser RENDEMENT.BON.TRESOR<\/code> pour d\u00e9terminer celui qui offre le meilleur rendement. Consid\u00e9rons deux options : Bon A, achet\u00e9 \u00e0 97,6, arrivant \u00e0 \u00e9ch\u00e9ance le 1er juin 2022, et Bon B, achet\u00e9 \u00e0 99,2, arrivant \u00e0 \u00e9ch\u00e9ance le 1er ao\u00fbt 2022. Les deux options sont envisag\u00e9es pour un achat le 1er janvier 2022.<\/p>\n\n\n\n\n
    Bon<\/th>\nFormule<\/th>\nRendement<\/th>\n<\/tr>\n
    Bon A<\/td>\n=RENDEMENT.BON.TRESOR(\"2022-06-01\", \"2022-01-01\", 97.6)<\/code><\/td>\nCalcul\u00e9 avec la formule<\/td>\n<\/tr>\n
    Bon B<\/td>\n=RENDEMENT.BON.TRESOR(\"2022-08-01\", \"2022-01-01\", 99.2)<\/code><\/td>\nCalcul\u00e9 avec la formule<\/td>\n<\/tr>\n<\/table>\n
    Cet usage de RENDEMENT.BON.TRESOR<\/code> aide l’investisseur \u00e0 comparer directement les rendements des options disponibles et \u00e0 prendre la d\u00e9cision la plus avantageuse pour son portefeuille d’investissements.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule le taux de rendement 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-6803","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction TBILLYIELD (RENDEMENT.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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\/tbillyield\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/tbillyield\/\" \/>\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:59+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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\/tbillyield\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/tbillyield\/\",\"name\":\"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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:59+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbillyield\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/tbillyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbillyield\/#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\":\"RENDEMENT.BON.TRESOR\"}]},{\"@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 TBILLYIELD (RENDEMENT.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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\/tbillyield\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/tbillyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:59+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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\/tbillyield\/","url":"https:\/\/functiontranslator.com\/fr\/tbillyield\/","name":"Fonction TBILLYIELD (RENDEMENT.BON.TRESOR) 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:59+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TBILLYIELD (RENDEMENT.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/tbillyield\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/tbillyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/tbillyield\/#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":"RENDEMENT.BON.TRESOR"}]},{"@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\/6803","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=6803"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6803\/revisions"}],"predecessor-version":[{"id":29812,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6803\/revisions\/29812"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6803"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}