{"id":6635,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/ispmt\/"},"modified":"2021-02-26T08:09:17","modified_gmt":"2021-02-26T08:09:17","slug":"ispmt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/ispmt\/","title":{"rendered":"ISPMT"},"content":{"rendered":"

La fonction ISPMT<\/strong> est utilis\u00e9e dans Microsoft Excel et Google Sheets pour d\u00e9terminer le montant des int\u00e9r\u00eats pay\u00e9s durant une p\u00e9riode sp\u00e9cifique d’un pr\u00eat \u00e0 taux fixe. Cette fonction s’av\u00e8re extr\u00eamement utile pour la gestion financi\u00e8re, tant personnelle que professionnelle, facilitant la planification des remboursements de pr\u00eats et l’analyse d’investissements.<\/p>\n

Syntaxe de la fonction<\/h2>\n

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

=ISPMT(taux, p\u00e9riode, nper, VA)<\/code><\/pre>\n
    \n
  • taux<\/strong> : Le taux d’int\u00e9r\u00eat par p\u00e9riode.<\/li>\n
  • p\u00e9riode<\/strong> : La p\u00e9riode pour laquelle les int\u00e9r\u00eats sont calcul\u00e9s, entre 1 et nper<\/em>.<\/li>\n
  • nper<\/strong> : Le nombre total de p\u00e9riodes de paiement pour le pr\u00eat ou l’investissement.<\/li>\n
  • VA<\/strong> : La valeur actuelle ou le principal du pr\u00eat.<\/li>\n<\/ul>\n
    Exemples d’utilisation<\/h2>\n
    Consid\u00e9rons un pr\u00eat de 20 000 euros \u00e0 un taux d’int\u00e9r\u00eat annuel de 5%, remboursable sur 4 ans. La fonction ISPMT<\/code> permet de calculer les int\u00e9r\u00eats pay\u00e9s annuellement :<\/p>\n
    =ISPMT(5%\/4, 1, 4, 20000) =ISPMT(5%\/4, 2, 4, 20000) =ISPMT(5%\/4, 3, 4, 20000) =ISPMT(5%\/4, 4, 4, 20000)<\/code><\/pre>\n\n\n\n\n\n\n
    P\u00e9riode<\/th>\nInt\u00e9r\u00eat pay\u00e9<\/th>\n<\/tr>\n
    P\u00e9riode 1<\/td>\n500,00 \u20ac<\/td>\n<\/tr>\n
    P\u00e9riode 2<\/td>\n375,00 \u20ac<\/td>\n<\/tr>\n
    P\u00e9riode 3<\/td>\n250,00 \u20ac<\/td>\n<\/tr>\n
    P\u00e9riode 4<\/td>\n125,00 \u20ac<\/td>\n<\/tr>\n<\/table>\n
    Les r\u00e9sultats indiquent une diminution des int\u00e9r\u00eats pay\u00e9s chaque p\u00e9riode, refl\u00e9tant la r\u00e9duction du capital principal apr\u00e8s chaque paiement.<\/p>\n
    Sc\u00e9narios d’application pratique<\/h2>\n
    Cette fonction peut \u00eatre appliqu\u00e9e dans divers contextes :<\/p>\n
    Analyse de diff\u00e9rents plans de pr\u00eat<\/h2>\n
    L’analyse de divers sc\u00e9narios de pr\u00eat avant de s’engager est b\u00e9n\u00e9fique. Utiliser ISPMT<\/code> pour comparer les charges d’int\u00e9r\u00eat selon diff\u00e9rents taux et dur\u00e9es peut vous aider \u00e0 s\u00e9lectionner l’offre correspondant le mieux \u00e0 votre capacit\u00e9 de remboursement.<\/p>\n
    Planification financi\u00e8re<\/h2>\n
    Comprendre le d\u00e9tail des remboursements en int\u00e9r\u00eats et en capital est essentiel pour ceux qui remboursent un pr\u00eat. ISPMT<\/code> aide \u00e0 anticiper les flux de tr\u00e9sorerie et \u00e0 optimiser la gestion budg\u00e9taire.<\/p>\n
    En r\u00e9sum\u00e9, ISPMT<\/code> est un outil pr\u00e9cieux pour tout gestionnaire de pr\u00eats ou d’investissements. Ma\u00eetriser cette fonction contribue \u00e0 une planification financi\u00e8re plus pr\u00e9cise et \u00e9conomique, r\u00e9duisant les co\u00fbts d’int\u00e9r\u00eats sur le long terme.<\/p>\n","protected":false},"excerpt":{"rendered":"
    CalCule le montant des int\u00e9r\u00eats d\u2019un investissement pour une p\u00e9riode donn\u00e9e<\/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-6635","post","type-post","status-publish","format-standard","hentry","category-finances"],"acf":[],"yoast_head":"\nFonction ISPMT dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ISPMT 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\/ispmt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ISPMT dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ISPMT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/ispmt\/\" \/>\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:09:17+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ISPMT 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\/ispmt\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/ispmt\/\",\"name\":\"Fonction ISPMT 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:09:17+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ISPMT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/ispmt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/ispmt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/ispmt\/#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\":\"ISPMT\"}]},{\"@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 ISPMT dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ISPMT 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\/ispmt\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ISPMT dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ISPMT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/ispmt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:09:17+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ISPMT 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\/ispmt\/","url":"https:\/\/functiontranslator.com\/fr\/ispmt\/","name":"Fonction ISPMT 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:09:17+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ISPMT d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/ispmt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/ispmt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/ispmt\/#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":"ISPMT"}]},{"@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\/6635","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=6635"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6635\/revisions"}],"predecessor-version":[{"id":29646,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6635\/revisions\/29646"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6635"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}