{"id":6726,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/valeur-encaissement\/"},"modified":"2021-02-26T08:12:14","modified_gmt":"2021-02-26T08:12:14","slug":"pricedisc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/pricedisc\/","title":{"rendered":"VALEUR.ENCAISSEMENT"},"content":{"rendered":"

La fonction PRICEDISC<\/code> de MS Excel, appel\u00e9e VALEUR.ENCAISSEMENT<\/code> dans Google Sheets, est con\u00e7ue pour calculer le prix d’une obligation en prenant en compte un escompte sur sa valeur nominale. Cette fonction est tr\u00e8s pris\u00e9e dans le secteur de la finance, notamment chez les professionnels g\u00e9rant des obligations et autres instruments \u00e0 revenu fixe.<\/p>\n

Description et Syntaxe<\/h2>\n

La fonction PRICEDISC<\/code> permet de calculer le prix d’une obligation en consid\u00e9rant sa valeur nominale, l’escompte appliqu\u00e9 et le d\u00e9lai jusqu’\u00e0 l’\u00e9ch\u00e9ance. Les syntaxes pour Excel et Google Sheets sont l\u00e9g\u00e8rement diff\u00e9rentes mais suivent un principe similaire :<\/p>\n

Excel :<\/b><\/p>\n

PRICEDISC(settlement, maturity, discount, redemption, [basis])<\/code><\/pre>\n
Google Sheets :<\/b><\/p>\n
VALEUR.ENCAISSEMENT(date_emission, date_echeance, remise, valeur_nominale, [base])<\/code><\/pre>\n
    \n
  • settlement\/date_emission<\/b>: La date d’achat de l’obligation.<\/li>\n
  • maturity\/date_echeance<\/b>: La date \u00e0 laquelle l’obligation arrive \u00e0 \u00e9ch\u00e9ance et le principal est rembours\u00e9.<\/li>\n
  • discount\/remise<\/b>: Le taux de remise accord\u00e9 sur l’obligation.<\/li>\n
  • redemption\/valeur_nominale<\/b>: La valeur nominale de l’obligation.<\/li>\n
  • [basis]\/[base]<\/b>: Un param\u00e8tre optionnel qui d\u00e9finit la convention de comptage des jours. La m\u00e9thode par d\u00e9faut est 30\/360.<\/li>\n<\/ul>\n
    Exemples d’application<\/h2>\n
    Voici des exemples concrets d’utilisation de la fonction PRICEDISC<\/code>.<\/p>\n
    Calcul du prix d’une obligation avec remise<\/h2>\n
    Imaginons que vous souhaitez d\u00e9terminer le prix d’une obligation que vous envisagez d’acheter aujourd’hui, avec une \u00e9ch\u00e9ance fix\u00e9e \u00e0 un an, une remise de 5 % et une valeur nominale de 1000 \u20ac.<\/p>\n
    =PRICEDISC(\"2023-12-01\", \"2024-12-01\", 0.05, 1000, 0)<\/code><\/pre>\n
    Cette formule calcule le prix d’achat actuel de l’obligation avec une remise de 5% appliqu\u00e9e.<\/p>\n
    \u00c9valuation de plusieurs obligations<\/h2>\n
    Pour un gestionnaire de portefeuille qui a besoin d’\u00e9valuer de multiples obligations, PRICEDISC<\/code> peut \u00eatre int\u00e9gr\u00e9e dans un tableur Excel ou Google Sheets pour d\u00e9terminer efficacement les prix d’achat pour chaque titre du portefeuille.<\/p>\n
     
     
     Date d'\u00e9mission<\/th> Date d'\u00e9ch\u00e9ance<\/th> Remise<\/th> Valeur Nominale<\/th> Prix d'Achat<\/th> <\/tr> 
     2023-12-01<\/td> 2024-12-01<\/td> 0.04<\/td> 10000<\/td> =PRICEDISC(A2, B2, C2, D2, 0)<\/code><\/td> <\/tr>  <\/table> <\/pre>\n
    Ce tableau facilite le calcul et la visualisation rapide du prix de chaque obligation, en fonction de ses caract\u00e9ristiques sp\u00e9cifiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la valeuR d\u2019encaissement d\u2019un escompte commeRcial, pouR une 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-6726","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction PRICEDISC (VALEUR.ENCAISSEMENT) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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\/pricedisc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/pricedisc\/\" \/>\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:12:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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\/pricedisc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/pricedisc\/\",\"name\":\"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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:12:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/pricedisc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/pricedisc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/pricedisc\/#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\":\"VALEUR.ENCAISSEMENT\"}]},{\"@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 PRICEDISC (VALEUR.ENCAISSEMENT) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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\/pricedisc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/pricedisc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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\/pricedisc\/","url":"https:\/\/functiontranslator.com\/fr\/pricedisc\/","name":"Fonction PRICEDISC (VALEUR.ENCAISSEMENT) 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:12:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction PRICEDISC (VALEUR.ENCAISSEMENT) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/pricedisc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/pricedisc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/pricedisc\/#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":"VALEUR.ENCAISSEMENT"}]},{"@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\/6726","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=6726"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6726\/revisions"}],"predecessor-version":[{"id":29737,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6726\/revisions\/29737"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}