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

La fonction PRIX.BON.TRESOR<\/code> est cruciale pour d\u00e9terminer le prix par tranche de 100\u20ac de valeur nominale d’un bon du Tr\u00e9sor am\u00e9ricain en fonction de la date d’\u00e9ch\u00e9ance, de la date de r\u00e8glement et du taux d’escompte. Elle est disponible \u00e0 la fois sous Microsoft Excel et Google Sheets, facilitant ainsi vos analyses financi\u00e8res avec pr\u00e9cision et efficacit\u00e9.<\/p>\n

Syntaxe et Utilisation<\/h2>\n

Voici la syntaxe de la fonction PRIX.BON.TRESOR<\/code> sous Excel et Google Sheets:<\/p>\n

 PRIX.BON.TRESOR(date_r\u00e8glement, date_\u00e9ch\u00e9ance, taux)<\/code> <\/pre>\n
    \n
  • date_r\u00e8glement<\/strong> : Date \u00e0 laquelle l\u2019achat du bon est r\u00e9alis\u00e9. Cette date doit pr\u00e9c\u00e9der la date d’\u00e9ch\u00e9ance.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/strong> : Date \u00e0 laquelle le bon du Tr\u00e9sor vient \u00e0 maturit\u00e9.<\/li>\n
  • taux<\/strong> : Taux d’escompte appliqu\u00e9 au bon.<\/li>\n<\/ul>\n
    Exemples Pratiques<\/h2>\n
    Prenons l’exemple d’un calcul du prix d’un bon du Tr\u00e9sor dont la date de r\u00e8glement est le 1er janvier 2023 et la date d’\u00e9ch\u00e9ance le 30 juin 2023, avec un taux d’escompte de 2,5%.<\/p>\n
     =PRIX.BON.TRESOR(\"1\/1\/2023\", \"30\/6\/2023\", 0.025)<\/code> <\/pre>\n
    Cette formule vous indiquera le prix du bon par tranche de 100 euros de valeur nominale, sur la base des param\u00e8tres fournis.<\/p>\n
    Sc\u00e9nario Pratique<\/h2>\n
    Scenario 1<\/strong> : Gestion de Tr\u00e9sorerie d’Entreprise<\/p>\n
    Une entreprise envisage d’investir dans des bons du Tr\u00e9sor pour optimiser sa gestion de tr\u00e9sorerie. Elle pr\u00e9voit d’acqu\u00e9rir des bons qui viendront \u00e0 \u00e9ch\u00e9ance dans 90 jours, avec un taux d’escompte de 2%, et souhaite conna\u00eetre le co\u00fbt par bon de 100\u20ac de valeur nominale.<\/p>\n
     =PRIX.BON.TRESOR(AUJOURDHUI(), DATE(ANNEE(AUJOURDHUI()), MOIS(AUJOURDHUI()) + 3, JOUR(AUJOURDHUI())), 0.02)<\/code> <\/pre>\n
    Cette \u00e9valuation aidera l’entreprise \u00e0 planifier efficacement ses investissements et ses mouvements de tr\u00e9sorerie sur les trois prochains mois.<\/p>\n
    Scenario 2<\/strong> : Comparaison d\u2019Options d\u2019Investissement<\/p>\n
    Un investisseur examine deux options d’investissement pour des bons, l’une avec un taux d’escompte de 1,5% et l’autre de 2,5%, chaque bond arrivant \u00e0 \u00e9ch\u00e9ance dans 180 jours. Il cherche \u00e0 d\u00e9terminer l’option la plus avantageuse en termes de co\u00fbt initial.<\/p>\n
     =PRIX.BON.TRESOR(AUJOURDHUI(), DATE(ANNEE(AUJOURDHUI()), MOIS(AUJOURDHUI()) + 6, JOUR(AUJOURDHUI())), 0.015) =PRIX.BON.TRESOR(AUJOURDHUI(), DATE(ANNEE(AUJOURDHUI()), MOIS(AUJOURDHUI()) + 6, JOUR(AUJOURDHUI())), 0.025)<\/code> <\/pre>\n
    En comparant les co\u00fbts d’achat g\u00e9n\u00e9r\u00e9s, l’investisseur peut prendre une d\u00e9cision \u00e9clair\u00e9e en se basant sur le co\u00fbt d’acquisition.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le pRix d\u2019un bon du TR\u00e9soR d\u2019une valeuR nominale de 100\u00a0euRos<\/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-6802","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction TBILLPRICE (PRIX.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.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\/tbillprice\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TBILLPRICE (PRIX.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.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\/tbillprice\/\" \/>\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:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction TBILLPRICE (PRIX.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\/tbillprice\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/tbillprice\/\",\"name\":\"Fonction TBILLPRICE (PRIX.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:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbillprice\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/tbillprice\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/tbillprice\/#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\":\"PRIX.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 TBILLPRICE (PRIX.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.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\/tbillprice\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TBILLPRICE (PRIX.BON.TRESOR) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/tbillprice\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:14:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TBILLPRICE (PRIX.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\/tbillprice\/","url":"https:\/\/functiontranslator.com\/fr\/tbillprice\/","name":"Fonction TBILLPRICE (PRIX.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:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TBILLPRICE (PRIX.BON.TRESOR) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/tbillprice\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/tbillprice\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/tbillprice\/#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":"PRIX.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\/6802","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=6802"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6802\/revisions"}],"predecessor-version":[{"id":29811,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6802\/revisions\/29811"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6802"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6802"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6802"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}