{"id":6854,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rendement-simple\/"},"modified":"2021-02-26T08:16:40","modified_gmt":"2021-02-26T08:16:40","slug":"yielddisc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/yielddisc\/","title":{"rendered":"RENDEMENT.SIMPLE"},"content":{"rendered":"

La fonction RENDEMENT.SIMPLE dans Microsoft Excel et Google Sheets est utilis\u00e9e pour calculer le rendement d’un titre qui est vendu avec un rabais sur son taux de remboursement. Ce calcul est particuli\u00e8rement pertinent pour les titres \u00e0 court terme, tels que les bons du Tr\u00e9sor, qui sont souvent \u00e9mis \u00e0 un prix inf\u00e9rieur \u00e0 leur valeur nominale. Le rendement ainsi calcul\u00e9 constitue un indicateur essentiel pour les investisseurs.<\/p>\n

Syntaxe de la fonction RENDEMENT.SIMPLE<\/h2>\n

La syntaxe pour utiliser la fonction RENDEMENT.SIMPLE est la suivante :<\/p>\n

=RENDEMENT.SIMPLE(date_liq, date_\u00e9ch\u00e9ance, prix, valeur_nominale, [base])<\/code><\/pre>\n
Les param\u00e8tres requis sont :<\/p>\n
    \n
  • date_liq<\/strong> : la date de r\u00e8glement de l\u2019achat du titre.<\/li>\n
  • date_\u00e9ch\u00e9ance<\/strong> : la date \u00e0 laquelle le titre arrive \u00e0 maturit\u00e9.<\/li>\n
  • prix<\/strong> : le montant pay\u00e9 pour l’acquisition du titre.<\/li>\n
  • valeur_nominale<\/strong> : la valeur faciale du titre \u00e0 l’\u00e9ch\u00e9ance.<\/li>\n
  • base<\/strong> : (optionnel) le syst\u00e8me de d\u00e9compte des jours utilis\u00e9 pour le calcul. Si ce param\u00e8tre est omis, la base 0 (30\/360) est utilis\u00e9e par d\u00e9faut.<\/li>\n<\/ul>\n
    Exemples d\u2019utilisation<\/h2>\n
    Exemple 1: Calcul du rendement pour un bon du Tr\u00e9sor.<\/p>\n
    Supposons qu'un bon du Tr\u00e9sor est achet\u00e9 pour 980\u20ac avec une valeur nominale de 1000\u20ac et qu'il vient \u00e0 \u00e9ch\u00e9ance dans 90 jours. La date de r\u00e8glement est fix\u00e9e au 01\/01\/2023 et la date d'\u00e9ch\u00e9ance au 31\/03\/2023.<\/code><\/pre>\n
     =RENDEMENT.SIMPLE(\"01\/01\/2023\", \"31\/03\/2023\", 980, 1000)<\/code> <\/p>\n
    Le r\u00e9sultat fournira le taux de rendement annuel estim\u00e9, bas\u00e9 sur un syst\u00e8me de comptage des jours 30\/360.<\/p>\n
    Exemple 2: Utilisation d’un syst\u00e8me de d\u00e9compte des jours diff\u00e9rent.<\/p>\n
    En reprenant l'exemple pr\u00e9c\u00e9dent, si nous optons pour le syst\u00e8me actual\/actual pour le calcul, la formule deviendrait :<\/code><\/pre>\n
     =RENDEMENT.SIMPLE(\"01\/01\/2023\", \"31\/03\/2023\", 980, 1000, 4)<\/code> <\/p>\n
    Cette m\u00e9thode fournira \u00e9galement le taux de rendement annuel assur\u00e9, mais calcul\u00e9 selon le syst\u00e8me actual\/actual.<\/p>\n
    Applications pratiques<\/h2>\n
    En analyse d’investissement :<\/strong> Un analyste financier pourrait utiliser RENDEMENT.SIMPLE pour \u00e9valuer et comparer le rendement des diff\u00e9rents titres achet\u00e9s \u00e0 rabais, par rapport \u00e0 d’autres formes d’investissements.<\/p>\n
    Dans le cadre \u00e9ducatif :<\/strong> Les enseignants en finance peuvent employer cette fonction pour montrer aux \u00e9tudiants l’impact des taux d’int\u00e9r\u00eat sur le rendement des investissements et pour introduire des concepts fondamentaux de la finance.<\/p>\n
     This revised HTML content improves upon the original by clarifying the function’s description, enhancing the syntax explanation, and ensuring that the examples are clearly presented for both practical teaching and professional financial analysis.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule le taux de rendement d\u2019un emprunt \u00e0 int\u00e9r\u00eat simple (par exemple, un 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-6854","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction YIELDDISC (RENDEMENT.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) 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\/yielddisc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction YIELDDISC (RENDEMENT.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/yielddisc\/\" \/>\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:40+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction YIELDDISC (RENDEMENT.SIMPLE) 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\/yielddisc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/yielddisc\/\",\"name\":\"Fonction YIELDDISC (RENDEMENT.SIMPLE) 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:40+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/yielddisc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/yielddisc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/yielddisc\/#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.SIMPLE\"}]},{\"@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 YIELDDISC (RENDEMENT.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) 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\/yielddisc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction YIELDDISC (RENDEMENT.SIMPLE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/yielddisc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:16:40+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction YIELDDISC (RENDEMENT.SIMPLE) 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\/yielddisc\/","url":"https:\/\/functiontranslator.com\/fr\/yielddisc\/","name":"Fonction YIELDDISC (RENDEMENT.SIMPLE) 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:40+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction YIELDDISC (RENDEMENT.SIMPLE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/yielddisc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/yielddisc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/yielddisc\/#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.SIMPLE"}]},{"@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\/6854","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=6854"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6854\/revisions"}],"predecessor-version":[{"id":29863,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6854\/revisions\/29863"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}