{"id":6483,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/cumul-princper\/"},"modified":"2021-02-26T08:04:16","modified_gmt":"2021-02-26T08:04:16","slug":"cumprinc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/cumprinc\/","title":{"rendered":"CUMUL.PRINCPER"},"content":{"rendered":"

Description g\u00e9n\u00e9rale<\/h2>\n

La fonction CUMPRINC, \u00e9galement nomm\u00e9e CUMUL.PRINCPER dans certains param\u00e8tres r\u00e9gionaux, est utilis\u00e9e pour calculer le principal cumul\u00e9 rembours\u00e9 pour un pr\u00eat sur une plage de p\u00e9riodes sp\u00e9cifi\u00e9es. Elle est essentielle en gestion financi\u00e8re pour \u00e9valuer la progression du remboursement du capital d\u2019un emprunt dans le temps.<\/p>\n

Syntaxe de la fonction<\/h2>\n

Voici la syntaxe de la fonction CUMPRINC :<\/p>\n

CUMPRINC(taux, nper, va, debut_per, fin_per, type)<\/code><\/pre>\n
    \n
  • taux<\/strong> : Taux d’int\u00e9r\u00eat par p\u00e9riode.<\/li>\n
  • nper<\/strong> : Nombre total de p\u00e9riodes de paiement pour le pr\u00eat.<\/li>\n
  • va<\/strong> : Valeur actuelle ou montant du principal du pr\u00eat.<\/li>\n
  • debut_per<\/strong> : Num\u00e9ro de la premi\u00e8re p\u00e9riode pour laquelle le calcul du principal cumul\u00e9 doit \u00eatre effectu\u00e9.<\/li>\n
  • fin_per<\/strong> : Num\u00e9ro de la derni\u00e8re p\u00e9riode pour ce calcul.<\/li>\n
  • type<\/strong> : Indique le moment du paiement dans la p\u00e9riode, 0 pour la fin de la p\u00e9riode, 1 pour le d\u00e9but.<\/li>\n<\/ul>\n
    Exemples d\u2019utilisation<\/h2>\n
    Imaginons un pr\u00eat de 10 000 \u20ac avec un taux d’int\u00e9r\u00eat annuel de 5%, et vous souhaitez d\u00e9terminer le montant du capital rembours\u00e9 entre le premier et le douzi\u00e8me mois, avec des \u00e9ch\u00e9ances mensuelles.<\/p>\n
    =CUMPRINC(5%\/12, 12*5, 10000, 1, 12, 0)<\/code><\/pre>\n
    Cette formule indique le montant total du capital rembours\u00e9 entre ces deux p\u00e9riodes.<\/p>\n
    Sc\u00e9narios pratiques<\/h2>\n
    Comparaison de deux options de financement<\/h2>\n
    Consid\u00e9rez que vous \u00e9valuez deux options de financement pour un nouvel \u00e9quipement. Le pr\u00eat A a un taux de 3% sur 4 ans, tandis que le pr\u00eat B a un taux de 3,5% sur 3 ans. Vous souhaitez comparer le principal rembours\u00e9 durant la premi\u00e8re ann\u00e9e pour chaque option.<\/p>\n
    Pour le pr\u00eat A :<\/p>\n
    =CUMPRINC(3%\/12, 4*12, 20000, 1, 12, 0)<\/code><\/pre>\n
    Pour le pr\u00eat B :<\/p>\n
    =CUMPRINC(3.5%\/12, 3*12, 20000, 1, 12, 0)<\/code><\/pre>\n
    Ces formules vous permettent de voir le capital rembours\u00e9 au cours de la premi\u00e8re ann\u00e9e pour chaque pr\u00eat, facilitant ainsi une d\u00e9cision bien inform\u00e9e.<\/p>\n
    Planification de tr\u00e9sorerie pour un pr\u00eat immobilier<\/h2>\n
    Supposez un pr\u00eat immobilier de 250 000 \u20ac \u00e0 un taux de 4.5% sur 20 ans. Pour planifier vos finances sur 5 ans, vous souhaitez conna\u00eetre le total du capital rembours\u00e9 durant cette p\u00e9riode.<\/p>\n
    =CUMPRINC(4.5%\/12, 20*12, 250000, 1, 60, 0)<\/code><\/pre>\n
    Cette formule vous indique le montant du principal que vous aurez rembours\u00e9 apr\u00e8s cinq ans, ce qui est essentiel pour une planification financi\u00e8re \u00e0 long terme.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le montant cumul\u00e9 des RembouRsements du capital d\u2019un empRunt effectu\u00e9s entRe deux p\u00e9Riodes<\/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-6483","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction CUMPRINC (CUMUL.PRINCPER) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) 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\/cumprinc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction CUMPRINC (CUMUL.PRINCPER) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/cumprinc\/\" \/>\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:04:16+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction CUMPRINC (CUMUL.PRINCPER) 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\/cumprinc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/cumprinc\/\",\"name\":\"Fonction CUMPRINC (CUMUL.PRINCPER) 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:04:16+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/cumprinc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/cumprinc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/cumprinc\/#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\":\"CUMUL.PRINCPER\"}]},{\"@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 CUMPRINC (CUMUL.PRINCPER) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) 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\/cumprinc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction CUMPRINC (CUMUL.PRINCPER) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/cumprinc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:04:16+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction CUMPRINC (CUMUL.PRINCPER) 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\/cumprinc\/","url":"https:\/\/functiontranslator.com\/fr\/cumprinc\/","name":"Fonction CUMPRINC (CUMUL.PRINCPER) 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:04:16+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction CUMPRINC (CUMUL.PRINCPER) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/cumprinc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/cumprinc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/cumprinc\/#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":"CUMUL.PRINCPER"}]},{"@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\/6483","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=6483"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6483\/revisions"}],"predecessor-version":[{"id":29495,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6483\/revisions\/29495"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}