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

Description et Syntaxe<\/h2>\n

La fonction RECEIVED<\/code> (VALEUR.NOMINALE en fran\u00e7ais) dans Excel et Google Sheets permet de calculer le montant re\u00e7u \u00e0 l’\u00e9ch\u00e9ance d’un investissement \u00e0 taux fixe, en prenant en compte d’\u00e9ventuelles taxes ou commissions. Cette fonction est essentielle pour les professionnels de la finance qui \u00e9valuent le rendement des obligations ou des titres similaires.<\/p>\n

Syntaxe :<\/strong><\/p>\n

VALEUR.NOMINALE(date_d\u00e9but, date_\u00e9ch\u00e9ance, investissement, taux_escompte, [base])<\/code><\/pre>\n
    \n
  • date_d\u00e9but<\/code> : la date \u00e0 laquelle l’investissement prend effet (date d’achat du titre).<\/li>\n
  • date_\u00e9ch\u00e9ance<\/code> : la date \u00e0 laquelle le titre arrive \u00e0 \u00e9ch\u00e9ance et le paiement est d\u00fb.<\/li>\n
  • investissement<\/code> : le capital initial investi dans l’achat du titre.<\/li>\n
  • taux_escompte<\/code> : le taux de r\u00e9duction appliqu\u00e9 au titre.<\/li>\n
  • base<\/code> (optionnel) : le syst\u00e8me de comptage des jours utilis\u00e9 pour le calcul, avec 0 par d\u00e9faut.<\/li>\n<\/ul>\n
    Exemple d’Application<\/h2>\n
    Consid\u00e9rons un cas o\u00f9 vous souhaitez d\u00e9terminer le montant re\u00e7u par un investisseur \u00e0 l’\u00e9ch\u00e9ance d’une obligation. Les d\u00e9tails de cette obligation sont les suivants :<\/p>\n
      \n
    • Date de d\u00e9but : 01\/01\/2023<\/li>\n
    • Date d’\u00e9ch\u00e9ance : 01\/01\/2024<\/li>\n
    • Montant de l’investissement : 10 000 \u20ac<\/li>\n
    • Taux d’escompte : 3%<\/li>\n<\/ul>\n
      La formule serait alors :<\/p>\n
      =VALEUR.NOMINALE(DATE(2023,1,1), DATE(2024,1,1), 10000, 0.03)<\/code><\/pre>\n
      Cette formule calculera le montant que l’investisseur percevra \u00e0 la fin de la p\u00e9riode d’un an, apr\u00e8s le calcul du taux d’escompte.<\/p>\n
      Autre Sc\u00e9nario<\/h2>\n
      Imaginons que vous \u00eates charg\u00e9 d’\u00e9valuer la valeur totale re\u00e7ue pour un portefeuille comportant plusieurs obligations diff\u00e9rentes. Voici les caract\u00e9ristiques de ces obligations :<\/p>\n\n\n\n\n
      Date de d\u00e9but<\/th>\nDate d’\u00e9ch\u00e9ance<\/th>\nInvestissement<\/th>\nDiscount<\/th>\n<\/tr>\n
      10\/06\/2023<\/td>\n10\/06\/2024<\/td>\n5000 \u20ac<\/td>\n2.5%<\/td>\n<\/tr>\n
      15\/07\/2023<\/td>\n15\/07\/2024<\/td>\n8000 \u20ac<\/td>\n2.8%<\/td>\n<\/tr>\n<\/table>\n
      Les formules pour calculer le montant \u00e0 recevoir pour chaque obligation seraient :<\/p>\n
      =VALEUR.NOMINALE(DATE(2023,6,10), DATE(2024,6,10), 5000, 0.025)<\/code><\/pre>\n
      =VALEUR.NOMINALE(DATE(2023,7,15), DATE(2024,7,15), 8000, 0.028)<\/code><\/pre>\n
      En sommant les r\u00e9sultats, vous obtiendrez la valeur totale que l’entreprise recevra \u00e0 l’\u00e9ch\u00e9ance de ces obligations.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la valeuR nominale \u00e0 \u00e9ch\u00e9ance d\u2019un effet de commeRce<\/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-6744","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction RECEIVED (VALEUR.NOMINALE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) 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\/received\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction RECEIVED (VALEUR.NOMINALE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/received\/\" \/>\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:51+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction RECEIVED (VALEUR.NOMINALE) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/received\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/received\/\",\"name\":\"Fonction RECEIVED (VALEUR.NOMINALE) 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:51+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/received\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/received\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/received\/#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.NOMINALE\"}]},{\"@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 RECEIVED (VALEUR.NOMINALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) 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\/received\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction RECEIVED (VALEUR.NOMINALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/received\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:12:51+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction RECEIVED (VALEUR.NOMINALE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/received\/","url":"https:\/\/functiontranslator.com\/fr\/received\/","name":"Fonction RECEIVED (VALEUR.NOMINALE) 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:51+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction RECEIVED (VALEUR.NOMINALE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/received\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/received\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/received\/#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.NOMINALE"}]},{"@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\/6744","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=6744"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6744\/revisions"}],"predecessor-version":[{"id":29755,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6744\/revisions\/29755"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}