{"id":6855,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rendement-titre-echeance\/"},"modified":"2021-02-26T08:16:41","modified_gmt":"2021-02-26T08:16:41","slug":"yieldmat","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/yieldmat\/","title":{"rendered":"RENDEMENT.TITRE.ECHEANCE"},"content":{"rendered":"

La fonction RENDEMENT.TITRE.ECHEANCE dans Excel et son \u00e9quivalent dans Google Sheets sont utilis\u00e9s pour d\u00e9terminer le rendement d’une obligation en fonction de sa valeur \u00e0 l’\u00e9ch\u00e9ance. Cette fonction est essentielle pour les professionnels de la finance qui analysent les investissements en obligations.<\/p>\n

Description de la Syntaxe<\/h2>\n

La syntaxe de la fonction RENDEMENT.TITRE.ECHEANCE est la suivante :<\/p>\n

RENDEMENT.TITRE.ECHEANCE(date_\u00e9mission, date_\u00e9ch\u00e9ance, taux, prix, valeur_nominale, base)<\/code><\/pre>\n
    \n
  • date_\u00e9mission<\/b> : La date \u00e0 laquelle l’obligation a \u00e9t\u00e9 \u00e9mise.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/b> : La date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • taux<\/b> : Le taux d’int\u00e9r\u00eat annuel de l’obligation.<\/li>\n
  • prix<\/b> : Le prix actuel de l’obligation sur le march\u00e9.<\/li>\n
  • valeur_nominale<\/b> : La valeur nominale ou le montant principal de l’obligation.<\/li>\n
  • base<\/b> : La convention de comptage des jours utilis\u00e9e pour le calcul.<\/li>\n<\/ul>\n
    Les diff\u00e9rentes valeurs possibles pour base<\/b> sont :<\/p>\n
      \n
    • 0 ou non sp\u00e9cifi\u00e9 – US (NASD) 30\/360<\/li>\n
    • 1 – R\u00e9el\/R\u00e9el<\/li>\n
    • 2 – R\u00e9el\/360<\/li>\n
    • 3 – R\u00e9el\/365<\/li>\n
    • 4 – Europ\u00e9en 30\/360<\/li>\n<\/ul>\n
      Exemples Pratiques<\/h2>\n
      Voici des exemples concrets d’utilisation de cette fonction.<\/p>\n
      \u00c9valuation du rendement d’une obligation<\/h2>\n
      Consid\u00e9rons une obligation \u00e9mise le 01\/01\/2020, avec une date d’\u00e9ch\u00e9ance le 01\/01\/2025, un taux annuel de 5%, achet\u00e9e \u00e0 950\u20ac avec une valeur nominale de 1000\u20ac. Pour calculer son rendement selon la convention US (NASD) 30\/360 :<\/p>\n
      =RENDEMENT.TITRE.ECHEANCE(\"2020-01-01\", \"2025-01-01\", 5%, 950, 1000, 0)<\/code><\/pre>\n
      Ce calcul permet d’\u00e9valuer le rendement de l’obligation, facilitant la comparaison avec d’autres opportunit\u00e9s d’investissement.<\/p>\n
      Comparaison de deux obligations<\/h2>\n
      Imaginons que vous h\u00e9sitez entre deux obligations diff\u00e9rentes. La premi\u00e8re a les m\u00eames caract\u00e9ristiques que celle dans l’exemple pr\u00e9c\u00e9dent. La deuxi\u00e8me, \u00e9mise le m\u00eame jour et avec la m\u00eame date d’\u00e9ch\u00e9ance, offre un taux annuel de 4.5% et est achet\u00e9e pour 900\u20ac avec une valeur nominale de 1000\u20ac.<\/p>\n\n\n\n\n
      Obligation<\/th>\nFormule<\/th>\nRENDEMENT.TITRE.ECHEANCE<\/th>\n<\/tr>\n
      Obligation 1<\/td>\n=RENDEMENT.TITRE.ECHEANCE(\"2020-01-01\", \"2025-01-01\", 5%, 950, 1000, 0)<\/code><\/td>\nCalcul\u00e9<\/td>\n<\/tr>\n
      Obligation 2<\/td>\n=RENDEMENT.TITRE.ECHEANCE(\"2020-01-01\", \"2025-01-01\", 4.5%, 900, 1000, 0)<\/code><\/td>\nCalcul\u00e9<\/td>\n<\/tr>\n<\/table>\n
      En calculant le rendement de chaque obligation, vous pouvez d\u00e9terminer laquelle offre le meilleur retour sur investissement.<\/p>\n
      L’emploi de ces calculs permet aux investisseurs et aux analystes financiers de prendre des d\u00e9cisions \u00e9clair\u00e9es bas\u00e9es sur des analyses quantitatives rigoureuses. Ainsi, la fonction RENDEMENT.TITRE.ECHEANCE est un outil invalorable pour quiconque \u0153uvre dans le secteur financier ou s’int\u00e9resse \u00e0 la gestion de ses investissements.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le Rendement annuel d\u2019un titRe qui RappoRte des int\u00e9R\u00eats \u00e0 l\u2019\u00e9ch\u00e9ance<\/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-6855","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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\/yieldmat\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/yieldmat\/\" \/>\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:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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\/yieldmat\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/yieldmat\/\",\"name\":\"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/yieldmat\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/yieldmat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/yieldmat\/#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.TITRE.ECHEANCE\"}]},{\"@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 YIELDMAT (RENDEMENT.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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\/yieldmat\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/yieldmat\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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\/yieldmat\/","url":"https:\/\/functiontranslator.com\/fr\/yieldmat\/","name":"Fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) 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:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction YIELDMAT (RENDEMENT.TITRE.ECHEANCE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/yieldmat\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/yieldmat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/yieldmat\/#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.TITRE.ECHEANCE"}]},{"@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\/6855","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=6855"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6855\/revisions"}],"predecessor-version":[{"id":29864,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6855\/revisions\/29864"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}