{"id":6702,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/rend-pcoupon-irreg\/"},"modified":"2021-02-26T08:11:26","modified_gmt":"2021-02-26T08:11:26","slug":"oddfyield","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/oddfyield\/","title":{"rendered":"REND.PCOUPON.IRREG"},"content":{"rendered":"

Cet article examine la fonction REND.PCOUPON.IRREG dans Microsoft Excel et son \u00e9quivalent, ODDFYIELD, dans Google Sheets. Ces fonctions sont essentielles pour calculer le rendement d’obligations avec des p\u00e9riodes de coupon irr\u00e9guli\u00e8res, une comp\u00e9tence cl\u00e9 pour les professionnels de la finance qui g\u00e8rent des obligations n’adh\u00e9rant pas \u00e0 des calendriers de paiement standard.<\/p>\n

Syntaxe et Explications<\/h2>\n

Voici la syntaxe pour utiliser la fonction dans Excel :<\/p>\n

REND.PCOUPON.IRREG(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])<\/code><\/pre>\n
Et pour Google Sheets :<\/p>\n
ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])<\/code><\/pre>\n
    \n
  • settlement<\/strong> : la date \u00e0 laquelle l’obligation est effectivement achet\u00e9e.<\/li>\n
  • maturity<\/strong> : la date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance.<\/li>\n
  • issue<\/strong> : la date de lancement de l’obligation.<\/li>\n
  • first_coupon<\/strong> : la date de paiement du premier coupon.<\/li>\n
  • rate<\/strong> : le taux annuel du coupon.<\/li>\n
  • pr<\/strong> : le prix actuel de l’obligation sur le march\u00e9.<\/li>\n
  • redemption<\/strong> : le montant qui sera rembours\u00e9 \u00e0 l’\u00e9ch\u00e9ance.<\/li>\n
  • frequency<\/strong> : la fr\u00e9quence des paiements de coupon (annuelle, semi-annuelle, ou trimestrielle).<\/li>\n
  • [basis]<\/strong> : (facultatif) le syst\u00e8me de calcul des jours utilis\u00e9 pour le calcul (par exemple, 30\/360).<\/li>\n<\/ul>\n
    Exemples Pratiques<\/h2>\n
    Exemple 1 : Calcul du rendement pour une obligation avec une premi\u00e8re p\u00e9riode de coupon courte<\/strong><\/p>\n
    Consid\u00e9rons une obligation \u00e9mise le 01-01-2020, avec un premier coupon pay\u00e9 le 01-07-2020, et une \u00e9ch\u00e9ance fix\u00e9e au 01-01-2030. Le taux du coupon est de 5%, la valeur \u00e0 rembourser est de 1000\u20ac, et le prix actuel est de 950\u20ac. Les coupons sont pay\u00e9s annuellement.<\/p>\n
    =REND.PCOUPON.IRREG(\"01-07-2020\", \"01-01-2030\", \"01-01-2020\", \"01-07-2020\", 5%, 950, 1000, 1)<\/code><\/pre>\n
    Cette formule calcule le rendement de l’obligation en consid\u00e9rant que la premi\u00e8re p\u00e9riode du coupon est plus courte que les p\u00e9riodes normales qui suivent.<\/p>\n
    Exemple 2 : Impact de diff\u00e9rents syst\u00e8mes de calcul des jours<\/strong><\/p>\n
    En reprenant les donn\u00e9es du premier exemple, changeons la base de calcul des jours \u00e0 30\/360 pour \u00e9valuer son impact :<\/p>\n
    =REND.PCOUPON.IRREG(\"01-07-2020\", \"01-01-2030\", \"01-01-2020\", \"01-07-2020\", 5%, 950, 1000, 1, 0)<\/code><\/pre>\n
    Changer la base affecte le calcul du rendement en modifiant le d\u00e9compte des jours entre les dates, ce qui peut influencer la p\u00e9riode r\u00e9elle de d\u00e9tention factur\u00e9e.<\/p>\n
    En conclusion, REND.PCOUPON.IRREG dans Excel et ODDFYIELD dans Google Sheets sont des fonctions tr\u00e8s utiles pour le calcul du rendement des obligations avec des paiements de coupons non standardis\u00e9s, rendant ces outils pr\u00e9cieux pour les analystes financiers qui g\u00e8rent des portefeuilles d’obligations complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le taux de Rendement d\u2019un titRe dont la pRemi\u00e8Re p\u00e9Riode de coupon est iRR\u00e9guli\u00e8Re<\/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-6702","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction ODDFYIELD (REND.PCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) 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\/oddfyield\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ODDFYIELD (REND.PCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/oddfyield\/\" \/>\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:11:26+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ODDFYIELD (REND.PCOUPON.IRREG) 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\/oddfyield\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/oddfyield\/\",\"name\":\"Fonction ODDFYIELD (REND.PCOUPON.IRREG) 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:11:26+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/oddfyield\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/oddfyield\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/oddfyield\/#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\":\"REND.PCOUPON.IRREG\"}]},{\"@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 ODDFYIELD (REND.PCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) 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\/oddfyield\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ODDFYIELD (REND.PCOUPON.IRREG) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/oddfyield\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:11:26+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ODDFYIELD (REND.PCOUPON.IRREG) 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\/oddfyield\/","url":"https:\/\/functiontranslator.com\/fr\/oddfyield\/","name":"Fonction ODDFYIELD (REND.PCOUPON.IRREG) 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:11:26+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ODDFYIELD (REND.PCOUPON.IRREG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/oddfyield\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/oddfyield\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/oddfyield\/#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":"REND.PCOUPON.IRREG"}]},{"@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\/6702","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=6702"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6702\/revisions"}],"predecessor-version":[{"id":29713,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6702\/revisions\/29713"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6702"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6702"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6702"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}